/// <summary>
/// Date Created: 29/Jul/2015
/// Created By: Josephine Monteza
/// Description: Request Room to Other Hotel
/// </summary>
private void RequestRoom()
{
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dtDate = GlobalCode.Field2DateTime(uoHiddenFieldDateSelected.Value);
Int32 iBranchIDSGL = GlobalCode.Field2Int(uoHiddenFieldHotelSGL.Value);
Int32 iBranchIDDBL = GlobalCode.Field2Int(uoHiddenFieldHotelDBL.Value);
Int32 iBranchID = GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue);
int iRoomCountSGL = GlobalCode.Field2Int(uoHiddenFieldRoomCountSGL.Value);
int iRoomCountDBL = GlobalCode.Field2Int(uoHiddenFieldRoomCountDBL.Value);
BLL.RequestHotelRoom(dtDate, uoCheckBoxSGL.Checked, uoCheckBoxDBL.Checked,
iBranchID, iBranchIDSGL, iBranchIDDBL, iRoomCountSGL, iRoomCountDBL,
uoHiddenFieldUser.Value, "Adjust Forecast through Request", "RequestRoom",
Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(dateNow));
GetSFHotelTravelDetails();
AlertMessage("Record successfully saved!");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 22/02/2011
/// Created By: Josephine Gad
/// (description) disable lock button if past dates and if there is no data
/// -------------------------------------------------------
/// Date Modified: 23/03/2012
/// Modified By: Josephine Gad
/// (description) disable lock button if already locked
/// -------------------------------------------------------
/// Date Modified: 02/10/2012
/// Modified By: Josephine Gad
/// (description) disable lock button if "ALL Hotel" is selected
/// -------------------------------------------------------
/// </summary>
//private void ButtonLockSettings()
//{
// if (uolistviewHotelInfo.Items.Count > 0)
// {
// //uoBtnExportList.Enabled = true;
// if (uoDropDownListHotel.SelectedValue == "-1")
// {
// //uoButtonLock.Enabled = false;
// }
// }
// else
// {
// //uoBtnExportList.Enabled = false;
// }
// string sDate = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString();
// if (GlobalCode.Field2DateTime((sDate)) < DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy")))
// {
// //uoButtonLock.Enabled = false;
// }
// //bool IsAlreadyLocked = HotelManifestBLL.IsHotelHasLockedManifest(sDate, uoDropDownListHotel.SelectedValue, uoDropDownListHours.SelectedValue);
// //if (IsAlreadyLocked)
// //{
// // uoButtonLock.Enabled = false;
// //}
//}
/// <summary>
/// Date Created: 05/May/2015
/// Created By: Josephine Monteza
/// (description) Save the Additional Room to Hotel Room Blocks
/// -------------------------------------------------------
/// </summary>
private void ApproveHotelForecast()
{
DataTable dt = null;
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dateOnly = GlobalCode.Field2DateTime(dateNow.ToString("MM/dd/yyyy"));
Label listLabelDate;
HiddenField listHiddenFieldToAddDBL;
HiddenField listHiddenFieldToAddSGL;
TextBox listTextBoxDBL;
TextBox listTextBoxSGL;
int iCount = uolistviewHotelInfo.Items.Count;
int iHotelID = GlobalCode.Field2Int(uoHiddenFieldHotelID.Value);
DataColumn colBranchIDInt = new DataColumn("colBranchIDInt", typeof(Int64));
DataColumn colDate = new DataColumn("colDate", typeof(DateTime));
DataColumn colToAddDBL = new DataColumn("colToAddDBL", typeof(int));
DataColumn colToAddSGL = new DataColumn("colToAddSGL", typeof(int));
dt = new DataTable();
dt.Columns.Add(colBranchIDInt);
dt.Columns.Add(colDate);
dt.Columns.Add(colToAddDBL);
dt.Columns.Add(colToAddSGL);
DataRow r;
DateTime rowDate;
CheckBox lvuoCheckBoxSelect;
for (int i = 0; i < iCount; i++)
{
lvuoCheckBoxSelect = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxSelect");
if (lvuoCheckBoxSelect.Checked)
{
listLabelDate = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelDate");
rowDate = GlobalCode.Field2DateTime(listLabelDate.Text);
if (rowDate >= dateOnly)
{
listHiddenFieldToAddDBL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddDBL");
listHiddenFieldToAddSGL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddSGL");
listTextBoxDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxDBL");
listTextBoxSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxSGL");
int iToAddDBLOld = GlobalCode.Field2Int(listHiddenFieldToAddDBL.Value);
int iToAddSGLOld = GlobalCode.Field2Int(listHiddenFieldToAddSGL.Value);
int iToAddDBLNew = GlobalCode.Field2Int(listTextBoxDBL.Text);
int iToAddSGLNew = GlobalCode.Field2Int(listTextBoxSGL.Text);
//if (iToAddDBLOld != iToAddDBLNew ||
// iToAddSGLOld != iToAddSGLNew)
//{
r = dt.NewRow();
r["colBranchIDInt"] = iHotelID;
r["colDate"] = rowDate;
r["colToAddDBL"] = iToAddDBLNew;
r["colToAddSGL"] = iToAddSGLNew;
dt.Rows.Add(r);
//}
}
}
}
if (dt.Rows.Count > 0)
{
BLL.ApproveForecastManifest(GlobalCode.Field2Int(uoHiddenFieldHotelID.Value),
//GlobalCode.Field2Float(uoTextBoxRateSingle.Text),
//GlobalCode.Field2Int(uoDropDownListCurrencySingle.SelectedValue),
//GlobalCode.Field2Float(uoTextBoxTaxSingle.Text),
//uoCheckBoxTaxInclusiveSingle.Checked,
//GlobalCode.Field2Float(uoTextBoxRateDouble.Text),
//GlobalCode.Field2Int(uoDropDownListCurrencyDouble.SelectedValue),
//GlobalCode.Field2Float(uoTextBoxTaxDouble.Text),
//uoCheckBoxTaxInclusiveDouble.Checked,
uoHiddenFieldUser.Value, "Add Override Forecast by Vendor", "SaveHotelForecast",
Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt);
GetSFHotelTravelDetails();
AlertMessage("Record successfully saved!");
}
else
{
AlertMessage("No record changed!");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 07/Oct/2015
/// Created By: Josephine Monteza
/// (description) Save the Additional Room to Hotel Room Blocks by RCCL
/// -------------------------------------------------------
/// </summary>
private void ApproveHotelForecast()
{
DataTable dt = null;
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dateOnly = GlobalCode.Field2DateTime(dateNow.ToString("MM/dd/yyyy"));
Label listLabelDate;
//HiddenField listHiddenFieldToAddDBL;
//HiddenField listHiddenFieldToAddSGL;
//TextBox listTextBoxDBL;
//TextBox listTextBoxSGL;
TextBox listTextBoxRoomToDropDBL;
TextBox listTextBoxRoomToDropSGL;
//TextBox listTextBoxRatePerDayMoneyDBL;
//TextBox listTextBoxRatePerDayMoneySGL;
//TextBox listTextBoxRoomRateTaxPercentage;
//CheckBox listCheckBoxTaxInclusive;
Label listLabelRoomApprovedSGL;
Label listLabelRoomApprovedDBL;
CheckBox listCheckBoxApprove;
HiddenField listHiddenFieldAction;
int iCount = uolistviewHotelInfo.Items.Count;
int iHotelID = GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue);
DataColumn colBranchIDInt = new DataColumn("colBranchIDInt", typeof(Int64));
DataColumn colDate = new DataColumn("colDate", typeof(DateTime));
DataColumn colToAddDBL = new DataColumn("colToAddDBL", typeof(int));
DataColumn colToAddSGL = new DataColumn("colToAddSGL", typeof(int));
DataColumn colAction = new DataColumn("colAction", typeof(string));
DataColumn colRoomToDropDBL = new DataColumn("colRoomToDropDBL", typeof(int));
DataColumn colRoomToDropSGL = new DataColumn("colRoomToDropSGL", typeof(int));
DataColumn colRatePerDayMoneySGL = new DataColumn("colRatePerDayMoneySGL", typeof(float));
DataColumn colRatePerDayMoneyDBL = new DataColumn("colRatePerDayMoneyDBL", typeof(float));
DataColumn colCurrencyIDInt = new DataColumn("colCurrencyIDInt", typeof(int));
DataColumn colRoomRateTaxPercentage = new DataColumn("colRoomRateTaxPercentage", typeof(float));
DataColumn colRoomRateIsTaxInclusive = new DataColumn("colRoomRateIsTaxInclusive", typeof(float));
dt = new DataTable();
dt.Columns.Add(colBranchIDInt);
dt.Columns.Add(colDate);
dt.Columns.Add(colToAddDBL);
dt.Columns.Add(colToAddSGL);
dt.Columns.Add(colAction);
dt.Columns.Add(colRoomToDropDBL);
dt.Columns.Add(colRoomToDropSGL);
dt.Columns.Add(colRatePerDayMoneySGL);
dt.Columns.Add(colRatePerDayMoneyDBL);
dt.Columns.Add(colCurrencyIDInt);
dt.Columns.Add(colRoomRateTaxPercentage);
dt.Columns.Add(colRoomRateIsTaxInclusive);
DataRow r;
DateTime rowDate;
//CheckBox lvuoCheckBoxSelect;
for (int i = 0; i < iCount; i++)
{
listCheckBoxApprove = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxApprove");
if (listCheckBoxApprove.Checked)
{
listHiddenFieldAction = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldAction");
listLabelDate = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelDate");
rowDate = GlobalCode.Field2DateTime(listLabelDate.Text);
if (rowDate >= dateOnly)
{
//listHiddenFieldToAddDBL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddDBL");
//listHiddenFieldToAddSGL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddSGL");
listLabelRoomApprovedDBL = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelRoomApprovedDBL");
listLabelRoomApprovedSGL = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelRoomApprovedSGL");
//listTextBoxDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxToAddDBL");
//listTextBoxSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxToAddSGL");
listTextBoxRoomToDropDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropDBL");
listTextBoxRoomToDropSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropSGL");
//listTextBoxRatePerDayMoneyDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRatePerDayMoneyDBL");
//listTextBoxRatePerDayMoneySGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRatePerDayMoneySGL");
//listTextBoxRoomRateTaxPercentage = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomRateTaxPercentage"); ;
//listCheckBoxTaxInclusive = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxTaxInclusive");
//int iToAddDBLOld = GlobalCode.Field2Int(listHiddenFieldToAddDBL.Value);
//int iToAddSGLOld = GlobalCode.Field2Int(listHiddenFieldToAddSGL.Value);
int iToAddDBLNew = GlobalCode.Field2Int(listLabelRoomApprovedDBL.Text);
int iToAddSGLNew = GlobalCode.Field2Int(listLabelRoomApprovedSGL.Text);
int iToDropDBL = GlobalCode.Field2Int(listTextBoxRoomToDropDBL.Text);
int iToDropSGL = GlobalCode.Field2Int(listTextBoxRoomToDropSGL.Text);
//float fRatePerDayMoneyDBL = GlobalCode.Field2Float(listTextBoxRatePerDayMoneyDBL.Text);
//float fRatePerDayMoneySGL = GlobalCode.Field2Float(listTextBoxRatePerDayMoneySGL.Text);
//int iCurrency = GlobalCode.Field2Int(uoHiddenFieldCurrency.Value);
//float fTaxPercent = GlobalCode.Field2Float(listTextBoxRoomRateTaxPercentage.Text);
//bool bIsTaxInclusiveSingle = listCheckBoxTaxInclusive.Checked;
//if (iToAddDBLOld != iToAddDBLNew ||
// iToAddSGLOld != iToAddSGLNew)
//{
r = dt.NewRow();
r["colBranchIDInt"] = iHotelID;
r["colDate"] = rowDate;
r["colToAddDBL"] = iToAddDBLNew;
r["colToAddSGL"] = iToAddSGLNew;
r["colAction"] = listHiddenFieldAction.Value;
r["colRoomToDropDBL"] = iToDropDBL;
r["colRoomToDropSGL"] = iToDropSGL;
//r["colRatePerDayMoneySGL"] = fRatePerDayMoneySGL;
//r["colRatePerDayMoneyDBL"] = fRatePerDayMoneyDBL;
//r["colCurrencyIDInt"] = iCurrency;
//r["colRoomRateTaxPercentage"] = fTaxPercent;
//r["colRoomRateIsTaxInclusive"] = bIsTaxInclusiveSingle;
dt.Rows.Add(r);
//}
}
}
}
if (dt.Rows.Count > 0)
{
BLL.ApproveForecastManifestByRCCL(GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue),
uoHiddenFieldUser.Value, "Add Override Forecast by RCCl Approval", "ApproveHotelForecast",
Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt);
GetSFHotelTravelDetails();
AlertMessage("Record successfully approved!");
}
else
{
AlertMessage("No record changed!");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 04/Feb/2015
/// Created By: Josephine Monteza
/// (description) Save the "ToBeAdded" column for Vendor's approval
/// -------------------------------------------------------
/// </summary>
private void SaveHotelForecast()
{
DataTable dt = null;
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dateOnly = GlobalCode.Field2DateTime(dateNow.ToString("MM/dd/yyyy"));
Label listLabelDate;
//HiddenField listHiddenFieldToAddDBL;
//HiddenField listHiddenFieldToAddSGL;
TextBox listTextBoxDBL;
TextBox listTextBoxSGL;
TextBox listTextBoxRemarks;
TextBox listTextBoxRoomToDropDBL;
TextBox listTextBoxRoomToDropSGL;
CheckBox listCheckBoxSelect;
int iCount = uolistviewHotelInfo.Items.Count;
int iHotelID = GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue);
DataColumn colBranchIDInt = new DataColumn("colBranchIDInt", typeof(Int64));
DataColumn colDate = new DataColumn("colDate", typeof(DateTime));
DataColumn colForecastDBLAdj = new DataColumn("colForecastDBLAdj", typeof(int));
DataColumn colForecastSGLAdj = new DataColumn("colForecastSGLAdj", typeof(int));
DataColumn colRemarksVarchar = new DataColumn("colRemarksVarchar", typeof(string));
DataColumn colRoomToDropDBL = new DataColumn("colRoomToDropDBL", typeof(int));
DataColumn colRoomToDropSGL = new DataColumn("colRoomToDropSGL", typeof(int));
dt = new DataTable();
dt.Columns.Add(colBranchIDInt);
dt.Columns.Add(colDate);
dt.Columns.Add(colForecastDBLAdj);
dt.Columns.Add(colForecastSGLAdj);
dt.Columns.Add(colRemarksVarchar);
dt.Columns.Add(colRoomToDropDBL);
dt.Columns.Add(colRoomToDropSGL);
DataRow r;
DateTime rowDate;
for (int i = 0; i < iCount; i++)
{
listLabelDate = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelDate");
rowDate = GlobalCode.Field2DateTime(listLabelDate.Text);
if (rowDate >= dateOnly)
{
listCheckBoxSelect = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxSelect");
if (listCheckBoxSelect.Checked)
{
//listHiddenFieldToAddDBL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddDBL");
//listHiddenFieldToAddSGL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddSGL");
listTextBoxDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxDBLAdj");
listTextBoxSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxSGLAdj");
listTextBoxRemarks = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRemarks");
listTextBoxRoomToDropDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropDBL");
listTextBoxRoomToDropSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropSGL");
int iToAddDBLAdj = GlobalCode.Field2Int(listTextBoxDBL.Text);
int iToAddSGLAdj = GlobalCode.Field2Int(listTextBoxSGL.Text);
int iRoomToDropDBL = GlobalCode.Field2Int(listTextBoxRoomToDropDBL.Text);
int iRoomToDropSGL = GlobalCode.Field2Int(listTextBoxRoomToDropSGL.Text);
r = dt.NewRow();
r["colBranchIDInt"] = iHotelID;
r["colDate"] = rowDate;
r["colForecastDBLAdj"] = iToAddDBLAdj;
r["colForecastSGLAdj"] = iToAddSGLAdj;
r["colRemarksVarchar"] = listTextBoxRemarks.Text;
r["colRoomToDropDBL"] = iRoomToDropDBL;
r["colRoomToDropSGL"] = iRoomToDropSGL;
dt.Rows.Add(r);
}
}
}
if (dt.Rows.Count > 0)
{
BLL.UpdateForecastManifest(GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue),
uoHiddenFieldUser.Value, "Adjust Forecast", "SaveHotelForecast",
Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt);
GetSFHotelTravelDetails();
AlertMessage("Record successfully saved!");
}
else
{
AlertMessage("No record changed!");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
