public ArrayList GetPerDayRecordSale(DateTime businessDate) { RecordSaleModel rsm = new RecordSaleModel(); ArrayList list = null; UserContext cont = (UserContext)Session["UserContext"]; if (!ValidationUtility.IsNull(cont)) { // DateTime BusinessDate = DateTime.Now; // int storeId = rsm.GetManagetAssignStoredId(cont.Id); int storeId = ValidationUtility.GetActiveStoredId(cont.Id); Dictionary<int, string> connectionString = (Dictionary<int, string>)Session["ConnectionString"]; string storeNameConnectionString = ""; if (connectionString.ContainsKey(storeId)) { storeNameConnectionString = connectionString[storeId]; double perDaySalesAmount = rsm.GetPerDaySalesAmount(storeNameConnectionString, businessDate); int opId = rsm.GetCurrentDateOpeningInfoId(businessDate, storeNameConnectionString); rsm.UpdatePerdaySales(perDaySalesAmount, storeId, businessDate, opId); list = rsm.GetPerdaySales(cont.Id, storeNameConnectionString, businessDate); } } return list; }
public void UpdateRecordSale() { try { log.Info(" UpdateRecordSale Start Time is " + DateTime.Now); ArrayList weekDayList = new ArrayList(); string weekOfDay = DateTime.Now.AddDays(-1).DayOfWeek.ToString(); weekDayList.Add(weekOfDay); log.Info(" Day Of week " + DateTime.Now.AddDays(-1).DayOfWeek.ToString()); //weekDayList.Add("Thursday"); //weekDayList.Add("Friday"); //weekDayList.Add("Saturday"); //weekDayList.Add("Sunday"); //weekDayList.Add("Monday"); //weekDayList.Add("Tuesday"); StoreModel sm = new StoreModel(); // Get All Store List from local database // ArrayList list = sm.GetStoreList(); ArrayList list = ValidationUtility.GetActiveStoreList(true); foreach (StoreDTO dto in list) { ArrayList recordSale = new ArrayList(); foreach (string s in weekDayList) { //Get Business day record (which is high in year) DataTable dt = GetWeekDayRecord(dto.ConnectionString, s); RecordSalesDTO recordSaleDto = new RecordSalesDTO(); for (int i = 0; i < dt.Rows.Count; i++) { recordSaleDto.BusinessDate = (DateTime)dt.Rows[i]["BusinessDate"]; recordSaleDto.DayOfWeek = dt.Rows[i]["WeekOfDay"].ToString(); recordSaleDto.SalesAmount = ValidationUtility.ToDouble(dt.Rows[i]["PerDaySale"].ToString()); recordSaleDto.StoreId = dto.Id; } recordSale.Add(recordSaleDto); } // Now Update Records foreach (RecordSalesDTO rsDto in recordSale) { UpdateStore(rsDto, dto.ConnectionString); } } // UpdateLast sale foreach (StoreDTO dto in list) { RecordSaleModel rsm = new RecordSaleModel(); log.Info("Record update for StorId " + dto.Id); log.Info("Last Perday sale date " + DateTime.Now.AddDays(-1)); double perDaySalesAmount = GetPerDayUpdatedSalesAmount(dto.ConnectionString, DateTime.Now.AddDays(-1)); log.Info("Last date perday sales amount " + perDaySalesAmount); int opId = rsm.GetCurrentDateOpeningInfoId(DateTime.Now.AddDays(-1), dto.ConnectionString); log.Info("Opening Information Id of last per day sales " + opId); rsm.UpdatePerdaySales(perDaySalesAmount, dto.Id, DateTime.Now.AddDays(-1), opId); //ArrayList lastPerDaySales = GetLastDaySalesData(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1).DayOfWeek.ToString(), dto.Id); //foreach (PerdaySalesDTO perdaySalesDTO in lastPerDaySales) //{ // double perDaySalesAmount = GetPerDayUpdatedSalesAmount(dto.ConnectionString, perdaySalesDTO.BusinessDate); // int opId = rsm.GetCurrentDateOpeningInfoId(perdaySalesDTO.BusinessDate, dto.ConnectionString); // rsm.UpdatePerdaySales(perDaySalesAmount, perdaySalesDTO.StoreId, perdaySalesDTO.BusinessDate, opId); //} } log.Info(" End Time " + DateTime.Now); } catch (Exception ex) { log.Error("Exception in UpdateRecordSale ", ex); } }