public JsonResult GetcontrolSheetData(string sId, string selectDate) { ReportModel repModel = new ReportModel(); ArrayList AllReportList = new ArrayList(); int storeId = 1; DateTime date = DateTime.Now; if (!ValidationUtility.IsNull(sId)) { storeId = ValidationUtility.ToInteger(sId); } if (!ValidationUtility.IsNull(selectDate)) { date = ValidationUtility.ToDate(selectDate); } Dictionary<int, string> connectionString = (Dictionary<int, string>)Session["ConnectionString"]; string storeNameConnectionString = ""; if (connectionString.ContainsKey(storeId)) { storeNameConnectionString = connectionString[storeId]; } AllReportList.Add(repModel.GetCashControlData(date, storeNameConnectionString)); AllReportList.Add(repModel.GetSalesItemizationData(date, storeNameConnectionString)); AllReportList.Add(repModel.GetBreadControlData(date, storeNameConnectionString)); AllReportList.Add(repModel.GetUnitsItemizationData(date, storeNameConnectionString)); AllReportList.Add(repModel.GetLaborData(date, storeNameConnectionString)); AllReportList.Add(WeekInformation(date)); AllReportList.Add(repModel.GetTotalSubwaySale(date, storeNameConnectionString)); AllReportList.Add(repModel.GetTotalUnitSale(date, storeNameConnectionString)); AllReportList.Add(repModel.GetTotalDrinkSale(date, storeNameConnectionString)); return Json(AllReportList, JsonRequestBehavior.AllowGet); }