1037 lines
160 KiB
XML
1037 lines
160 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="apcDatabase" targetNamespace="http://tempuri.org/apcDatabase.xsd" xmlns:mstns="http://tempuri.org/apcDatabase.xsd" xmlns="http://tempuri.org/apcDatabase.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="apc___CopyConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="apc___CopyConnectionString2 (Settings)" PropertyReference="ApplicationSettings.AdvertsingProfitControl.Properties.Settings.GlobalReference.Default.apc___CopyConnectionString2" Provider="System.Data.OleDb" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActualSalesTableAdapter" GeneratorDataComponentClassName="ActualSalesTableAdapter" Name="ActualSales" UserDataComponentName="ActualSalesTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="ActualSales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `ActualSales` WHERE ((`AcID` = ?) AND ((? = 1 AND `AcSold` IS NULL) OR (`AcSold` = ?)) AND ((? = 1 AND `AcSalePrice` IS NULL) OR (`AcSalePrice` = ?)) AND ((? = 1 AND `AcTotalSales` IS NULL) OR (`AcTotalSales` = ?)) AND ((? = 1 AND `AcCost` IS NULL) OR (`AcCost` = ?)) AND ((? = 1 AND `AcProfitReturn` IS NULL) OR (`AcProfitReturn` = ?)) AND ((? = 1 AND `AcTotalProfitReturn` IS NULL) OR (`AcTotalProfitReturn` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AcID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcSalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcCost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcTotalProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `ActualSales` (`AcSold`, `AcSalePrice`, `AcTotalSales`, `AcCost`, `AcProfitReturn`, `AcTotalProfitReturn`, `Fk_DateID`, `Fk_AdItemID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcCost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT AcID, AcSold, AcSalePrice, AcTotalSales, AcCost, AcProfitReturn, AcTotalProfitReturn, Fk_DateID, Fk_AdItemID FROM ActualSales</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `ActualSales` SET `AcSold` = ?, `AcSalePrice` = ?, `AcTotalSales` = ?, `AcCost` = ?, `AcProfitReturn` = ?, `AcTotalProfitReturn` = ?, `Fk_DateID` = ?, `Fk_AdItemID` = ? WHERE ((`AcID` = ?) AND ((? = 1 AND `AcSold` IS NULL) OR (`AcSold` = ?)) AND ((? = 1 AND `AcSalePrice` IS NULL) OR (`AcSalePrice` = ?)) AND ((? = 1 AND `AcTotalSales` IS NULL) OR (`AcTotalSales` = ?)) AND ((? = 1 AND `AcCost` IS NULL) OR (`AcCost` = ?)) AND ((? = 1 AND `AcProfitReturn` IS NULL) OR (`AcProfitReturn` = ?)) AND ((? = 1 AND `AcTotalProfitReturn` IS NULL) OR (`AcTotalProfitReturn` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcCost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="AcTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AcID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AcSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSold" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcSalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcSalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcCost" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcCost" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AcTotalProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_AcTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="AcTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="AcID" DataSetColumn="AcID" />
|
|
<Mapping SourceColumn="AcSold" DataSetColumn="AcSold" />
|
|
<Mapping SourceColumn="AcSalePrice" DataSetColumn="AcSalePrice" />
|
|
<Mapping SourceColumn="AcTotalSales" DataSetColumn="AcTotalSales" />
|
|
<Mapping SourceColumn="AcCost" DataSetColumn="AcCost" />
|
|
<Mapping SourceColumn="AcProfitReturn" DataSetColumn="AcProfitReturn" />
|
|
<Mapping SourceColumn="AcTotalProfitReturn" DataSetColumn="AcTotalProfitReturn" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
<Mapping SourceColumn="Fk_AdItemID" DataSetColumn="Fk_AdItemID" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="ActualSales" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDateID" GetMethodModifier="Public" GetMethodName="GetDataByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDateID" UserSourceName="GetDataByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AcSold, AcSalePrice, AcTotalSales, AcCost, AcProfitReturn, AcTotalProfitReturn, Fk_AdItemID
|
|
FROM ActualSales
|
|
WHERE (Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="ActualSales" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="ReturnInventoryAndActualSales" GetMethodModifier="Public" GetMethodName="ReturnInventoryAndActualSales" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnInventoryAndActualSales" UserSourceName="ReturnInventoryAndActualSales">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AdItem.AdItem, Inventory.InvBeginingInventory, Inventory.InvRecieved, Inventory.InvTotal, Inventory.InvEnding, ActualSales.AcSold, ActualSales.AcSalePrice,
|
|
ActualSales.AcTotalSales, ActualSales.AcCost, ActualSales.AcProfitReturn, ActualSales.AcTotalProfitReturn
|
|
FROM ((AdItem INNER JOIN
|
|
Inventory ON AdItem.AdItemID = Inventory.Fk_AdItemID) INNER JOIN
|
|
ActualSales ON Inventory.Fk_AdItemID = ActualSales.Fk_AdItemID)
|
|
WHERE (Inventory.Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="Inventory" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="ReturnSalesByDateID" GetMethodModifier="Public" GetMethodName="ReturnSalesByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnSalesByDateID" UserSourceName="ReturnSalesByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AdItem.AdItem, ActualSales.AcSold, ActualSales.AcSalePrice, ActualSales.AcTotalSales, ActualSales.AcCost, ActualSales.AcProfitReturn,
|
|
ActualSales.AcTotalProfitReturn
|
|
FROM (AdItem INNER JOIN
|
|
ActualSales ON AdItem.AdItemID = ActualSales.Fk_AdItemID)
|
|
WHERE (ActualSales.Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="ActualSales" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdItemTableAdapter" GeneratorDataComponentClassName="AdItemTableAdapter" Name="AdItem" UserDataComponentName="AdItemTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="AdItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `AdItem` WHERE ((`AdItemID` = ?) AND ((? = 1 AND `AdItem` IS NULL) OR (`AdItem` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AdItem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_AdItem" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `AdItem` (`AdItem`) VALUES (?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AdItem" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT AdItemID, AdItem FROM AdItem</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `AdItem` SET `AdItem` = ? WHERE ((`AdItemID` = ?) AND ((? = 1 AND `AdItem` IS NULL) OR (`AdItem` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AdItem" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AdItem" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_AdItem" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AdItem" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="AdItemID" DataSetColumn="AdItemID" />
|
|
<Mapping SourceColumn="AdItem" DataSetColumn="AdItem" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="AdItem" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="ReturnAdItemsByDate" GetMethodModifier="Public" GetMethodName="ReturnAdItemsByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnAdItemsByDate" UserSourceName="ReturnAdItemsByDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AdItem.AdItem
|
|
FROM ((AdItem INNER JOIN
|
|
ProjectedSales ON AdItem.AdItemID = ProjectedSales.Fk_AdItemID) INNER JOIN
|
|
WeekEndingDate ON ProjectedSales.Fk_DateID = WeekEndingDate.DateID)
|
|
WHERE (WeekEndingDate.DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DateID" DataSourceName="WeekEndingDate" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CommentTableAdapter" GeneratorDataComponentClassName="CommentTableAdapter" Name="Comment" UserDataComponentName="CommentTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Comment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `Comment` WHERE ((`CommnetID` = ?) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CommnetID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CommnetID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `Comment` (`Comment`, `Fk_DateID`) VALUES (?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT CommnetID, Comment, Fk_DateID FROM Comment</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `Comment` SET `Comment` = ?, `Fk_DateID` = ? WHERE ((`CommnetID` = ?) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comment" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_CommnetID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CommnetID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CommnetID" DataSetColumn="CommnetID" />
|
|
<Mapping SourceColumn="Comment" DataSetColumn="Comment" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Comment" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDateID" GetMethodModifier="Public" GetMethodName="GetDataByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDateID" UserSourceName="GetDataByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT Comment
|
|
FROM Comment
|
|
WHERE Fk_DateID = ?</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="Comment" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InventoryTableAdapter" GeneratorDataComponentClassName="InventoryTableAdapter" Name="Inventory" UserDataComponentName="InventoryTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Inventory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `Inventory` WHERE ((`InvID` = ?) AND ((? = 1 AND `InvBeginingInventory` IS NULL) OR (`InvBeginingInventory` = ?)) AND ((? = 1 AND `InvRecieved` IS NULL) OR (`InvRecieved` = ?)) AND ((? = 1 AND `InvTotal` IS NULL) OR (`InvTotal` = ?)) AND ((? = 1 AND `InvEnding` IS NULL) OR (`InvEnding` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `InvNote` IS NULL) OR (`InvNote` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvNote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `Inventory` (`InvBeginingInventory`, `InvRecieved`, `InvTotal`, `InvEnding`, `Fk_AdItemID`, `Fk_DateID`, `InvNote`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT InvID, InvBeginingInventory, InvRecieved, InvTotal, InvEnding, Fk_AdItemID, Fk_DateID, InvNote FROM Inventory</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `Inventory` SET `InvBeginingInventory` = ?, `InvRecieved` = ?, `InvTotal` = ?, `InvEnding` = ?, `Fk_AdItemID` = ?, `Fk_DateID` = ?, `InvNote` = ? WHERE ((`InvID` = ?) AND ((? = 1 AND `InvBeginingInventory` IS NULL) OR (`InvBeginingInventory` = ?)) AND ((? = 1 AND `InvRecieved` IS NULL) OR (`InvRecieved` = ?)) AND ((? = 1 AND `InvTotal` IS NULL) OR (`InvTotal` = ?)) AND ((? = 1 AND `InvEnding` IS NULL) OR (`InvEnding` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `InvNote` IS NULL) OR (`InvNote` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvBeginingInventory" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvBeginingInventory" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvRecieved" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvRecieved" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvTotal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvEnding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvEnding" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvNote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvNote" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="InvID" DataSetColumn="InvID" />
|
|
<Mapping SourceColumn="InvBeginingInventory" DataSetColumn="InvBeginingInventory" />
|
|
<Mapping SourceColumn="InvRecieved" DataSetColumn="InvRecieved" />
|
|
<Mapping SourceColumn="InvTotal" DataSetColumn="InvTotal" />
|
|
<Mapping SourceColumn="InvEnding" DataSetColumn="InvEnding" />
|
|
<Mapping SourceColumn="Fk_AdItemID" DataSetColumn="Fk_AdItemID" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
<Mapping SourceColumn="InvNote" DataSetColumn="InvNote" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Inventory" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetInventoryByDateID" GetMethodModifier="Public" GetMethodName="GetInventoryByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetInventoryByDateID" UserSourceName="GetInventoryByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AdItem.AdItem, Inventory.InvBeginingInventory, Inventory.InvRecieved, Inventory.InvTotal, Inventory.InvEnding
|
|
FROM (Inventory INNER JOIN
|
|
AdItem ON Inventory.Fk_AdItemID = AdItem.AdItemID)
|
|
WHERE (Inventory.Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="Inventory" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InvoiceTableAdapter" GeneratorDataComponentClassName="InvoiceTableAdapter" Name="Invoice" UserDataComponentName="InvoiceTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Invoice" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `Invoice` WHERE ((`InvoiceID` = ?) AND ((? = 1 AND `InvoiceNetAmountAtCost` IS NULL) OR (`InvoiceNetAmountAtCost` = ?)) AND ((? = 1 AND `InvoiceAmountOf` IS NULL) OR (`InvoiceAmountOf` = ?)) AND ((? = 1 AND `InvoiceDate` IS NULL) OR (`InvoiceDate` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_SupplierID` IS NULL) OR (`Fk_SupplierID` = ?)) AND ((? = 1 AND `InvoiceNumber` IS NULL) OR (`InvoiceNumber` = ?)) AND ((? = 1 AND `InvoiceNote` IS NULL) OR (`InvoiceNote` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvoiceNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvoiceNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `Invoice` (`InvoiceNetAmountAtCost`, `InvoiceAmountOf`, `InvoiceDate`, `Fk_DateID`, `Fk_SupplierID`, `InvoiceNumber`, `InvoiceNote`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvoiceNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvoiceNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT InvoiceID, InvoiceNetAmountAtCost, InvoiceAmountOf, InvoiceDate, Fk_DateID, Fk_SupplierID, InvoiceNumber, InvoiceNote FROM Invoice</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `Invoice` SET `InvoiceNetAmountAtCost` = ?, `InvoiceAmountOf` = ?, `InvoiceDate` = ?, `Fk_DateID` = ?, `Fk_SupplierID` = ?, `InvoiceNumber` = ?, `InvoiceNote` = ? WHERE ((`InvoiceID` = ?) AND ((? = 1 AND `InvoiceNetAmountAtCost` IS NULL) OR (`InvoiceNetAmountAtCost` = ?)) AND ((? = 1 AND `InvoiceAmountOf` IS NULL) OR (`InvoiceAmountOf` = ?)) AND ((? = 1 AND `InvoiceDate` IS NULL) OR (`InvoiceDate` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_SupplierID` IS NULL) OR (`Fk_SupplierID` = ?)) AND ((? = 1 AND `InvoiceNumber` IS NULL) OR (`InvoiceNumber` = ?)) AND ((? = 1 AND `InvoiceNote` IS NULL) OR (`InvoiceNote` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvoiceNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InvoiceNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceNetAmountAtCost" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNetAmountAtCost" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_InvoiceAmountOf" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceAmountOf" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_InvoiceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNumber" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvoiceNumber" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InvoiceNote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_InvoiceNote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="InvoiceNote" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="InvoiceID" DataSetColumn="InvoiceID" />
|
|
<Mapping SourceColumn="InvoiceNetAmountAtCost" DataSetColumn="InvoiceNetAmountAtCost" />
|
|
<Mapping SourceColumn="InvoiceAmountOf" DataSetColumn="InvoiceAmountOf" />
|
|
<Mapping SourceColumn="InvoiceDate" DataSetColumn="InvoiceDate" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
<Mapping SourceColumn="Fk_SupplierID" DataSetColumn="Fk_SupplierID" />
|
|
<Mapping SourceColumn="InvoiceNumber" DataSetColumn="InvoiceNumber" />
|
|
<Mapping SourceColumn="InvoiceNote" DataSetColumn="InvoiceNote" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Invoice" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDateID" GetMethodModifier="Public" GetMethodName="GetDataByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDateID" UserSourceName="GetDataByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT InvoiceNetAmountAtCost, InvoiceAmountOf, InvoiceDate, InvoiceNumber, Fk_SupplierID
|
|
FROM Invoice
|
|
WHERE (Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="Invoice" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectedSalesTableAdapter" GeneratorDataComponentClassName="ProjectedSalesTableAdapter" Name="ProjectedSales" UserDataComponentName="ProjectedSalesTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="ProjectedSales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `ProjectedSales` WHERE ((`PrSalesID` = ?) AND ((? = 1 AND `PrSold` IS NULL) OR (`PrSold` = ?)) AND ((? = 1 AND `PrSalePrice` IS NULL) OR (`PrSalePrice` = ?)) AND ((? = 1 AND `PrProfitReturn` IS NULL) OR (`PrProfitReturn` = ?)) AND ((? = 1 AND `PrTotalProfitReturn` IS NULL) OR (`PrTotalProfitReturn` = ?)) AND ((? = 1 AND `PrTotalSales` IS NULL) OR (`PrTotalSales` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrSalesID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSalesID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrSalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrTotalProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `ProjectedSales` (`PrSold`, `PrSalePrice`, `PrProfitReturn`, `PrTotalProfitReturn`, `PrTotalSales`, `Fk_DateID`, `Fk_AdItemID`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT PrSalesID, PrSold, PrSalePrice, PrProfitReturn, PrTotalProfitReturn, PrTotalSales, Fk_DateID, Fk_AdItemID FROM ProjectedSales</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `ProjectedSales` SET `PrSold` = ?, `PrSalePrice` = ?, `PrProfitReturn` = ?, `PrTotalProfitReturn` = ?, `PrTotalSales` = ?, `Fk_DateID` = ?, `Fk_AdItemID` = ? WHERE ((`PrSalesID` = ?) AND ((? = 1 AND `PrSold` IS NULL) OR (`PrSold` = ?)) AND ((? = 1 AND `PrSalePrice` IS NULL) OR (`PrSalePrice` = ?)) AND ((? = 1 AND `PrProfitReturn` IS NULL) OR (`PrProfitReturn` = ?)) AND ((? = 1 AND `PrTotalProfitReturn` IS NULL) OR (`PrTotalProfitReturn` = ?)) AND ((? = 1 AND `PrTotalSales` IS NULL) OR (`PrTotalSales` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)) AND ((? = 1 AND `Fk_AdItemID` IS NULL) OR (`Fk_AdItemID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="PrTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrSalesID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSalesID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrSold" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSold" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrSalePrice" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrSalePrice" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrSalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrTotalProfitReturn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrTotalProfitReturn" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalProfitReturn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_PrTotalSales" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="PrTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_AdItemID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_AdItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="PrSalesID" DataSetColumn="PrSalesID" />
|
|
<Mapping SourceColumn="PrSold" DataSetColumn="PrSold" />
|
|
<Mapping SourceColumn="PrSalePrice" DataSetColumn="PrSalePrice" />
|
|
<Mapping SourceColumn="PrProfitReturn" DataSetColumn="PrProfitReturn" />
|
|
<Mapping SourceColumn="PrTotalProfitReturn" DataSetColumn="PrTotalProfitReturn" />
|
|
<Mapping SourceColumn="PrTotalSales" DataSetColumn="PrTotalSales" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
<Mapping SourceColumn="Fk_AdItemID" DataSetColumn="Fk_AdItemID" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="ProjectedSales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjections" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjections" GeneratorSourceName="FillByProjections" GetMethodModifier="Public" GetMethodName="GetDataByProjections" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjections" UserSourceName="FillByProjections">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT AdItem.AdItem, ProjectedSales.PrSold, ProjectedSales.PrSalePrice, ProjectedSales.PrTotalSales, ProjectedSales.PrCost, ProjectedSales.PrProfitReturn,
|
|
ProjectedSales.PrTotalProfitReturn
|
|
FROM (AdItem INNER JOIN
|
|
ProjectedSales ON AdItem.AdItemID = ProjectedSales.Fk_AdItemID)
|
|
WHERE (ProjectedSales.Fk_DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="ProjectedSales" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierTableAdapter" GeneratorDataComponentClassName="SupplierTableAdapter" Name="Supplier" UserDataComponentName="SupplierTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="Supplier" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `Supplier` WHERE ((`SupplierID` = ?) AND ((? = 1 AND `SupplierName` IS NULL) OR (`SupplierName` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SupplierName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SupplierName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `Supplier` (`SupplierName`) VALUES (?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SupplierName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT SupplierID, SupplierName FROM Supplier</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `Supplier` SET `SupplierName` = ? WHERE ((`SupplierID` = ?) AND ((? = 1 AND `SupplierName` IS NULL) OR (`SupplierName` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SupplierName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_SupplierID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SupplierName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SupplierName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="SupplierID" DataSetColumn="SupplierID" />
|
|
<Mapping SourceColumn="SupplierName" DataSetColumn="SupplierName" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WeekEndingDateTableAdapter" GeneratorDataComponentClassName="WeekEndingDateTableAdapter" Name="WeekEndingDate" UserDataComponentName="WeekEndingDateTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeekEndingDate" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `WeekEndingDate` WHERE ((`DateID` = ?) AND ((? = 1 AND `EndOfWeekDate` IS NULL) OR (`EndOfWeekDate` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EndOfWeekDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EndOfWeekDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `WeekEndingDate` (`EndOfWeekDate`) VALUES (?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EndOfWeekDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT DateID, EndOfWeekDate FROM WeekEndingDate</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `WeekEndingDate` SET `EndOfWeekDate` = ? WHERE ((`DateID` = ?) AND ((? = 1 AND `EndOfWeekDate` IS NULL) OR (`EndOfWeekDate` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EndOfWeekDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EndOfWeekDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EndOfWeekDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DateID" DataSetColumn="DateID" />
|
|
<Mapping SourceColumn="EndOfWeekDate" DataSetColumn="EndOfWeekDate" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillWithWICTable" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="ReturnWICTable" GeneratorSourceName="FillWithWICTable" GetMethodModifier="Public" GetMethodName="ReturnWICTable" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnWICTable" UserSourceName="FillWithWICTable">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT WeekEndingDate.EndOfWeekDate, Invoice.InvoiceNetAmountAtCost, Invoice.InvoiceAmountOf, Invoice.InvoiceDate, Invoice.InvoiceNumber, Supplier.SupplierName,
|
|
WeeklySales.Sunday, WeeklySales.Monday, WeeklySales.Tuesday, WeeklySales.Wednesday, WeeklySales.Thursday, WeeklySales.Friday,
|
|
WeeklySales.Saturday, WeeklySales.WeeklyTotalSales
|
|
FROM (((WeekEndingDate INNER JOIN
|
|
Invoice ON WeekEndingDate.DateID = Invoice.Fk_DateID) INNER JOIN
|
|
WeeklySales ON WeekEndingDate.DateID = WeeklySales.Fk_DateID) INNER JOIN
|
|
Supplier ON Invoice.Fk_SupplierID = Supplier.SupplierID)
|
|
WHERE (WeekEndingDate.DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DateID" DataSourceName="WeekEndingDate" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeekEndingDate" DbObjectType="Table" GenerateShortCommands="true" GeneratorGetMethodName="ReturnRecentDate" GeneratorSourceName="GetMostRecentDate" Modifier="Public" Name="GetMostRecentDate" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetMostRecentDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DateID
|
|
FROM WeekEndingDate
|
|
WHERE (EndOfWeekDate =
|
|
(SELECT MAX(EndOfWeekDate) AS Expr1
|
|
FROM WeekEndingDate WeekEndingDate_1))</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeekEndingDate" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="ReturnDate" GetMethodModifier="Public" GetMethodName="ReturnDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnDate" UserSourceName="ReturnDate">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT EndOfWeekDate
|
|
FROM WeekEndingDate
|
|
WHERE (DateID = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DateID" DataSourceName="WeekEndingDate" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeekEndingDate" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="ReturnDateIDByDateString" GetMethodModifier="Public" GetMethodName="ReturnDateIDByDateString" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="ReturnDateIDByDateString" UserSourceName="ReturnDateIDByDateString">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT DateID, EndOfWeekDate
|
|
FROM WeekEndingDate
|
|
WHERE (EndOfWeekDate = ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="EndOfWeekDate" DataSourceName="WeekEndingDate" DataTypeServer="DbType.Date" DbType="String" Direction="Input" ParameterName="EndOfWeekDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EndOfWeekDate" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WeeklySalesTableAdapter" GeneratorDataComponentClassName="WeeklySalesTableAdapter" Name="WeeklySales" UserDataComponentName="WeeklySalesTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeeklySales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `WeeklySales` WHERE ((`WeeklyID` = ?) AND ((? = 1 AND `Sunday` IS NULL) OR (`Sunday` = ?)) AND ((? = 1 AND `Monday` IS NULL) OR (`Monday` = ?)) AND ((? = 1 AND `Tuesday` IS NULL) OR (`Tuesday` = ?)) AND ((? = 1 AND `Wednesday` IS NULL) OR (`Wednesday` = ?)) AND ((? = 1 AND `Thursday` IS NULL) OR (`Thursday` = ?)) AND ((? = 1 AND `Friday` IS NULL) OR (`Friday` = ?)) AND ((? = 1 AND `Saturday` IS NULL) OR (`Saturday` = ?)) AND ((? = 1 AND `WeeklyTotalSales` IS NULL) OR (`WeeklyTotalSales` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WeeklyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `WeeklySales` (`Sunday`, `Monday`, `Tuesday`, `Wednesday`, `Thursday`, `Friday`, `Saturday`, `WeeklyTotalSales`, `Fk_DateID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT WeeklyID, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, WeeklyTotalSales, Fk_DateID FROM WeeklySales</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `WeeklySales` SET `Sunday` = ?, `Monday` = ?, `Tuesday` = ?, `Wednesday` = ?, `Thursday` = ?, `Friday` = ?, `Saturday` = ?, `WeeklyTotalSales` = ?, `Fk_DateID` = ? WHERE ((`WeeklyID` = ?) AND ((? = 1 AND `Sunday` IS NULL) OR (`Sunday` = ?)) AND ((? = 1 AND `Monday` IS NULL) OR (`Monday` = ?)) AND ((? = 1 AND `Tuesday` IS NULL) OR (`Tuesday` = ?)) AND ((? = 1 AND `Wednesday` IS NULL) OR (`Wednesday` = ?)) AND ((? = 1 AND `Thursday` IS NULL) OR (`Thursday` = ?)) AND ((? = 1 AND `Friday` IS NULL) OR (`Friday` = ?)) AND ((? = 1 AND `Saturday` IS NULL) OR (`Saturday` = ?)) AND ((? = 1 AND `WeeklyTotalSales` IS NULL) OR (`WeeklyTotalSales` = ?)) AND ((? = 1 AND `Fk_DateID` IS NULL) OR (`Fk_DateID` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WeeklyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Sunday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Monday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Tuesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Wednesday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Thursday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Friday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Saturday" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WeeklyTotalSales" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WeeklyTotalSales" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Fk_DateID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="WeeklyID" DataSetColumn="WeeklyID" />
|
|
<Mapping SourceColumn="Sunday" DataSetColumn="Sunday" />
|
|
<Mapping SourceColumn="Monday" DataSetColumn="Monday" />
|
|
<Mapping SourceColumn="Tuesday" DataSetColumn="Tuesday" />
|
|
<Mapping SourceColumn="Wednesday" DataSetColumn="Wednesday" />
|
|
<Mapping SourceColumn="Thursday" DataSetColumn="Thursday" />
|
|
<Mapping SourceColumn="Friday" DataSetColumn="Friday" />
|
|
<Mapping SourceColumn="Saturday" DataSetColumn="Saturday" />
|
|
<Mapping SourceColumn="WeeklyTotalSales" DataSetColumn="WeeklyTotalSales" />
|
|
<Mapping SourceColumn="Fk_DateID" DataSetColumn="Fk_DateID" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="apc___CopyConnectionString2 (Settings)" DbObjectName="WeeklySales" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDateID" GetMethodModifier="Public" GetMethodName="GetDataByDateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDateID" UserSourceName="GetDataByDateID">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, WeeklyTotalSales
|
|
FROM WeeklySales
|
|
WHERE Fk_DateID = ?</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Fk_DateID" DataSourceName="WeeklySales" DataTypeServer="DbType.Int32" DbType="String" Direction="Input" ParameterName="Fk_DateID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fk_DateID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="apcDatabase" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="apcDatabase" msprop:Generator_UserDSName="apcDatabase">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="ActualSales" msprop:Generator_TableClassName="ActualSalesDataTable" msprop:Generator_TableVarName="tableActualSales" msprop:Generator_TablePropName="ActualSales" msprop:Generator_RowDeletingName="ActualSalesRowDeleting" msprop:Generator_RowChangingName="ActualSalesRowChanging" msprop:Generator_RowEvHandlerName="ActualSalesRowChangeEventHandler" msprop:Generator_RowDeletedName="ActualSalesRowDeleted" msprop:Generator_UserTableName="ActualSales" msprop:Generator_RowChangedName="ActualSalesRowChanged" msprop:Generator_RowEvArgName="ActualSalesRowChangeEvent" msprop:Generator_RowClassName="ActualSalesRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="AcID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAcID" msprop:Generator_ColumnPropNameInRow="AcID" msprop:Generator_ColumnPropNameInTable="AcIDColumn" msprop:Generator_UserColumnName="AcID" type="xs:int" />
|
|
<xs:element name="AcSold" msprop:Generator_ColumnVarNameInTable="columnAcSold" msprop:Generator_ColumnPropNameInRow="AcSold" msprop:Generator_ColumnPropNameInTable="AcSoldColumn" msprop:Generator_UserColumnName="AcSold" type="xs:int" minOccurs="0" />
|
|
<xs:element name="AcSalePrice" msprop:Generator_ColumnVarNameInTable="columnAcSalePrice" msprop:Generator_ColumnPropNameInRow="AcSalePrice" msprop:Generator_ColumnPropNameInTable="AcSalePriceColumn" msprop:Generator_UserColumnName="AcSalePrice" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="AcTotalSales" msprop:Generator_ColumnVarNameInTable="columnAcTotalSales" msprop:Generator_ColumnPropNameInRow="AcTotalSales" msprop:Generator_ColumnPropNameInTable="AcTotalSalesColumn" msprop:Generator_UserColumnName="AcTotalSales" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="AcCost" msprop:Generator_ColumnVarNameInTable="columnAcCost" msprop:Generator_ColumnPropNameInRow="AcCost" msprop:Generator_ColumnPropNameInTable="AcCostColumn" msprop:Generator_UserColumnName="AcCost" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="AcProfitReturn" msprop:Generator_ColumnVarNameInTable="columnAcProfitReturn" msprop:Generator_ColumnPropNameInRow="AcProfitReturn" msprop:Generator_ColumnPropNameInTable="AcProfitReturnColumn" msprop:Generator_UserColumnName="AcProfitReturn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="AcTotalProfitReturn" msprop:Generator_ColumnVarNameInTable="columnAcTotalProfitReturn" msprop:Generator_ColumnPropNameInRow="AcTotalProfitReturn" msprop:Generator_ColumnPropNameInTable="AcTotalProfitReturnColumn" msprop:Generator_UserColumnName="AcTotalProfitReturn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_AdItemID" msprop:Generator_ColumnVarNameInTable="columnFk_AdItemID" msprop:Generator_ColumnPropNameInRow="Fk_AdItemID" msprop:Generator_ColumnPropNameInTable="Fk_AdItemIDColumn" msprop:Generator_UserColumnName="Fk_AdItemID" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="AdItem" msprop:Generator_TableClassName="AdItemDataTable" msprop:Generator_TableVarName="tableAdItem" msprop:Generator_TablePropName="AdItem" msprop:Generator_RowDeletingName="AdItemRowDeleting" msprop:Generator_RowChangingName="AdItemRowChanging" msprop:Generator_RowEvHandlerName="AdItemRowChangeEventHandler" msprop:Generator_RowDeletedName="AdItemRowDeleted" msprop:Generator_UserTableName="AdItem" msprop:Generator_RowChangedName="AdItemRowChanged" msprop:Generator_RowEvArgName="AdItemRowChangeEvent" msprop:Generator_RowClassName="AdItemRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="AdItemID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAdItemID" msprop:Generator_ColumnPropNameInRow="AdItemID" msprop:Generator_ColumnPropNameInTable="AdItemIDColumn" msprop:Generator_UserColumnName="AdItemID" type="xs:int" />
|
|
<xs:element name="AdItem" msprop:Generator_ColumnVarNameInTable="columnAdItem" msprop:Generator_ColumnPropNameInRow="AdItem" msprop:Generator_ColumnPropNameInTable="AdItemColumn" msprop:Generator_UserColumnName="AdItem" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Comment" msprop:Generator_TableClassName="CommentDataTable" msprop:Generator_TableVarName="tableComment" msprop:Generator_TablePropName="Comment" msprop:Generator_RowDeletingName="CommentRowDeleting" msprop:Generator_RowChangingName="CommentRowChanging" msprop:Generator_RowEvHandlerName="CommentRowChangeEventHandler" msprop:Generator_RowDeletedName="CommentRowDeleted" msprop:Generator_UserTableName="Comment" msprop:Generator_RowChangedName="CommentRowChanged" msprop:Generator_RowEvArgName="CommentRowChangeEvent" msprop:Generator_RowClassName="CommentRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CommnetID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCommnetID" msprop:Generator_ColumnPropNameInRow="CommnetID" msprop:Generator_ColumnPropNameInTable="CommnetIDColumn" msprop:Generator_UserColumnName="CommnetID" type="xs:int" />
|
|
<xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Inventory" msprop:Generator_TableClassName="InventoryDataTable" msprop:Generator_TableVarName="tableInventory" msprop:Generator_TablePropName="Inventory" msprop:Generator_RowDeletingName="InventoryRowDeleting" msprop:Generator_RowChangingName="InventoryRowChanging" msprop:Generator_RowEvHandlerName="InventoryRowChangeEventHandler" msprop:Generator_RowDeletedName="InventoryRowDeleted" msprop:Generator_UserTableName="Inventory" msprop:Generator_RowChangedName="InventoryRowChanged" msprop:Generator_RowEvArgName="InventoryRowChangeEvent" msprop:Generator_RowClassName="InventoryRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="InvID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnInvID" msprop:Generator_ColumnPropNameInRow="InvID" msprop:Generator_ColumnPropNameInTable="InvIDColumn" msprop:Generator_UserColumnName="InvID" type="xs:int" />
|
|
<xs:element name="InvBeginingInventory" msprop:Generator_ColumnVarNameInTable="columnInvBeginingInventory" msprop:Generator_ColumnPropNameInRow="InvBeginingInventory" msprop:Generator_ColumnPropNameInTable="InvBeginingInventoryColumn" msprop:Generator_UserColumnName="InvBeginingInventory" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvRecieved" msprop:Generator_ColumnVarNameInTable="columnInvRecieved" msprop:Generator_ColumnPropNameInRow="InvRecieved" msprop:Generator_ColumnPropNameInTable="InvRecievedColumn" msprop:Generator_UserColumnName="InvRecieved" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvTotal" msprop:Generator_ColumnVarNameInTable="columnInvTotal" msprop:Generator_ColumnPropNameInRow="InvTotal" msprop:Generator_ColumnPropNameInTable="InvTotalColumn" msprop:Generator_UserColumnName="InvTotal" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvEnding" msprop:Generator_ColumnVarNameInTable="columnInvEnding" msprop:Generator_ColumnPropNameInRow="InvEnding" msprop:Generator_ColumnPropNameInTable="InvEndingColumn" msprop:Generator_UserColumnName="InvEnding" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_AdItemID" msprop:Generator_ColumnVarNameInTable="columnFk_AdItemID" msprop:Generator_ColumnPropNameInRow="Fk_AdItemID" msprop:Generator_ColumnPropNameInTable="Fk_AdItemIDColumn" msprop:Generator_UserColumnName="Fk_AdItemID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvNote" msprop:Generator_ColumnVarNameInTable="columnInvNote" msprop:Generator_ColumnPropNameInRow="InvNote" msprop:Generator_ColumnPropNameInTable="InvNoteColumn" msprop:Generator_UserColumnName="InvNote" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Invoice" msprop:Generator_TableClassName="InvoiceDataTable" msprop:Generator_TableVarName="tableInvoice" msprop:Generator_TablePropName="Invoice" msprop:Generator_RowDeletingName="InvoiceRowDeleting" msprop:Generator_RowChangingName="InvoiceRowChanging" msprop:Generator_RowEvHandlerName="InvoiceRowChangeEventHandler" msprop:Generator_RowDeletedName="InvoiceRowDeleted" msprop:Generator_UserTableName="Invoice" msprop:Generator_RowChangedName="InvoiceRowChanged" msprop:Generator_RowEvArgName="InvoiceRowChangeEvent" msprop:Generator_RowClassName="InvoiceRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="InvoiceID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnInvoiceID" msprop:Generator_ColumnPropNameInRow="InvoiceID" msprop:Generator_ColumnPropNameInTable="InvoiceIDColumn" msprop:Generator_UserColumnName="InvoiceID" type="xs:int" />
|
|
<xs:element name="InvoiceNetAmountAtCost" msprop:Generator_ColumnVarNameInTable="columnInvoiceNetAmountAtCost" msprop:Generator_ColumnPropNameInRow="InvoiceNetAmountAtCost" msprop:Generator_ColumnPropNameInTable="InvoiceNetAmountAtCostColumn" msprop:Generator_UserColumnName="InvoiceNetAmountAtCost" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvoiceAmountOf" msprop:Generator_ColumnVarNameInTable="columnInvoiceAmountOf" msprop:Generator_ColumnPropNameInRow="InvoiceAmountOf" msprop:Generator_ColumnPropNameInTable="InvoiceAmountOfColumn" msprop:Generator_UserColumnName="InvoiceAmountOf" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvoiceDate" msprop:Generator_ColumnVarNameInTable="columnInvoiceDate" msprop:Generator_ColumnPropNameInRow="InvoiceDate" msprop:Generator_ColumnPropNameInTable="InvoiceDateColumn" msprop:Generator_UserColumnName="InvoiceDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_SupplierID" msprop:Generator_ColumnVarNameInTable="columnFk_SupplierID" msprop:Generator_ColumnPropNameInRow="Fk_SupplierID" msprop:Generator_ColumnPropNameInTable="Fk_SupplierIDColumn" msprop:Generator_UserColumnName="Fk_SupplierID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="InvoiceNumber" msprop:Generator_ColumnVarNameInTable="columnInvoiceNumber" msprop:Generator_ColumnPropNameInRow="InvoiceNumber" msprop:Generator_ColumnPropNameInTable="InvoiceNumberColumn" msprop:Generator_UserColumnName="InvoiceNumber" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="InvoiceNote" msprop:Generator_ColumnVarNameInTable="columnInvoiceNote" msprop:Generator_ColumnPropNameInRow="InvoiceNote" msprop:Generator_ColumnPropNameInTable="InvoiceNoteColumn" msprop:Generator_UserColumnName="InvoiceNote" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="ProjectedSales" msprop:Generator_TableClassName="ProjectedSalesDataTable" msprop:Generator_TableVarName="tableProjectedSales" msprop:Generator_TablePropName="ProjectedSales" msprop:Generator_RowDeletingName="ProjectedSalesRowDeleting" msprop:Generator_RowChangingName="ProjectedSalesRowChanging" msprop:Generator_RowEvHandlerName="ProjectedSalesRowChangeEventHandler" msprop:Generator_RowDeletedName="ProjectedSalesRowDeleted" msprop:Generator_UserTableName="ProjectedSales" msprop:Generator_RowChangedName="ProjectedSalesRowChanged" msprop:Generator_RowEvArgName="ProjectedSalesRowChangeEvent" msprop:Generator_RowClassName="ProjectedSalesRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="PrSalesID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPrSalesID" msprop:Generator_ColumnPropNameInRow="PrSalesID" msprop:Generator_ColumnPropNameInTable="PrSalesIDColumn" msprop:Generator_UserColumnName="PrSalesID" type="xs:int" />
|
|
<xs:element name="PrSold" msdata:Caption="Sold" msprop:Generator_ColumnVarNameInTable="columnPrSold" msprop:Generator_ColumnPropNameInRow="PrSold" msprop:Generator_ColumnPropNameInTable="PrSoldColumn" msprop:Generator_UserColumnName="PrSold" type="xs:int" minOccurs="0" />
|
|
<xs:element name="PrSalePrice" msdata:Caption="Sales Price" msprop:Generator_ColumnVarNameInTable="columnPrSalePrice" msprop:Generator_ColumnPropNameInRow="PrSalePrice" msprop:Generator_ColumnPropNameInTable="PrSalePriceColumn" msprop:Generator_UserColumnName="PrSalePrice" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="PrProfitReturn" msdata:Caption="Profit Return" msprop:Generator_ColumnVarNameInTable="columnPrProfitReturn" msprop:Generator_ColumnPropNameInRow="PrProfitReturn" msprop:Generator_ColumnPropNameInTable="PrProfitReturnColumn" msprop:Generator_UserColumnName="PrProfitReturn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="PrTotalProfitReturn" msdata:Caption="Total Profit Return" msprop:Generator_ColumnVarNameInTable="columnPrTotalProfitReturn" msprop:Generator_ColumnPropNameInRow="PrTotalProfitReturn" msprop:Generator_ColumnPropNameInTable="PrTotalProfitReturnColumn" msprop:Generator_UserColumnName="PrTotalProfitReturn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="PrTotalSales" msdata:Caption="Total Sales" msprop:Generator_ColumnVarNameInTable="columnPrTotalSales" msprop:Generator_ColumnPropNameInRow="PrTotalSales" msprop:Generator_ColumnPropNameInTable="PrTotalSalesColumn" msprop:Generator_UserColumnName="PrTotalSales" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_AdItemID" msprop:Generator_ColumnVarNameInTable="columnFk_AdItemID" msprop:Generator_ColumnPropNameInRow="Fk_AdItemID" msprop:Generator_ColumnPropNameInTable="Fk_AdItemIDColumn" msprop:Generator_UserColumnName="Fk_AdItemID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="PrCost" msdata:Caption="Cost" msprop:Generator_ColumnVarNameInTable="columnPrCost" msprop:Generator_ColumnPropNameInRow="PrCost" msprop:Generator_ColumnPropNameInTable="PrCostColumn" msprop:Generator_UserColumnName="PrCost" type="xs:decimal" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Supplier" msprop:Generator_TableClassName="SupplierDataTable" msprop:Generator_TableVarName="tableSupplier" msprop:Generator_TablePropName="Supplier" msprop:Generator_RowDeletingName="SupplierRowDeleting" msprop:Generator_RowChangingName="SupplierRowChanging" msprop:Generator_RowEvHandlerName="SupplierRowChangeEventHandler" msprop:Generator_RowDeletedName="SupplierRowDeleted" msprop:Generator_UserTableName="Supplier" msprop:Generator_RowChangedName="SupplierRowChanged" msprop:Generator_RowEvArgName="SupplierRowChangeEvent" msprop:Generator_RowClassName="SupplierRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="SupplierID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSupplierID" msprop:Generator_ColumnPropNameInRow="SupplierID" msprop:Generator_ColumnPropNameInTable="SupplierIDColumn" msprop:Generator_UserColumnName="SupplierID" type="xs:int" />
|
|
<xs:element name="SupplierName" msprop:Generator_ColumnVarNameInTable="columnSupplierName" msprop:Generator_ColumnPropNameInRow="SupplierName" msprop:Generator_ColumnPropNameInTable="SupplierNameColumn" msprop:Generator_UserColumnName="SupplierName" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="WeekEndingDate" msprop:Generator_TableClassName="WeekEndingDateDataTable" msprop:Generator_TableVarName="tableWeekEndingDate" msprop:Generator_TablePropName="WeekEndingDate" msprop:Generator_RowDeletingName="WeekEndingDateRowDeleting" msprop:Generator_RowChangingName="WeekEndingDateRowChanging" msprop:Generator_RowEvHandlerName="WeekEndingDateRowChangeEventHandler" msprop:Generator_RowDeletedName="WeekEndingDateRowDeleted" msprop:Generator_UserTableName="WeekEndingDate" msprop:Generator_RowChangedName="WeekEndingDateRowChanged" msprop:Generator_RowEvArgName="WeekEndingDateRowChangeEvent" msprop:Generator_RowClassName="WeekEndingDateRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DateID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDateID" msprop:Generator_ColumnPropNameInRow="DateID" msprop:Generator_ColumnPropNameInTable="DateIDColumn" msprop:Generator_UserColumnName="DateID" type="xs:int" />
|
|
<xs:element name="EndOfWeekDate" msprop:Generator_ColumnVarNameInTable="columnEndOfWeekDate" msprop:Generator_ColumnPropNameInRow="EndOfWeekDate" msprop:Generator_ColumnPropNameInTable="EndOfWeekDateColumn" msprop:Generator_UserColumnName="EndOfWeekDate" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="WeeklySales" msprop:Generator_TableClassName="WeeklySalesDataTable" msprop:Generator_TableVarName="tableWeeklySales" msprop:Generator_TablePropName="WeeklySales" msprop:Generator_RowDeletingName="WeeklySalesRowDeleting" msprop:Generator_RowChangingName="WeeklySalesRowChanging" msprop:Generator_RowEvHandlerName="WeeklySalesRowChangeEventHandler" msprop:Generator_RowDeletedName="WeeklySalesRowDeleted" msprop:Generator_UserTableName="WeeklySales" msprop:Generator_RowChangedName="WeeklySalesRowChanged" msprop:Generator_RowEvArgName="WeeklySalesRowChangeEvent" msprop:Generator_RowClassName="WeeklySalesRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="WeeklyID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWeeklyID" msprop:Generator_ColumnPropNameInRow="WeeklyID" msprop:Generator_ColumnPropNameInTable="WeeklyIDColumn" msprop:Generator_UserColumnName="WeeklyID" type="xs:int" />
|
|
<xs:element name="Sunday" msprop:Generator_ColumnVarNameInTable="columnSunday" msprop:Generator_ColumnPropNameInRow="Sunday" msprop:Generator_ColumnPropNameInTable="SundayColumn" msprop:Generator_UserColumnName="Sunday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Monday" msprop:Generator_ColumnVarNameInTable="columnMonday" msprop:Generator_ColumnPropNameInRow="Monday" msprop:Generator_ColumnPropNameInTable="MondayColumn" msprop:Generator_UserColumnName="Monday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Tuesday" msprop:Generator_ColumnVarNameInTable="columnTuesday" msprop:Generator_ColumnPropNameInRow="Tuesday" msprop:Generator_ColumnPropNameInTable="TuesdayColumn" msprop:Generator_UserColumnName="Tuesday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Wednesday" msprop:Generator_ColumnVarNameInTable="columnWednesday" msprop:Generator_ColumnPropNameInRow="Wednesday" msprop:Generator_ColumnPropNameInTable="WednesdayColumn" msprop:Generator_UserColumnName="Wednesday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Thursday" msprop:Generator_ColumnVarNameInTable="columnThursday" msprop:Generator_ColumnPropNameInRow="Thursday" msprop:Generator_ColumnPropNameInTable="ThursdayColumn" msprop:Generator_UserColumnName="Thursday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Friday" msprop:Generator_ColumnVarNameInTable="columnFriday" msprop:Generator_ColumnPropNameInRow="Friday" msprop:Generator_ColumnPropNameInTable="FridayColumn" msprop:Generator_UserColumnName="Friday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Saturday" msprop:Generator_ColumnVarNameInTable="columnSaturday" msprop:Generator_ColumnPropNameInRow="Saturday" msprop:Generator_ColumnPropNameInTable="SaturdayColumn" msprop:Generator_UserColumnName="Saturday" type="xs:int" minOccurs="0" />
|
|
<xs:element name="WeeklyTotalSales" msprop:Generator_ColumnVarNameInTable="columnWeeklyTotalSales" msprop:Generator_ColumnPropNameInRow="WeeklyTotalSales" msprop:Generator_ColumnPropNameInTable="WeeklyTotalSalesColumn" msprop:Generator_UserColumnName="WeeklyTotalSales" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Fk_DateID" msprop:Generator_ColumnVarNameInTable="columnFk_DateID" msprop:Generator_ColumnPropNameInRow="Fk_DateID" msprop:Generator_ColumnPropNameInTable="Fk_DateIDColumn" msprop:Generator_UserColumnName="Fk_DateID" type="xs:int" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ActualSales" />
|
|
<xs:field xpath="mstns:AcID" />
|
|
</xs:unique>
|
|
<xs:unique name="AdItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:AdItem" />
|
|
<xs:field xpath="mstns:AdItemID" />
|
|
</xs:unique>
|
|
<xs:unique name="Comment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Comment" />
|
|
<xs:field xpath="mstns:CommnetID" />
|
|
</xs:unique>
|
|
<xs:unique name="Inventory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Inventory" />
|
|
<xs:field xpath="mstns:InvID" />
|
|
</xs:unique>
|
|
<xs:unique name="Invoice_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Invoice" />
|
|
<xs:field xpath="mstns:InvoiceID" />
|
|
</xs:unique>
|
|
<xs:unique name="ProjectedSales_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:ProjectedSales" />
|
|
<xs:field xpath="mstns:PrSalesID" />
|
|
</xs:unique>
|
|
<xs:unique name="Supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Supplier" />
|
|
<xs:field xpath="mstns:SupplierID" />
|
|
</xs:unique>
|
|
<xs:unique name="WeekEndingDate_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:WeekEndingDate" />
|
|
<xs:field xpath="mstns:DateID" />
|
|
</xs:unique>
|
|
<xs:unique name="WeeklySales_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:WeeklySales" />
|
|
<xs:field xpath="mstns:WeeklyID" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="AdItemActualSales" msdata:parent="AdItem" msdata:child="ActualSales" msdata:parentkey="AdItemID" msdata:childkey="Fk_DateID" msprop:Generator_UserChildTable="ActualSales" msprop:Generator_ChildPropName="GetActualSalesRows" msprop:Generator_UserRelationName="AdItemActualSales" msprop:Generator_RelationVarName="relationAdItemActualSales" msprop:Generator_UserParentTable="AdItem" msprop:Generator_ParentPropName="AdItemRow" />
|
|
<msdata:Relationship name="WeekEndingDateActualSales" msdata:parent="WeekEndingDate" msdata:child="ActualSales" msdata:parentkey="DateID" msdata:childkey="Fk_DateID" msprop:Generator_UserChildTable="ActualSales" msprop:Generator_ChildPropName="GetActualSalesRows" msprop:Generator_UserRelationName="WeekEndingDateActualSales" msprop:Generator_RelationVarName="relationWeekEndingDateActualSales" msprop:Generator_UserParentTable="WeekEndingDate" msprop:Generator_ParentPropName="WeekEndingDateRow" />
|
|
<msdata:Relationship name="WeekEndingDateComment" msdata:parent="WeekEndingDate" msdata:child="Comment" msdata:parentkey="DateID" msdata:childkey="Fk_DateID" msprop:Generator_UserChildTable="Comment" msprop:Generator_ChildPropName="GetCommentRows" msprop:Generator_UserRelationName="WeekEndingDateComment" msprop:Generator_RelationVarName="relationWeekEndingDateComment" msprop:Generator_UserParentTable="WeekEndingDate" msprop:Generator_ParentPropName="WeekEndingDateRow" />
|
|
<msdata:Relationship name="SupplierInvoice" msdata:parent="Supplier" msdata:child="Invoice" msdata:parentkey="SupplierID" msdata:childkey="Fk_SupplierID" msprop:Generator_UserChildTable="Invoice" msprop:Generator_ChildPropName="GetInvoiceRows" msprop:Generator_UserRelationName="SupplierInvoice" msprop:Generator_RelationVarName="relationSupplierInvoice" msprop:Generator_UserParentTable="Supplier" msprop:Generator_ParentPropName="SupplierRow" />
|
|
<msdata:Relationship name="WeekEndingDateInvoice" msdata:parent="WeekEndingDate" msdata:child="Invoice" msdata:parentkey="DateID" msdata:childkey="Fk_DateID" msprop:Generator_UserChildTable="Invoice" msprop:Generator_ChildPropName="GetInvoiceRows" msprop:Generator_UserRelationName="WeekEndingDateInvoice" msprop:Generator_RelationVarName="relationWeekEndingDateInvoice" msprop:Generator_UserParentTable="WeekEndingDate" msprop:Generator_ParentPropName="WeekEndingDateRow" />
|
|
<msdata:Relationship name="WeekEndingDateWeeklySales" msdata:parent="WeekEndingDate" msdata:child="WeeklySales" msdata:parentkey="DateID" msdata:childkey="Fk_DateID" msprop:Generator_UserChildTable="WeeklySales" msprop:Generator_ChildPropName="GetWeeklySalesRows" msprop:Generator_UserRelationName="WeekEndingDateWeeklySales" msprop:Generator_ParentPropName="WeekEndingDateRow" msprop:Generator_RelationVarName="relationWeekEndingDateWeeklySales" msprop:Generator_UserParentTable="WeekEndingDate" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |