//This method is use for update depoisit amount of last business date
public void UpdateDeposit()
{
log.Info(" UpdateDeposit Method is Called now for Deposit "+DateTime.Now);
DepositModel dmodel = new DepositModel();
// ArrayList storeList = dmodel.GetStoreList();
ArrayList storeList = ValidationUtility.GetActiveStoreList(true);
foreach (StoreDTO storeDTO in storeList)
{
DateTime lastDayDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day).AddDays(-1);
DepositDTO depositDTO1 = GetBankDepositListFromLocalDB(lastDayDate, storeDTO);
if (!ValidationUtility.IsNull(depositDTO1))
{
DataTable dt = GetEachStoreDepositAmount(storeDTO.ConnectionString, lastDayDate);
if (!ValidationUtility.IsNull(dt))
{
DateTime businessDate = new DateTime();
for (int i = 0; i < dt.Rows.Count; i++)
{
double depositAmount = 0;
businessDate = ValidationUtility.ToDate(dt.Rows[i]["BusinessDate"].ToString());
if (businessDate.Date.Equals(lastDayDate.Date))
{
depositAmount = ValidationUtility.ToDouble(dt.Rows[i]["DepositInBank"].ToString());
DepositAmount dammount = new DepositAmount { DepositBankAmount = depositAmount, BusinessDate = businessDate, WeekOfDay = businessDate.DayOfWeek.ToString() };
Update(dammount, storeDTO.Id);
}
}
}
}
// Add Week deposit ammount
else
{
DataTable dt = GetEachStoreDepositAmount(storeDTO.ConnectionString, lastDayDate);
ArrayList ammountList = new ArrayList();
if (!ValidationUtility.IsNull(dt))
{
List<DepositAmount> depositAmmountList = new List<DepositAmount>();
DateTime businessDate = new DateTime();
for (int i = 0; i < dt.Rows.Count; i++)
{
double depositAmount = 0;
businessDate = ValidationUtility.ToDate(dt.Rows[i]["BusinessDate"].ToString());
if (businessDate.Date <= ValidationUtility.GetActualWeekStartDate(lastDayDate).AddDays(7).Date)
{
depositAmount = ValidationUtility.ToDouble(dt.Rows[i]["DepositInBank"].ToString());
DepositAmount dammount = new DepositAmount { DepositBankAmount = depositAmount, BusinessDate = businessDate };
depositAmmountList.Add(dammount);
}
}
DepositDTO depositDTO = new DepositDTO { StoreId = storeDTO.Id, DepositAmount = depositAmmountList };
dmodel.InsertDepositAmount(depositDTO);
}
}
}
log.Info(" UpdateDeposit Method Call is finish " + DateTime.Now);
}
