public override int FindSalesOrderID(Guid?rowguid)
{
using (var adapter = SalesQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
{
return((int)adapter.SP_FindSalesOrderID(rowguid));
}
}
public override decimal GetTotal(int?branchID, DateTime?date1, DateTime?date2)
{
using (var adapter = SalesQueriesAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
{
return((decimal)adapter.SP_T_SalesOrderHeader_GetTotal(branchID, date1, date2));
}
}
public override int AddOrEditSalesOrder(int salesOrderID, int branchID, DateTime orderDate, string overheadNumber, int customerID, decimal subTotal, decimal taxAmt, decimal freight, decimal totalDue, string currencyCode, int currencyRateID, int paymentMethodID, int revisionNumber, string comment, int status, int modifiedUserID, DateTime modifiedDate, int approverUserID, Guid rowguid, int action, bool isOnline, byte[] b)
{
var connectionString = (isOnline ? ConfigurationManagerEx.ConnectionString : ConfigurationManagerEx.OfflineConnectionString);
var commandTimeout = (isOnline ? ConfigurationManagerEx.CommandTimeout : ConfigurationManagerEx.OfflineCommandTimeout);
using (var adapter = SalesQueriesAdapter.CreateInstance(connectionString, commandTimeout))
{
return((int)adapter.SP_AddOrEditSalesOrder(salesOrderID, branchID, orderDate, overheadNumber, customerID, subTotal, taxAmt, freight, totalDue, currencyCode, currencyRateID, paymentMethodID, revisionNumber, comment, status, modifiedUserID, modifiedDate, approverUserID, rowguid, action, b.GetXmlData()));
}
}
public override bool IsValidOrderDate(int tableID, int orderID, int branchID, DateTime date, bool isOnline)
{
var connectionString = (isOnline ? ConfigurationManagerEx.ConnectionString : ConfigurationManagerEx.OfflineConnectionString);
var commandTimeout = (isOnline ? ConfigurationManagerEx.CommandTimeout : ConfigurationManagerEx.OfflineCommandTimeout);
using (var adapter = SalesQueriesAdapter.CreateInstance(connectionString, commandTimeout))
{
return((bool)adapter.SP_IsValidOrderDate(tableID, orderID, branchID, date));
}
}