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