private void FillTouristDetails(BookingTouristDTO oBookingTouristDTO) { ddlSuffix.Text = oBookingTouristDTO.Suffix; txtAllerges.Text = oBookingTouristDTO.Allergies.ToString(); txtArrivaldate.Text = oBookingTouristDTO.ArrivalDateTime == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.ArrivalDateTime, false); txtBirthPlace.Text = oBookingTouristDTO.PlaceofBirth.ToString(); txtDOB.Text = oBookingTouristDTO.DateOfBirth == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.DateOfBirth, false); txtFName.Text = oBookingTouristDTO.FirstName.ToString(); txtMName.Text = oBookingTouristDTO.MiddleName.ToString(); txtLName.Text = oBookingTouristDTO.LastName.ToString(); txtEmailId.Text = oBookingTouristDTO.EmailId.ToString(); ddlGender.SelectedValue = oBookingTouristDTO.Gender == '\0' ? "0" : oBookingTouristDTO.Gender.ToString(); ddlNationality.Text = oBookingTouristDTO.NationalityId.ToString(); txtMealPref.Text = oBookingTouristDTO.MealPreferences.ToString(); txtMessage.Text = oBookingTouristDTO.SpecialMessage.ToString(); txtPassportExpiryDate.Text = oBookingTouristDTO.PassportExpiryDate == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.PassportExpiryDate, false); txtPassportIssueDate.Text = oBookingTouristDTO.PassportIssueDate == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.PassportIssueDate, false); txtPassportNo.Text = oBookingTouristDTO.PassportNo.ToString(); txtPermAdd.Text = oBookingTouristDTO.PermanentAddressInIndia.ToString(); txtProStayInIndia.Text = String.IsNullOrEmpty(oBookingTouristDTO.ProposedStayInIndia) ? String.Empty : oBookingTouristDTO.ProposedStayInIndia; txtRoomDetails.Text = oBookingTouristDTO.RoomDetails.ToString(); txtVisaExpiryDate.Text = oBookingTouristDTO.VisaExpiryDate == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.VisaExpiryDate, false); txtVisaNo.Text = oBookingTouristDTO.VisaNo.ToString(); txtVisitPurpose.Text = oBookingTouristDTO.VisitPurpose.ToString(); txtIndiaEntryDate.Text = oBookingTouristDTO.IndiaEntryDate == DateTime.MinValue ? "" : GF.Handle19000101(oBookingTouristDTO.IndiaEntryDate, false); }
protected void Page_Load(object sender, EventArgs e) { TouristServices touristServices = null; AddAttributes(); if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } if (Request.QueryString["tno"] != null) { TouristNo = Convert.ToInt32(Request.QueryString["tno"]); } SessionServices.TouristDetails_BookingNo = BookingId; if (SessionServices.TouristDetails_TouristNo > 0) { TouristNo = SessionServices.TouristDetails_TouristNo; touristServices = new TouristServices(); BookingTouristDTO oBTData = touristServices.GetBookingTouristDetails(BookingId, TouristNo); if (oBTData != null) { FillTouristDetails(oBTData); } touristServices = null; oBTData = null; SessionServices.DeleteSession(Constants._TouristDetails_TouristNo); } if (!IsPostBack) { FillNationality(); radEmpNo.Checked = true; if (Request.QueryString["op"] == "edit") { btnSaveTouristDetails.Text = "Update"; if (touristServices == null) { touristServices = new TouristServices(); } BookingTouristDTO oBTData = touristServices.GetBookingTouristDetails(BookingId, TouristNo); if (oBTData != null) { FillTouristDetails(oBTData); } touristServices = null; oBTData = null; } else { btnDelete.Visible = false; } System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(this.ddlSuffix); } }
private void UpdateTouristDetails() { if (base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update)) { TouristServices touristServices = new TouristServices(); BookingTouristDTO oTouristDTO = new BookingTouristDTO(); oTouristDTO = SetDatatoObject(); touristServices.UpdateBookingTourist(oTouristDTO); Response.Redirect("afterBookingTouristactions.aspx?bid=" + BookingId + "&tno=" + TouristNo + "&tstatus=upd"); } }
private void UpdateTouristDetails() { //if (base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update)) //{ TouristServices touristServices = new TouristServices(); BookingTouristDTO oTouristDTO = new BookingTouristDTO(); TouristNo = Convert.ToInt32(Session["gettouristno"].ToString()); BookingId = Convert.ToInt32(Session["getbookingid"].ToString()); oTouristDTO = SetDatatoObject(); touristServices.UpdateBookingTourist(oTouristDTO); //} }
public bool UpdateBookingTourist(BookingTouristDTO oBookingTouristDTO) { try { if (touristHelper == null) { touristHelper = new TouristHelper(); } return(touristHelper.UpdateBookingTourist(oBookingTouristDTO)); } catch (Exception exp) { throw exp; } }
public bool AddBookingTourist(BookingTouristDTO oBookingTouristDTO, out int TouristNo) { try { if (touristHandler == null) { touristHandler = new BookingTouristHandler(); } return(touristHandler.InsertTouristDetails(oBookingTouristDTO, out TouristNo)); } catch (Exception exp) { throw exp; } }
public bool AddBookingTouristentry(BookingTouristDTO oBookingTouristDTO, out int TouristNo) { try { if (touristHelper == null) { touristHelper = new TouristHelper(); } return(touristHelper.Addtouristentry(oBookingTouristDTO, out TouristNo)); } catch (Exception exp) { throw exp; } }
private void SaveTouristDetail() { int touristNo; if (base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add)) { TouristServices touristServices = new TouristServices(); BookingTouristDTO oTouristDTO = new BookingTouristDTO(); oTouristDTO = SetDatatoObject(); touristServices.AddBookingTourist(oTouristDTO, out touristNo); touristServices = null; //EmptyUncommonFields(); Response.Redirect("afterBookingTouristactions.aspx?bid=" + BookingId + "&tno=" + touristNo + "&tstatus=ins"); } }
private BookingTouristDTO[] GetIndianNationalsData(BookingTouristDTO[] bookingTouristDetailsDto) { List <BookingTouristDTO> bookingTouristList = new List <BookingTouristDTO>(); BookingTouristDTO bookingTouristDTO; for (int i = 0; i < bookingTouristDetailsDto.Length; i++) { if (bookingTouristDetailsDto[i].NationalityId == GF.GetIndianNatinalityId()) { bookingTouristDTO = new BookingTouristDTO(); bookingTouristDTO = bookingTouristDetailsDto[i]; bookingTouristList.Add(bookingTouristDTO); } } return(bookingTouristList.ToArray()); }
public BookingTouristDTO GetTouristDetails(int BookingId, int TouristNo) { try { BookingTouristDTO[] oBookingTouristDTO; BookingTouristDTO oBTD = null; oBookingTouristDTO = GetTouristsDetails(BookingId, TouristNo); if (oBookingTouristDTO != null && oBookingTouristDTO.Length > 0) { oBTD = oBookingTouristDTO[0]; } return(oBTD); } catch (Exception exp) { throw exp; } }
private void SaveTouristDetail() { int touristNo; //if (base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add)) //{ TouristServices touristServices = new TouristServices(); BookingTouristDTO oTouristDTO = new BookingTouristDTO(); if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } oTouristDTO = SetDatatoObject(); touristServices.AddBookingTouristentry(oTouristDTO, out touristNo); touristServices = null; //EmptyUncommonFields(); //Response.Redirect("afterBookingTouristactions.aspx?bid=" + BookingId + "&tno=" + touristNo + "&tstatus=ins"); //} }
private BookingTouristDTO[] FillTouristDetails(DataSet ds) { DataRow dr; BookingTouristDTO[] oBookingTouristDTO = null; if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; #region AssigningValues for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(1))); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(2))); } if (dr.ItemArray.GetValue(3) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))); } if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].Nationality = Convert.ToString(dr.ItemArray.GetValue(4)); } } #endregion AssigningValues } } return(oBookingTouristDTO); }
protected void GridRoomPaxDetail_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Edit") { if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } TouristNo = Convert.ToInt32(e.CommandArgument.ToString()); Session["gettouristno"] = TouristNo; Session["getbookingid"] = BookingId; TouristServices touristServices = null; touristServices = new TouristServices(); BookingTouristDTO oBTData = touristServices.GetBookingTouristDetails(BookingId, TouristNo); if (oBTData != null) { FillTouristDetails(oBTData); } SetDatatoObject(); btnSubmit.Text = "Update"; touristServices = null; oBTData = null; } }
private TableRow GetTouristRow(BookingTouristDTO bookingTouristDTO) { TableRow touristRow = new TableHeaderRow(); TableCell touristCell; touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.CFormNo.ToString("0000"); touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.RoomDetails; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.RoomDetails; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.Suffix; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.FirstName; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.MiddleName; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.LastName; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.Gender.ToString(); touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.Nationality; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; if (bookingTouristDTO.DateOfBirth == DateTime.MinValue || bookingTouristDTO.DateOfBirth == DateTime.MaxValue) { touristCell.Text = string.Empty; } else { touristCell.Text = GF.GetDD_MM_YYYY(bookingTouristDTO.DateOfBirth); } touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.PlaceofBirth; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.PassportNo; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; if (bookingTouristDTO.PassportIssueDate == DateTime.MinValue || bookingTouristDTO.PassportIssueDate == DateTime.MaxValue) { touristCell.Text = string.Empty; } else { touristCell.Text = GF.GetDD_MM_YYYY(bookingTouristDTO.PassportIssueDate); } touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; if (bookingTouristDTO.PassportExpiryDate == DateTime.MinValue || bookingTouristDTO.PassportExpiryDate == DateTime.MaxValue) { touristCell.Text = string.Empty; } else { touristCell.Text = GF.GetDD_MM_YYYY(bookingTouristDTO.PassportExpiryDate); } touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; touristCell.Text = bookingTouristDTO.VisaNo; touristRow.Cells.Add(touristCell); touristCell = new TableCell(); touristCell.CssClass = "dataRowCell"; if (bookingTouristDTO.VisaExpiryDate == DateTime.MinValue || bookingTouristDTO.VisaExpiryDate == DateTime.MaxValue) { touristCell.Text = string.Empty; } else { touristCell.Text = GF.GetDD_MM_YYYY(bookingTouristDTO.VisaExpiryDate); } touristRow.Cells.Add(touristCell); return(touristRow); }
private BookingTouristDTO SetDatatoObject() { DateTime result; BookingTouristDTO oTouristDTO = new BookingTouristDTO(); oTouristDTO.BookingId = BookingId; oTouristDTO.TouristNo = TouristNo; oTouristDTO.Allergies = txtAllerges.Text.ToString(); result = DateTime.MinValue; if (txtArrivaldate.Text.Trim() != "") { DateTime.TryParse(txtArrivaldate.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.ArrivalDateTime = result; } result = DateTime.MinValue; if (txtDOB.Text.Trim() != "") { DateTime.TryParse(txtDOB.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.DateOfBirth = result; } oTouristDTO.EmployedinIndia = true; oTouristDTO.Suffix = ddlSuffix.Text.ToString(); oTouristDTO.FirstName = txtFName.Text.ToString(); oTouristDTO.MiddleName = txtMName.Text.ToString(); oTouristDTO.Gender = Convert.ToChar(ddlGender.SelectedValue.ToString()); oTouristDTO.EmailId = txtEmailId.Text.ToString(); result = DateTime.MinValue; if (txtIndiaEntryDate.Text.Trim() != "") { DateTime.TryParse(txtIndiaEntryDate.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.IndiaEntryDate = result; } oTouristDTO.LastName = txtLName.Text.ToString(); oTouristDTO.MealPreferences = txtMealPref.Text.ToString(); oTouristDTO.NationalityId = Convert.ToInt32(ddlNationality.SelectedValue.ToString()); result = DateTime.MinValue; if (txtPassportExpiryDate.Text.Trim() != "") { DateTime.TryParse(txtPassportExpiryDate.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.PassportExpiryDate = result; } result = DateTime.MinValue; if (txtPassportIssueDate.Text.Trim() != "") { DateTime.TryParse(txtPassportIssueDate.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.PassportIssueDate = result; } oTouristDTO.PassportNo = txtPassportNo.Text.ToString(); oTouristDTO.PermanentAddressInIndia = txtPermAdd.Text.ToString(); oTouristDTO.PlaceofBirth = txtBirthPlace.Text.ToString(); oTouristDTO.ProposedStayInIndia = txtProStayInIndia.Text.Trim(); oTouristDTO.RoomDetails = txtRoomDetails.Text.ToString(); oTouristDTO.SpecialMessage = txtMessage.Text.ToString(); result = DateTime.MinValue; if (txtVisaExpiryDate.Text.Trim() != "") { DateTime.TryParse(txtVisaExpiryDate.Text, out result); } if (result != DateTime.MinValue && result != DateTime.MaxValue) { oTouristDTO.VisaExpiryDate = result; } oTouristDTO.VisaNo = txtVisaNo.Text.ToString(); oTouristDTO.VisitPurpose = txtVisitPurpose.Text.ToString(); return(oTouristDTO); }
protected void Page_Load(object sender, EventArgs e) { // txtPassportNo.Text = "VDIzaDQ1aXMxMjRJNTRz"; //string PassportNo = DataSecurityManager.Decrypt(txtPassportNo.Text.ToString()); //string t = "VDIzaDQ1aXMxMjRJNTRz"; //string PassportNo = DataSecurityManager.Decrypt(t.ToString()); if (Session["CustName"] != null) { navlogin.Visible = false; lblUsername.Text = Session["CustName"].ToString(); } else { // Response.Redirect("http://test1.adventureresortscruises.in/Cruise/Booking/searchproperty1.aspx"); } TouristServices touristServices = null; //AddAttributes(); SessionServices.TouristDetails_BookingNo = BookingId; if (!IsPostBack) { if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } if (Request.QueryString["tno"] != null) { TouristNo = Convert.ToInt32(Request.QueryString["tno"]); } RefreshGrid(BookingId); if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } blsr._iBookingId = BookingId; blsr.action = "fetchbybookingId"; DataTable dt = dlsr.fetchbybookingid(blsr); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { paxcount = paxcount + Convert.ToInt32(dt.Rows[i]["NoOfPersons"].ToString()); } Session["getpaxcount"] = paxcount; } FillNationality(); radEmpNo.Checked = true; if (Request.QueryString["op"] == "edit") { btnSubmit.Text = "Update"; if (touristServices == null) { touristServices = new TouristServices(); } BookingTouristDTO oBTData = touristServices.GetBookingTouristDetails(BookingId, TouristNo); if (oBTData != null) { FillTouristDetails(oBTData); } touristServices = null; oBTData = null; } else { //btnDelete.Visible = false; } //System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(this.ddlSuffix); //Response.Redirect("http://test.adventureresortscruises.in/Cruise/Booking/NewRegister.aspx?bid=" + BookingId); } }
public BookingTouristDTO[] GetTouristsftr(string bcode, string email, string ppno, string firstName, DateTime chkin, DateTime chkout, int accomid) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; string sProcName; oBookingTouristDTO = null; try { oDB = new DatabaseManager(); sProcName = "up_Get_Touristsftr"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingCode", DbType.String, bcode); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@name", DbType.String, DataSecurityManager.Encrypt(firstName)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EmailId", DbType.String, email); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@passportNo", DbType.String, DataSecurityManager.Encrypt(ppno)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@chkindate", DbType.Date, chkin); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@chkoutdate", DbType.Date, chkout); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@accomid", DbType.Int32, accomid); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; // GF.LogError("clsBookingTouristHandler.GetTourist", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].BookingCode = Convert.ToString(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].BookingRef = Convert.ToString(dr.ItemArray.GetValue(1)); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].AgentName = dr.ItemArray.GetValue(2) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(2))) : string.Empty; } //if (dr.ItemArray.GetValue(3) != DBNull.Value) // oBookingTouristDTO[i].ClientName = Convert.ToString(dr.ItemArray.GetValue(3)); if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].Gender = Convert.ToChar(dr.ItemArray.GetValue(4)); } if (dr.ItemArray.GetValue(5) != DBNull.Value) { oBookingTouristDTO[i].DateOfBirth = Convert.ToDateTime(dr.ItemArray.GetValue(5)); } if (dr.ItemArray.GetValue(6) != DBNull.Value) { oBookingTouristDTO[i].Nationality = Convert.ToString(dr.ItemArray.GetValue(6)); } if (dr.ItemArray.GetValue(7) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = dr.ItemArray.GetValue(7) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(7))) : string.Empty; } if (dr.ItemArray.GetValue(8) != DBNull.Value) { oBookingTouristDTO[i].AccomName = Convert.ToString(dr.ItemArray.GetValue(8)); } if (dr.ItemArray.GetValue(9) != DBNull.Value) { oBookingTouristDTO[i].CheckinDate = Convert.ToDateTime(dr.ItemArray.GetValue(9)); } if (dr.ItemArray.GetValue(10) != DBNull.Value) { oBookingTouristDTO[i].CheckoutDate = Convert.ToDateTime(dr.ItemArray.GetValue(10)); } if (dr.ItemArray.GetValue(11) != DBNull.Value) { oBookingTouristDTO[i].EmailId = Convert.ToString(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != DBNull.Value) { oBookingTouristDTO[i].BookingId = Convert.ToInt32(dr.ItemArray.GetValue(12)); } if (dr.ItemArray.GetValue(13) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(13)); } if (dr.ItemArray.GetValue(14) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(14))); } if (dr.ItemArray.GetValue(15) != DBNull.Value) { oBookingTouristDTO[i].MiddleName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(15))); } if (dr.ItemArray.GetValue(16) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(16))); } } } } return(oBookingTouristDTO); }
private bool SaveData(BookingTouristDTO oBookingTouristDTO, Action oAction, out int TouristNo) { int iTouristNo = 0; TouristNo = 0; try { oDB = new DatabaseManager(); string sProcName = ""; if (oAction == Action.insert) { sProcName = "up_Ins_BookingTourist"; } else if (oAction == Action.update) { sProcName = "up_Upd_BookingTourist"; } oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, oBookingTouristDTO.BookingId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingCode", DbType.String, oBookingTouristDTO.BookingCode == null ? string.Empty : oBookingTouristDTO.BookingCode); if (oAction == Action.update) { oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TouristNo", DbType.Int32, oBookingTouristDTO.TouristNo); } oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FirstName", DbType.String, DataSecurityManager.Encrypt(oBookingTouristDTO.FirstName)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MiddleName", DbType.String, DataSecurityManager.Encrypt(oBookingTouristDTO.MiddleName)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@LastName", DbType.String, DataSecurityManager.Encrypt(oBookingTouristDTO.LastName)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Gender", DbType.String, oBookingTouristDTO.Gender); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@NationalityId", DbType.Int32, oBookingTouristDTO.NationalityId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@PassportNo", DbType.String, DataSecurityManager.Encrypt(oBookingTouristDTO.PassportNo)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DOB", DbType.DateTime, oBookingTouristDTO.DateOfBirth); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@PlaceofBirth", DbType.String, oBookingTouristDTO.PlaceofBirth); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@PPIssueDate", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.PassportIssueDate, false)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@PPExpiryDate", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.PassportExpiryDate, false)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@VisaNo", DbType.String, DataSecurityManager.Encrypt(oBookingTouristDTO.VisaNo)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@VisaExpiryDate", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.VisaExpiryDate, false)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@IndiaEntryDate", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.IndiaEntryDate, false)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ProposedStayInIndia", DbType.String, oBookingTouristDTO.ProposedStayInIndia); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalDateTime", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.ArrivalDateTime, true)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivedFrom", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@VehicleNo", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TransportCompany", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TransportMode", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomDetails", DbType.String, oBookingTouristDTO.RoomDetails); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@NextDestination", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartureDateTime", DbType.DateTime, GF.HandleMaxMinDates(oBookingTouristDTO.departuredate, true)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EmployedinIndia", DbType.Boolean, oBookingTouristDTO.EmployedinIndia); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@VisitPurpose", DbType.String, oBookingTouristDTO.VisitPurpose); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@PermanentAddressInIndia", DbType.String, oBookingTouristDTO.PermanentAddressInIndia); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPlan", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Allergies", DbType.String, oBookingTouristDTO.Allergies); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MealPref", DbType.String, oBookingTouristDTO.MealPreferences); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SpecialMessage", DbType.String, oBookingTouristDTO.SpecialMessage); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@VehicleName", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DriverName", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DriverPhoneNo", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TransportPhoneNo", DbType.String, String.Empty); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Suffix", DbType.String, oBookingTouristDTO.Suffix); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EmailId", DbType.String, oBookingTouristDTO.EmailId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalVehicalno", DbType.String, oBookingTouristDTO.arrivalvehiaclno); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DpartureVehicalno", DbType.String, oBookingTouristDTO.departurevehicalno); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@DepartureCity", DbType.String, oBookingTouristDTO.departureairport); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ArrivalCity", DbType.String, oBookingTouristDTO.arrivalairport); iTouristNo = 0; if (oAction == Action.insert) { iTouristNo = Convert.ToInt32(oDB.ExecuteScalar(oDB.DbCmd)); } else if (oAction == Action.update) { oDB.ExecuteNonQuery(oDB.DbCmd); } TouristNo = iTouristNo; } catch (Exception exp) { oDB = null; oBookingTouristDTO = null; GF.LogError("clsBookingTouristHandler.SaveData", exp.Message); return(false); } return(true); }
public bool UpdateTouristDetails(BookingTouristDTO oBookingTouristDTO) { int iTouristNo; return(SaveData(oBookingTouristDTO, Action.update, out iTouristNo)); }
private BookingTouristDTO[] GetTouristsDetails(int BookingId, int TouristNo) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; oBookingTouristDTO = null; string sProcName; try { oDB = new DatabaseManager(); sProcName = "up_Get_TouristDetails"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TouristNo", DbType.Int32, TouristNo); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; GF.LogError("clsBookingTouristhandler.GetTouristDetails", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; #region AssigningValues for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); oBookingTouristDTO[i].BookingId = dr.ItemArray.GetValue(0) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(0)) : 0; oBookingTouristDTO[i].BookingCode = dr.ItemArray.GetValue(1) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(1)) : ""; oBookingTouristDTO[i].TouristNo = dr.ItemArray.GetValue(2) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(2)) : 0; oBookingTouristDTO[i].FirstName = dr.ItemArray.GetValue(3) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))) : ""; oBookingTouristDTO[i].MiddleName = dr.ItemArray.GetValue(4) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(4))) : ""; oBookingTouristDTO[i].LastName = dr.ItemArray.GetValue(5) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))) : ""; oBookingTouristDTO[i].Gender = dr.ItemArray.GetValue(6) != DBNull.Value ? Convert.ToChar(dr.ItemArray.GetValue(6)) : '\0'; oBookingTouristDTO[i].NationalityId = dr.ItemArray.GetValue(7) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(7)) : 0; oBookingTouristDTO[i].PassportNo = dr.ItemArray.GetValue(8) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(8))) : ""; oBookingTouristDTO[i].DateOfBirth = dr.ItemArray.GetValue(9) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(9).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].PlaceofBirth = dr.ItemArray.GetValue(10) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(10)) : ""; oBookingTouristDTO[i].PassportIssueDate = dr.ItemArray.GetValue(11) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(11).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].PassportExpiryDate = dr.ItemArray.GetValue(12) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(12).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].VisaNo = dr.ItemArray.GetValue(13) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(13))) : ""; oBookingTouristDTO[i].VisaExpiryDate = dr.ItemArray.GetValue(14) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(14).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].IndiaEntryDate = dr.ItemArray.GetValue(15) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(15).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].ProposedStayInIndia = dr.ItemArray.GetValue(16) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(16)) : ""; oBookingTouristDTO[i].ArrivalDateTime = dr.ItemArray.GetValue(17) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(17)) : DateTime.MinValue; //oBookingTouristDTO[i].ArrivedFrom = dr.ItemArray.GetValue(18) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(18)):""; //oBookingTouristDTO[i].VehicleNo = dr.ItemArray.GetValue(19) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(19)):""; //oBookingTouristDTO[i].TransportCompany = dr.ItemArray.GetValue(20) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(20)):""; //oBookingTouristDTO[i].TransportMode = dr.ItemArray.GetValue(21) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(21)):""; oBookingTouristDTO[i].RoomDetails = dr.ItemArray.GetValue(22) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(22)) : ""; //oBookingTouristDTO[i].NextDestination = dr.ItemArray.GetValue(23) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(23)):""; oBookingTouristDTO[i].departuredate = dr.ItemArray.GetValue(24) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(24)):DateTime.MinValue; oBookingTouristDTO[i].EmployedinIndia = dr.ItemArray.GetValue(25) != DBNull.Value ? Convert.ToBoolean(dr.ItemArray.GetValue(25)) : false; oBookingTouristDTO[i].VisitPurpose = dr.ItemArray.GetValue(26) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(26)) : ""; oBookingTouristDTO[i].PermanentAddressInIndia = dr.ItemArray.GetValue(27) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(27)) : ""; //oBookingTouristDTO[i].MealPlan = dr.ItemArray.GetValue(28) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(28)):""; oBookingTouristDTO[i].Allergies = dr.ItemArray.GetValue(29) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(29)) : ""; oBookingTouristDTO[i].MealPreferences = dr.ItemArray.GetValue(30) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(30)) : ""; oBookingTouristDTO[i].SpecialMessage = dr.ItemArray.GetValue(31) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(31)) : ""; //oBookingTouristDTO[i].VehicleName = dr.ItemArray.GetValue(32) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(32)) : ""; //oBookingTouristDTO[i].DriverName = dr.ItemArray.GetValue(33) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(33)) : ""; //oBookingTouristDTO[i].DriverPhoneNo = dr.ItemArray.GetValue(34) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(34)) : ""; //oBookingTouristDTO[i].TransportPhoneNo = dr.ItemArray.GetValue(35) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(35)) : ""; oBookingTouristDTO[i].Suffix = dr.ItemArray.GetValue(36) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(36)) : ""; oBookingTouristDTO[i].Nationality = GetNationalityName(oBookingTouristDTO[i].NationalityId); oBookingTouristDTO[i].CFormNo = dr.ItemArray.GetValue(37) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(37)) : 0; oBookingTouristDTO[i].EmailId = dr.ItemArray.GetValue(38) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(38)) : ""; oBookingTouristDTO[i].arrivalvehiaclno = dr.ItemArray.GetValue(40) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(40)) : ""; oBookingTouristDTO[i].departurevehicalno = dr.ItemArray.GetValue(41) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(41)) : ""; oBookingTouristDTO[i].departureairport = dr.ItemArray.GetValue(42) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(42)) : ""; oBookingTouristDTO[i].arrivalairport = dr.ItemArray.GetValue(43) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(43)) : ""; } #endregion AssigningValues } } return(oBookingTouristDTO); }
public bool InsertTouristentry(BookingTouristDTO oBookingTouristDTO, out int TouristNo) { return(bookingTouristentry(oBookingTouristDTO, Action.insert, out TouristNo)); }
public BookingTouristDTO[] GetTourists(int BookingId) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; string sProcName; oBookingTouristDTO = null; try { oDB = new DatabaseManager(); sProcName = "up_Get_Tourists"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; GF.LogError("clsBookingTouristHandler.GetTourist", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].BookingId = Convert.ToInt32(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].BookingCode = Convert.ToString(dr.ItemArray.GetValue(1)); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(2)); } if (dr.ItemArray.GetValue(3) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))); } if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].MiddleName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(4))); } if (dr.ItemArray.GetValue(5) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))); } if (dr.ItemArray.GetValue(6) != DBNull.Value) { oBookingTouristDTO[i].RoomDetails = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(6))); } if (dr.ItemArray.GetValue(7) != DBNull.Value) { oBookingTouristDTO[i].Gender = (Convert.ToChar(dr.ItemArray.GetValue(7))); } if (dr.ItemArray.GetValue(8) != DBNull.Value) { oBookingTouristDTO[i].DateOfBirth = Convert.ToDateTime(Convert.ToDateTime(dr.ItemArray.GetValue(8)).ToString()); } if (dr.ItemArray.GetValue(9) != DBNull.Value) { oBookingTouristDTO[i].Nationality = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(9))); } if (dr.ItemArray.GetValue(10) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(10))); } if (dr.ItemArray.GetValue(11) != DBNull.Value) { oBookingTouristDTO[i].VisaExpiryDate = Convert.ToDateTime(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != DBNull.Value) { oBookingTouristDTO[i].ArrivalDateTime = Convert.ToDateTime(dr.ItemArray.GetValue(12)); } if (dr.ItemArray.GetValue(13) != DBNull.Value) { oBookingTouristDTO[i].vehicalno = Convert.ToString(dr.ItemArray.GetValue(13)); } if (dr.ItemArray.GetValue(14) != DBNull.Value) { oBookingTouristDTO[i].departuredate = Convert.ToDateTime(dr.ItemArray.GetValue(14)); } if (dr.ItemArray.GetValue(15) != DBNull.Value) { oBookingTouristDTO[i].departureairport = Convert.ToString(dr.ItemArray.GetValue(15)); } if (dr.ItemArray.GetValue(16) != DBNull.Value) { oBookingTouristDTO[i].guestname = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(16))) + ". " + DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))) + " " + DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))); } if (dr.ItemArray.GetValue(17) != DBNull.Value) { oBookingTouristDTO[i].arrivalvehiaclno = Convert.ToString(dr.ItemArray.GetValue(17)); } if (dr.ItemArray.GetValue(18) != DBNull.Value) { oBookingTouristDTO[i].departurevehicalno = Convert.ToString(dr.ItemArray.GetValue(18)); } if (dr.ItemArray.GetValue(20) != DBNull.Value) { oBookingTouristDTO[i].arrivalairport = Convert.ToString(dr.ItemArray.GetValue(20)); } } } } return(oBookingTouristDTO); }
public bool InsertTouristDetails(BookingTouristDTO oBookingTouristDTO, out int TouristNo) { return(SaveData(oBookingTouristDTO, Action.insert, out TouristNo)); }