public void SendWeeklyReport() { var dtOneMonthBack = DateTime.Now; int year = dtOneMonthBack.Year; int month = dtOneMonthBack.Month; string firstWeekStart = dtOneMonthBack.ToString("MM") + "/01/" + DateTime.Now.Year.ToString(); string firstWeekEnd = dtOneMonthBack.ToString("MM") + "/07/" + DateTime.Now.Year.ToString(); string secondWeekStart = dtOneMonthBack.ToString("MM") + "/08/" + DateTime.Now.Year.ToString(); string secondWeekEnd = dtOneMonthBack.ToString("MM") + "/14/" + DateTime.Now.Year.ToString(); string thirdWeekStart = dtOneMonthBack.ToString("MM") + "/15/" + DateTime.Now.Year.ToString(); string thirdWeekEnd = dtOneMonthBack.ToString("MM") + "/21/" + DateTime.Now.Year.ToString(); string fourthWeekStart = dtOneMonthBack.ToString("MM") + "/22/" + DateTime.Now.Year.ToString(); DateTime lastDate = new DateTime(year, month, DateTime.DaysInMonth(year, month)); string fourthWeekEnd = lastDate.ToString("MM/dd/yyyy"); //string firstWeekStart = dtOneMonthBack.ToString("MM/dd/yyyy"); //string firstWeekEnd = dtOneMonthBack.AddDays(7).ToString("MM/dd/yyyy"); //string secondWeekStart = dtOneMonthBack.AddDays(8).ToString("MM/dd/yyyy"); //string secondWeekEnd = dtOneMonthBack.AddDays(14).ToString("MM/dd/yyyy"); //string thirdWeekStart = dtOneMonthBack.AddDays(15).ToString("MM/dd/yyyy"); //string thirdWeekEnd = dtOneMonthBack.AddDays(21).ToString("MM/dd/yyyy"); //string fourthWeekStart = dtOneMonthBack.AddDays(22).ToString("MM/dd/yyyy"); ////DateTime lastDate = new DateTime(year, month, //// DateTime.DaysInMonth(year, month)); //string fourthWeekEnd = DateTime.Now.ToString("MM/dd/yyyy"); List <GrossWrittenPremiumReportModels> ListGrossWrittenPremiumReport = new List <GrossWrittenPremiumReportModels>(); ListGrossWrittenPremiumReportModels _ListGrossWrittenPremiumReport = new ListGrossWrittenPremiumReportModels(); _ListGrossWrittenPremiumReport.ListGrossWrittenPremiumReportdata = new List <GrossWrittenPremiumReportModels>(); try { ListGrossWrittenPremiumReport = getGWPData(firstWeekStart, firstWeekEnd); Debug.WriteLine("**************hdfhd***************"); Debug.WriteLine(ListGrossWrittenPremiumReport.Count()); Debug.WriteLine("**************hdfhd***************"); var report2 = getGWPData(secondWeekStart, secondWeekEnd); var report3 = getGWPData(thirdWeekStart, thirdWeekEnd); var report4 = getGWPData(fourthWeekStart, fourthWeekEnd); var report5 = getGWPData(firstWeekStart, fourthWeekEnd); List <BranchModel> branches = InsuranceContext.Query("select * from Branch").Select(x => new BranchModel { Id = x.Id, BranchName = x.BranchName }).ToList(); List <WeeklyGWPModel> weeklyGWPModels = new List <WeeklyGWPModel>(); branches.ForEach(x => { WeeklyGWPModel model = new WeeklyGWPModel(); if (x.BranchName == "Online") { var count = ListGrossWrittenPremiumReport.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total = ListGrossWrittenPremiumReport.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count2 = report2.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total2 = report2.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count3 = report3.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total3 = report3.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count4 = report4.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total4 = report4.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count5 = report5.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total5 = report5.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); model.BranchName = x.BranchName; model.FirstWeekCount = count; model.FirstWeekValue = total; model.SecondWeekCount = count2; model.SecondWeekValue = total2; model.ThirdWeekCount = count3; model.ThirdWeekValue = total3; model.FourWeekCount = count4; model.FourWeekValue = total4; model.TotalMonthCount = count5; model.TotalMonthValue = total5; weeklyGWPModels.Add(model); } else { var count = ListGrossWrittenPremiumReport.FindAll(p => p.BranchName == x.BranchName).Count(); var total = ListGrossWrittenPremiumReport.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count2 = report2.FindAll(p => p.BranchName == x.BranchName).Count(); var total2 = report2.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count3 = report3.FindAll(p => p.BranchName == x.BranchName).Count(); var total3 = report3.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count4 = report4.FindAll(p => p.BranchName == x.BranchName).Count(); var total4 = report4.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count5 = report5.FindAll(p => p.BranchName == x.BranchName).Count(); var total5 = report5.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); model.BranchName = x.BranchName; model.FirstWeekCount = count; model.FirstWeekValue = total; model.SecondWeekCount = count2; model.SecondWeekValue = total2; model.ThirdWeekCount = count3; model.ThirdWeekValue = total3; model.FourWeekCount = count4; model.FourWeekValue = total4; model.TotalMonthCount = count5; model.TotalMonthValue = total5; weeklyGWPModels.Add(model); } }); GenerateExcel2(weeklyGWPModels); } catch (Exception ex) { Debug.WriteLine(ex); } }
public void SendWeeklyReport() { Library.WriteErrorLog("Start Summary GWP Report"); var dtOneMonthBack = DateTime.Now; int year = dtOneMonthBack.Year; int month = dtOneMonthBack.Month; string firstWeekStart = dtOneMonthBack.ToString("MM") + "/01/" + DateTime.Now.Year.ToString(); string firstWeekEnd = dtOneMonthBack.ToString("MM") + "/07/" + DateTime.Now.Year.ToString(); string secondWeekStart = dtOneMonthBack.ToString("MM") + "/08/" + DateTime.Now.Year.ToString(); string secondWeekEnd = dtOneMonthBack.ToString("MM") + "/14/" + DateTime.Now.Year.ToString(); string thirdWeekStart = dtOneMonthBack.ToString("MM") + "/15/" + DateTime.Now.Year.ToString(); string thirdWeekEnd = dtOneMonthBack.ToString("MM") + "/21/" + DateTime.Now.Year.ToString(); string fourthWeekStart = dtOneMonthBack.ToString("MM") + "/22/" + DateTime.Now.Year.ToString(); DateTime lastDate = new DateTime(year, month, DateTime.DaysInMonth(year, month)); string fourthWeekEnd = lastDate.ToString("MM/dd/yyyy"); //string firstWeekStart = dtOneMonthBack.ToString("MM/dd/yyyy"); //string firstWeekEnd = dtOneMonthBack.AddDays(7).ToString("MM/dd/yyyy"); //string secondWeekStart = dtOneMonthBack.AddDays(8).ToString("MM/dd/yyyy"); //string secondWeekEnd = dtOneMonthBack.AddDays(14).ToString("MM/dd/yyyy"); //string thirdWeekStart = dtOneMonthBack.AddDays(15).ToString("MM/dd/yyyy"); //string thirdWeekEnd = dtOneMonthBack.AddDays(21).ToString("MM/dd/yyyy"); //string fourthWeekStart = dtOneMonthBack.AddDays(22).ToString("MM/dd/yyyy"); ////DateTime lastDate = new DateTime(year, month, //// DateTime.DaysInMonth(year, month)); //string fourthWeekEnd = DateTime.Now.ToString("MM/dd/yyyy"); List <GrossWrittenPremiumReportModels> ListGrossWrittenPremiumReport = new List <GrossWrittenPremiumReportModels>(); ListGrossWrittenPremiumReportModels _ListGrossWrittenPremiumReport = new ListGrossWrittenPremiumReportModels(); _ListGrossWrittenPremiumReport.ListGrossWrittenPremiumReportdata = new List <GrossWrittenPremiumReportModels>(); try { ListGrossWrittenPremiumReport = getGWPData(firstWeekStart, firstWeekEnd); Library.WriteErrorLog("Summary GWP count: " + ListGrossWrittenPremiumReport.Count()); var report2 = getGWPData(secondWeekStart, secondWeekEnd); Library.WriteErrorLog("Summary GWP count: " + report2.Count()); var report3 = getGWPData(thirdWeekStart, thirdWeekEnd); Library.WriteErrorLog("Summary GWP count: " + report3.Count()); var report4 = getGWPData(fourthWeekStart, fourthWeekEnd); Library.WriteErrorLog("Summary GWP count: " + report4.Count()); var report5 = getGWPData(firstWeekStart, fourthWeekEnd); Library.WriteErrorLog("Summary GWP count: " + report5.Count()); DataTable dt = GetAllBranch(); List <BranchModel> branches = ConvertDataTable <BranchModel>(dt); List <WeeklyGWPModel> weeklyGWPModels = new List <WeeklyGWPModel>(); branches.ForEach(x => { WeeklyGWPModel model = new WeeklyGWPModel(); if (x.BranchName == "Online") { var count = ListGrossWrittenPremiumReport.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total = ListGrossWrittenPremiumReport.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count2 = report2.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total2 = report2.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count3 = report3.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total3 = report3.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count4 = report4.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total4 = report4.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); var count5 = report5.FindAll(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Count(); var total5 = report5.Where(p => p.BranchName == x.BranchName || p.BranchName == "" || p.BranchName == null).Sum(item => item.Premium_due); model.BranchName = x.BranchName; model.FirstWeekCount = count; model.FirstWeekValue = total; model.SecondWeekCount = count2; model.SecondWeekValue = total2; model.ThirdWeekCount = count3; model.ThirdWeekValue = total3; model.FourWeekCount = count4; model.FourWeekValue = total4; model.TotalMonthCount = count5; model.TotalMonthValue = total5; weeklyGWPModels.Add(model); } else { var count = ListGrossWrittenPremiumReport.FindAll(p => p.BranchName == x.BranchName).Count(); var total = ListGrossWrittenPremiumReport.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count2 = report2.FindAll(p => p.BranchName == x.BranchName).Count(); var total2 = report2.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count3 = report3.FindAll(p => p.BranchName == x.BranchName).Count(); var total3 = report3.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count4 = report4.FindAll(p => p.BranchName == x.BranchName).Count(); var total4 = report4.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); var count5 = report5.FindAll(p => p.BranchName == x.BranchName).Count(); var total5 = report5.Where(p => p.BranchName == x.BranchName).Sum(item => item.Premium_due); model.BranchName = x.BranchName; model.FirstWeekCount = count; model.FirstWeekValue = total; model.SecondWeekCount = count2; model.SecondWeekValue = total2; model.ThirdWeekCount = count3; model.ThirdWeekValue = total3; model.FourWeekCount = count4; model.FourWeekValue = total4; model.TotalMonthCount = count5; model.TotalMonthValue = total5; weeklyGWPModels.Add(model); } }); GenerateExcel2(weeklyGWPModels); } catch (Exception ex) { Library.WriteErrorLog("Summary GWP Report Count - " + ex.Message); } }