public ArrayList GetBreadControlData(DateTime dateTime, string connetionStringName) { ArrayList list = new ArrayList(); StoreRemoteDataBaseUitility db = new StoreRemoteDataBaseUitility(connetionStringName); // This procedure set 7 day data DateTime weekStartDate = ValidationUtility.GetActualWeekStartDate(dateTime); DateTime weekEndDate = weekStartDate.AddDays(6); // This procedure is use for get BreadControl data SqlParameter[] breadControlSqlParams = new SqlParameter[] { new SqlParameter("@WeekEndingDate",weekEndDate ),}; DataTable breadControlDataTable = db.ExecuteSPDataTable("Central.ControlSheetReport_BreadControl_SelectStoredProcedure", breadControlSqlParams); DataTable newBreadControlDataTable = new DataTable(); newBreadControlDataTable = db.GenerateTransposedTable(breadControlDataTable); for (int i = 0; i < newBreadControlDataTable.Rows.Count; i++) { string businessDate = newBreadControlDataTable.Rows[i]["BusinessDate"].ToString(); double day1 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(0).Date.ToString()].ToString()); double day2 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(1).Date.ToString()].ToString()); double day3 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(2).Date.ToString()].ToString()); double day4 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(3).Date.ToString()].ToString()); double day5 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(4).Date.ToString()].ToString()); double day6 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(5).Date.ToString()].ToString()); double day7 = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekStartDate.AddDays(6).Date.ToString()].ToString()); double weekTotal = ValidationUtility.ToDouble(newBreadControlDataTable.Rows[i][weekEndDate.AddYears(1).Date.ToString()].ToString()); SalesItemizationReportDTO salesItemizationReportDTO = new SalesItemizationReportDTO { ProductCategoryDescription = businessDate, Day1 = day1, Day2 = day2, Day3 = day3, Day4 = day4, Day5 = day5, Day6 = day6, Day7 = day7, WeekTotal = weekTotal }; list.Add(salesItemizationReportDTO); } return list; }