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);
}
}
