private void ShowYearlyReport(string dateFrom, string dateTo, int propertyId) { if (string.IsNullOrEmpty(dateFrom) || string.IsNullOrEmpty(dateTo) || propertyId <= 0) { lbCompany.Visible = true; lbDateFrom.Visible = true; lbDateTo.Visible = true; lbError.Visible = true; } else { lbCompany.Visible = false; lbDateFrom.Visible = false; lbDateTo.Visible = false; lbError.Visible = false; divJqGridYearlyReport.Attributes["style"] = "display:"; divExportData.Attributes["style"] = "display:"; var sesseionDateFrom = dateFrom; var strFrom = sesseionDateFrom.Split('/'); var fromDate = Convert.ToInt32(strFrom[0]); var fromMonth = Convert.ToInt32(strFrom[1]); var fromYear = Convert.ToInt32(strFrom[2]); var sesseionDateTo = dateTo; var strTo = sesseionDateTo.Split('/'); var toDate = Convert.ToInt32(strTo[0]); var toMonth = Convert.ToInt32(strTo[1]); var toYear = Convert.ToInt32(strTo[2]); var dateTimeFrom = new DateTime(fromYear, fromMonth, fromDate); var dateTimeTo = new DateTime(toYear, toMonth, toDate); var dateTimeFromLastYear = dateTimeFrom.AddYears(-1); var dateTimeToLastYear = dateTimeTo.AddYears(-1); var listBudgetTY = ReportHelper.CalculateYearlyReport(dateTimeFrom, dateTimeTo, propertyId); var listBudgetLY = ReportHelper.CalculateYearlyReport(dateTimeFromLastYear, dateTimeToLastYear, propertyId); var budgetLY = listBudgetLY as List <HotelDataEntryLib.Helper.Report> ?? listBudgetLY.ToList(); if (listBudgetLY != null && budgetLY.Count() != 0) { var listRow = (from t in listBudgetTY from l in budgetLY where t.Type == l.Type && t.SubType == l.SubType select new HotelDataEntryLib.Helper.Report() { Type = t.Type, SubType = t.SubType, BudgetTY = t.BudgetTY, BudgetLY = l.BudgetTY }).ToList(); BindRowToDataTableYearlyReport(listRow); } else { var listRow = (from t in listBudgetTY select new HotelDataEntryLib.Helper.Report() { Type = t.Type, SubType = t.SubType, BudgetTY = t.BudgetTY, BudgetLY = 0.00 }).ToList(); BindRowToDataTableYearlyReport(listRow); } } }