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