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