private void BindDataEntryJqgrid(HotelDataEntryLib.HotelRevenue hotelEntry) { var userPermission = Session["permission"].ToString(); var dataEntryList = RevenueHelper.ListRevenueEntryByMonthYear(hotelEntry); JqGridRevenueEntry.DataSource = dataEntryList; AppendTotal(dataEntryList); JqGridRevenueEntry.DataBind(); if (!string.IsNullOrEmpty(userPermission)) { if (Convert.ToInt32(userPermission) >= 2) { JqGridRevenueEntry.ToolBarSettings.ShowEditButton = true; } } }
protected void btnExcelAll_Click(object sender, System.Web.UI.ImageClickEventArgs e) { var hr = new HotelDataEntryLib.HotelRevenue(); if (Session["MonthYear"] == null) return; var my = Session["MonthYear"].ToString(); var month = Convert.ToInt32(my.Split('/')[0]); var year = Convert.ToInt32(my.Split('/')[1]); var revenue = HotelDataEntryLib.Page.RevenueHelper.GetAllPropertyByHotelRevenue(year, month); var attachment = "attachment; filename=All Properties" + " Revenue " + my + ".xls"; Response.ClearContent(); Response.AddHeader("content-disposition", attachment); Response.ContentType = "application/vnd.ms-excel"; for (var i = 0; i < revenue.Count; i++) { Response.Write("[" + revenue[i].CurrencyCode + "] " + revenue[i].PropertyName + " Revenue " + my); Response.Write("\r\n"); Response.Write("\r\n"); Response.Write("Date\t"); Response.Write("Occupancy(%)\t"); Response.Write("Room Revenue\t"); Response.Write("F & B Revenue\t"); Response.Write("Spa Revenue\t"); Response.Write("Others\t"); Response.Write("Total\t"); Response.Write("Budget\t"); Response.Write("\n"); hr.HotelRevenueId = revenue[i].HotelRevenueId; hr.Month = month; hr.Year = year; var listRevenue = RevenueHelper.ListRevenueEntryByMonthYear(hr); var total = CalculateTotal(listRevenue); for (var j = 0; j < listRevenue.Count; j++) { var date = DateTime.Parse(listRevenue[j].PositionDate.ToString()); Response.Write(date.ToShortDateString() + "\t"); Response.Write(listRevenue[j].OccupancyRoom.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].RoomRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].FBRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].SpaRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Others.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Total.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Budget.ToString("#,##0.00") + "\t"); Response.Write("\n"); } Response.Write("Total" + "\t"); Response.Write("-" + "\t"); Response.Write(total[0].ToString("#,##0.00") + "\t"); Response.Write(total[1].ToString("#,##0.00") + "\t"); Response.Write(total[2].ToString("#,##0.00") + "\t"); Response.Write(total[3].ToString("#,##0.00") + "\t"); Response.Write(total[4].ToString("#,##0.00") + "\t"); Response.Write(total[5].ToString("#,##0.00") + "\t"); Response.Write("\n"); Response.Write("\n"); Response.Write("\n"); } Response.Write("\n"); Response.Write("Print Date: [" + DateTime.Now + "] "); Response.Write("\r\n"); Response.End(); }
private void ShowData(int propertyId, string my) { if (string.IsNullOrEmpty(my) || propertyId <= 0 ) { lbError.Visible = true; lbCalendar.Visible = true; lbCompany.Visible = true; divReport.Attributes["style"] = "display:none"; } else { lbError.Visible = false; lbCalendar.Visible = false; lbCompany.Visible = false; divReport.Attributes["style"] = ""; divJqgrid.Attributes["style"] = ""; var username = Session["UserSession"].ToString(); var user = UserHelper.GetUser(username); if(user.PropertyId==15)//OHG ID { divExportAllData.Attributes["style"] = ""; } var str = my.Split('/'); if(!string.IsNullOrEmpty(str[0])&&!string.IsNullOrEmpty(str[1])) { Session["PropertyIdReport"] = propertyId;//for reports.aspx property Session["YearReport"] = Convert.ToInt32(str[1]);//for reports.aspx year var hotelEntry = new HotelDataEntryLib.HotelRevenue() { PropertyId = propertyId, Month = Convert.ToInt32(str[0]), Year = Convert.ToInt32(str[1]) }; if (HotelRevenueHelper.ExistMothYear(hotelEntry)) { var exsitEntry = HotelRevenueHelper.GetHotelEntry(hotelEntry); BindDataEntryJqgrid(exsitEntry); } else { var budgetEntry = new HotelBudget() { PropertyId = hotelEntry.PropertyId, Year = hotelEntry.Year }; if(!HotelBudgetHelper.ExistYear(budgetEntry)) { var newBudgetEntry = HotelBudgetHelper.AddHotelEntryListByYear(budgetEntry); BudgetHelper.AddBudgetEntryListByYear(newBudgetEntry, Session["UserSession"].ToString()); } var newEntry = HotelRevenueHelper.AddHotelEntryListByMonthYear(hotelEntry); RevenueHelper.AddRevenueEntryListByMonthYear(newEntry, Session["UserSession"].ToString()); BindDataEntryJqgrid(newEntry); } } } }
private void ShowData(int propertyId, string my) { if (string.IsNullOrEmpty(my) || propertyId <= 0) { lbError.Visible = true; lbCalendar.Visible = true; lbCompany.Visible = true; divReport.Attributes["style"] = "display:none"; } else { lbError.Visible = false; lbCalendar.Visible = false; lbCompany.Visible = false; divReport.Attributes["style"] = ""; divJqgrid.Attributes["style"] = ""; var username = Session["UserSession"].ToString(); var user = UserHelper.GetUser(username); if (user.PropertyId == 15)//OHG ID { divExportAllData.Attributes["style"] = ""; } var str = my.Split('/'); if (!string.IsNullOrEmpty(str[0]) && !string.IsNullOrEmpty(str[1])) { Session["PropertyIdReport"] = propertyId; //for reports.aspx property Session["YearReport"] = Convert.ToInt32(str[1]); //for reports.aspx year var hotelEntry = new HotelDataEntryLib.HotelRevenue() { PropertyId = propertyId, Month = Convert.ToInt32(str[0]), Year = Convert.ToInt32(str[1]) }; if (HotelRevenueHelper.ExistMothYear(hotelEntry)) { var exsitEntry = HotelRevenueHelper.GetHotelEntry(hotelEntry); BindDataEntryJqgrid(exsitEntry); } else { var budgetEntry = new HotelBudget() { PropertyId = hotelEntry.PropertyId, Year = hotelEntry.Year }; if (!HotelBudgetHelper.ExistYear(budgetEntry)) { var newBudgetEntry = HotelBudgetHelper.AddHotelEntryListByYear(budgetEntry); BudgetHelper.AddBudgetEntryListByYear(newBudgetEntry, Session["UserSession"].ToString()); } var newEntry = HotelRevenueHelper.AddHotelEntryListByMonthYear(hotelEntry); RevenueHelper.AddRevenueEntryListByMonthYear(newEntry, Session["UserSession"].ToString()); BindDataEntryJqgrid(newEntry); } } } }
protected void btnExcelAll_Click(object sender, System.Web.UI.ImageClickEventArgs e) { var hr = new HotelDataEntryLib.HotelRevenue(); if (Session["MonthYear"] == null) { return; } var my = Session["MonthYear"].ToString(); var month = Convert.ToInt32(my.Split('/')[0]); var year = Convert.ToInt32(my.Split('/')[1]); var revenue = HotelDataEntryLib.Page.RevenueHelper.GetAllPropertyByHotelRevenue(year, month); var attachment = "attachment; filename=All Properties" + " Revenue " + my + ".xls"; Response.ClearContent(); Response.AddHeader("content-disposition", attachment); Response.ContentType = "application/vnd.ms-excel"; for (var i = 0; i < revenue.Count; i++) { Response.Write("[" + revenue[i].CurrencyCode + "] " + revenue[i].PropertyName + " Revenue " + my); Response.Write("\r\n"); Response.Write("\r\n"); Response.Write("Date\t"); Response.Write("Occupancy(%)\t"); Response.Write("Room Revenue\t"); Response.Write("F & B Revenue\t"); Response.Write("Spa Revenue\t"); Response.Write("Others\t"); Response.Write("Total\t"); Response.Write("Budget\t"); Response.Write("\n"); hr.HotelRevenueId = revenue[i].HotelRevenueId; hr.Month = month; hr.Year = year; var listRevenue = RevenueHelper.ListRevenueEntryByMonthYear(hr); var total = CalculateTotal(listRevenue); for (var j = 0; j < listRevenue.Count; j++) { var date = DateTime.Parse(listRevenue[j].PositionDate.ToString()); Response.Write(date.ToShortDateString() + "\t"); Response.Write(listRevenue[j].OccupancyRoom.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].RoomRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].FBRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].SpaRevenue.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Others.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Total.ToString("#,##0.00") + "\t"); Response.Write(listRevenue[j].Budget.ToString("#,##0.00") + "\t"); Response.Write("\n"); } Response.Write("Total" + "\t"); Response.Write("-" + "\t"); Response.Write(total[0].ToString("#,##0.00") + "\t"); Response.Write(total[1].ToString("#,##0.00") + "\t"); Response.Write(total[2].ToString("#,##0.00") + "\t"); Response.Write(total[3].ToString("#,##0.00") + "\t"); Response.Write(total[4].ToString("#,##0.00") + "\t"); Response.Write(total[5].ToString("#,##0.00") + "\t"); Response.Write("\n"); Response.Write("\n"); Response.Write("\n"); } Response.Write("\n"); Response.Write("Print Date: [" + DateTime.Now + "] "); Response.Write("\r\n"); Response.End(); }