public void SaveReconciliation(StoreReconciliation storeReconciliation /*, IEnumerable<Expense> expenses*/)
{
using (IDAL dal = this.DAL)
{
StoreOperations storeOperations = new StoreOperations(dal);
Store store = storeOperations.getStore(OTApplication.Context.Branch.Id);
dal.BeginTransaction();
try
{
storeReconciliation.Event = 1;
storeReconciliation.Organization = OTApplication.Context.Organization.Id;
storeReconciliation.StoreID = store.StoreId;
if (storeReconciliation.StoreReconciliationId == 0)
{
dal.Create(storeReconciliation);
}
else
{
dal.Update(storeReconciliation);
}
dal.CommitTransaction();
}
catch
{
dal.RollbackTransaction();
throw;
}
}
}
public IEnumerable <int> ListPriceLabelChecked(string pS)
{
using (IDAL dal = this.DAL)
{
StoreOperations storeOperations = new StoreOperations(dal);
Store store = storeOperations.getStore(OTApplication.Context.Branch.Id);
IUniParameter prmStore = dal.CreateParameter("StoreID", store.StoreId);
IUniParameter prmSize = dal.CreateParameter("PSIZE", pS);
return(dal.RetrieveAll <int>("PRC_LST_PRICECHECKEDLABEL_SP", prmStore, prmSize).ToList());
}
}
/*Section="CustomCodeRegion"*/
#region Customized
//public IEnumerable<PriceVersion> ListPriceVersions()
//{
// using (IDAL dal = this.DAL)
// {
// StoreOperations storeOperations = new StoreOperations(dal);
// Store store = storeOperations.getBranch(OTApplication.Context.Branch.Id);
// IUniParameter prmStore = dal.CreateParameter("StoreID", store.StoreId);
// var result = dal.List<PriceVersion>("PRC_LST_PRICEVERSIONS_SP", prmStore).ToList();
// return result;
// }
//}
public IEnumerable <LabelPrice> ListPriceLabel()
{
using (IDAL dal = this.DAL)
{
StoreOperations storeOperations = new StoreOperations(dal);
Store store = storeOperations.getStore(OTApplication.Context.Branch.Id);
IUniParameter prmStore = dal.CreateParameter("StoreID", store.StoreId);
var result = dal.List <LabelPrice>("PRC_LST_PRICELABEL_SP", prmStore /*, prmPackageVersionID*/).ToList();
return(result);
}
}
public StoreReconciliation GetReconciliation(DateTime transactionDate)
{
using (IDAL dal = this.DAL)
{
StoreOperations storeOperations = new StoreOperations(dal);
Store store = storeOperations.getStore(OTApplication.Context.Branch.Id);
IUniParameter prmBranch = dal.CreateParameter("StoreID", store.StoreId);
IUniParameter prmTransactionDate = dal.CreateParameter("TransactionDate", transactionDate);
var reconInfo = dal.Read <StoreReconciliation>("RCL_SEL_RECONCILIATIONINFO_SP", prmBranch, prmTransactionDate);
return(reconInfo);
}
}
public IEnumerable <StoreReconciliationIncome> ListReconciliationIncome(DateTime transactionDate)
{
using (IDAL dal = this.DAL)
{
StoreOperations storeOperations = new StoreOperations(dal);
Store store = storeOperations.getStore(OTApplication.Context.Branch.Id);
IUniParameter prmBranch = dal.CreateParameter("StoreID", store.StoreId);
IUniParameter prmTransactionDate = dal.CreateParameter("TransactionDate", transactionDate);
IUniParameter prmSaleTotal = dal.CreateParameter("SaleTotal", 0);
var result = dal.List <StoreReconciliationIncome>("RCL_LST_RECONCILIATIONINCOME_SP", prmBranch, prmTransactionDate, prmSaleTotal).ToList();
return(result);
}
}
