/// <summary> /// Author: Charlene Remotigue /// Date Created: 18/01/2012 /// Description: get branch matrix /// </summary> protected void getBranchMatrix() { DataTable dt = null; try { uoHiddenFieldUser.Value = GlobalCode.Field2String(Session["UserName"]); AutomaticBookingBLL.SaveTempAutomaticBookings(DateTime.Parse(uoHiddenFieldStartDate.Value), Int32.Parse(uoHiddenFieldUserBranch.Value), uoHiddenFieldUser.Value); GetSFHotelTravelDetails(); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
private void ApproveRequest() { IDataReader dr = null; DataTable dTable = null; try { string strFunction = "ApproveRequest"; string ApproveByString = GlobalCode.Field2String(Session["UserName"]); string InvalidTravelReq = ""; foreach (ListViewItem item in uoHotelList.Items) { CheckBox CheckSelect = (CheckBox)item.FindControl("uoSelectCheckBox"); bool IsApprovedBool = CheckSelect.Checked; HiddenField uoHiddenFieldIsManual = (HiddenField)item.FindControl("uoHiddenFieldIsManual"); HiddenField uoPendingId = (HiddenField)item.FindControl("uoHiddenFieldColIdBigInt"); DateTime currentDate = CommonFunctions.GetCurrentDateTime(); if (IsApprovedBool) { if (uoHiddenFieldIsManual.Value == "Yes") { dTable = HotelBLL.HotelApproveTransaction(uoPendingId.Value, GlobalCode.Field2String(Session["UserName"])); } else { String UserId = GlobalCode.Field2String(Session["UserName"]); Label Duration = (Label)item.FindControl("uoLblDuration"); HiddenField TravelReqId = (HiddenField)item.FindControl("hfTRID"); HiddenField ManualReqId = (HiddenField)item.FindControl("hfMRID"); Label RecLoc = (Label)item.FindControl("uoLblRecLoc"); HiddenField VendorId = (HiddenField)item.FindControl("hfVendor"); //HiddenField HiddenID = (HiddenField)item.FindControl("uoHiddenFieldColIdBigInt"); HiddenField BranchID = (HiddenField)item.FindControl("hfBranch"); HiddenField RoomTypeId = (HiddenField)item.FindControl("hfRoom"); HiddenField CheckIndate = (HiddenField)item.FindControl("hfCheckIn"); HiddenField CheckOutDate = (HiddenField)item.FindControl("hfCheckOut"); //HiddenField HotelStatus= (HiddenField)item.FindControl("hfHotelStatus"); HiddenField SFStatus = (HiddenField)item.FindControl("hfSFStatus"); HiddenField CityId = (HiddenField)item.FindControl("hfCity"); HiddenField CountryId = (HiddenField)item.FindControl("hfCountry"); HiddenField ContractId = (HiddenField)item.FindControl("hfContractID"); Label Voucher = (Label)item.FindControl("uoLblVoucher"); HiddenField DataSource = (HiddenField)item.FindControl("hfDatasource"); HiddenField PendingId = (HiddenField)item.FindControl("uoHiddenFieldColIdBigInt"); HiddenField HotelName = (HiddenField)item.FindControl("hfHotelName"); Label E1ID = (Label)item.FindControl("uoLblE1ID"); HiddenField Name = (HiddenField)item.FindControl("hfName"); Boolean valid = true; if (PendingId.Value == "0") { valid = AutomaticBookingBLL.ApproveBookings(Int32.Parse(TravelReqId.Value), RecLoc.Text, Int32.Parse(VendorId.Value), Int32.Parse(BranchID.Value), Int32.Parse(RoomTypeId.Value), DateTime.Parse(CheckIndate.Value), DateTime.Parse(CheckOutDate.Value), SFStatus.Value, Int32.Parse(CityId.Value), Int32.Parse(CountryId.Value), Voucher.Text, Int32.Parse(ContractId.Value), UserId, strFunction, Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(currentDate), DateTime.Now); } else { HotelBLL.HotelApproveTransaction(PendingId.Value, UserId); } if (!valid) { InvalidTravelReq = InvalidTravelReq + TravelReqId.Value + ","; } else { //dr = VendorMaintenanceBLL.vehicleVendorBranchMaintenanceInformation(Int32.Parse(BranchID.Value)); //if (dr.Read()) //{ string sMsg = "Booking of seafarer <b>" + Name.Value + "</b> with E1 ID <b>" + E1ID.Text + "</b> has been approved. <br/><br/>"; sMsg += "Hotel Branch: " + HotelName.Value + "<br/>"; sMsg += "Checkin Date: " + CheckIndate.Value + ""; sMsg += "<br/><br/>Thank you."; sMsg += "<br/><br/><i>Auto generated email.</i>"; //SendEmail("Travelmart: Pending Hotel Booking Approval", sMsg, CountryId.Value, BranchID.Value); //} } } } } if (InvalidTravelReq != "") { AlertMessage("Some bookings were not approved. Please check the room allocations of the highlighed transactions."); ViewState["InvalidRequest"] = InvalidTravelReq.TrimEnd(',').ToString(); } else { AlertMessage("Approved"); } SetDefaults(3); } catch (Exception ex) { AlertMessage(ex.Message); throw ex; } finally { if (dr != null) { dr.Close(); dr.Dispose(); } if (dTable != null) { dTable.Dispose(); } } }