protected void GetRequest()
{
BookingRequesttbl br = new BookingRequesttbl();
br.RequestId = Convert.ToInt32(Session["RequestId"]);
GetRequestByID(br.RequestId);
btnSubmit.Visible = false;
btnUpdate.Visible = true;
}
protected void BookingDetails()
{
BookingRequesttbl brt = new BookingRequesttbl();
List <BookingRequesttbl> lstbr = new List <BookingRequesttbl>();
brt.RequestId = Convert.ToInt32(Session["RequestId"]);
lstbr = objReBL.GetBookingRequestbyId(brt).ToList();
foreach (var el in lstbr)
{
lblDest.Text = el.Destination;
//lblIn.Text = el.Nationality;
Countrytbl cn = new Countrytbl();
cn.CountryID = Convert.ToInt32(el.Nationality);
var cval = objCountryBL.GetCountryById(cn);
lblIn.Text = cval.First().CountryName;
lblHName.Text = el.PreferedHotels;
txtCheckInDate.Text = Convert.ToDateTime(el.Checkin).ToShortDateString();
txtCheckOutDate.Text = Convert.ToDateTime(el.Checkout).ToShortDateString();
GetRequestByID(brt.RequestId);
}
}
protected void InsertBookingRequest()
{
BookingRequesttbl Br = new BookingRequesttbl();
List <BookingReqGuestDetailstbl> lstbd = new List <BookingReqGuestDetailstbl>();
Br.AgentId = ddlAgency.SelectedValue == "" ? 0 : Convert.ToInt32(ddlAgency.SelectedValue);
Br.Destination = txtDest.Text;
Br.Checkin = Convert.ToDateTime(txtCheckInDate.Text).ToString("yyyy-MM-dd HH:mm:ss");
Br.Checkout = Convert.ToDateTime(txtCheckOutDate.Text).ToString("yyyy-MM-dd HH:mm:ss");
Br.Nationality = ddlNationality.SelectedValue;
Br.MobileNumber = 123;
Br.EmailID = "*****@*****.**";
Br.PreferedHotels = txtPH.Text;
Br.SightSeeing = ddlSightSeeing.SelectedValue;
Br.IsActive = 1;
Br.CreatedBy = 1;
Br.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (Convert.ToInt32(ddlAdult.SelectedValue) >= 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.Salutation = ddlAdultSalutation1.SelectedItem.Text;
brg.FirstName = txtAdultFN1.Text;
brg.LastName = txtAdultLN1.Text;
brg.Type = "A";
brg.Status = 1;
brg.CreatedBy = 1;
brg.RoomNo = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlAdult.SelectedValue) > 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.Salutation = ddlAdultSalutation2.SelectedItem.Text;
brg.FirstName = txtAdultFN2.Text;
brg.LastName = txtAdultLN2.Text;
brg.Type = "A";
brg.Status = 1;
brg.RoomNo = 1;
brg.CreatedBy = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlChild.SelectedValue) >= 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.Age = ddlChildAge1.SelectedValue;
brg.FirstName = txtChildFName1.Text;
brg.LastName = txtChildLName1.Text;
brg.Type = "K";
brg.Status = 1;
brg.CreatedBy = 1;
brg.RoomNo = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlChild.SelectedValue) > 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.Age = ddlChildAge2.SelectedValue;
brg.FirstName = txtChildFName2.Text;
brg.LastName = txtChildLName2.Text;
brg.Type = "K";
brg.Status = 1;
brg.RoomNo = 1;
brg.CreatedBy = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
//TextBox txtAlt = Master.FindControl("AdminPlaceHolder").FindControl("txtAdultFN11") as TextBox;
//DropDownList d = (DropDownList)FindControl("AdminPlaceHolder_ddlSal11");
//string message = "";
//foreach (TextBox textBox in ctrlPlaceholder.Controls.OfType<TextBox>())
//{
// message += textBox.ID + ": " + textBox.Text + "\\n";
//}
//ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('" + message + "');", true);
//for (int i = 0; i< Convert.ToInt32(ddlAdult.SelectedValue); i++)
//{
// BookingReqGuestDetailstbl BdA = new BookingReqGuestDetailstbl();
// string ddl = i == 0 ? "AdminPlaceHolder_ddlAdult1" + 1 : "AdminPlaceHolder_ddlAdult1" + i + 1;
// DropDownList ddlas = (DropDownList)ctrlPlaceholder.FindControl("ddlAdult11");
// TextBox txtaf = (TextBox)ctrlPlaceholder.FindControl("txtAdultFN1" + i + 1);
// TextBox txtal = (TextBox)ctrlPlaceholder.FindControl("txtAdultLN1" + i + 1);
// BdA.RoomNo = 1;
// BdA.Salutation = "Mr";
// BdA.FirstName = "Ravi";
// BdA.LastName = "Kumar";
// BdA.Age = "20";
// BdA.Type = "A";
// BdA.Status = 1;
// BdA.CreatedBy = 1;
// BdA.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// lstbd.Add(BdA);
// //BdA.RoomNo = 1;
// //BdA.Salutation = ddlas.SelectedValue;
// //BdA.FirstName = txtaf.Text;
// //BdA.LastName = txtal.Text;
// //BdA.Type = "A";
// //BdA.Status = 1;
// //BdA.CreatedBy = 1;
// //BdA.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// //lstbd.Add(BdA);
//}
//for (int j = 0; j < Convert.ToInt32(ddlChild.SelectedValue); j++)
//{
// BookingReqGuestDetailstbl BdC = new BookingReqGuestDetailstbl();
// DropDownList ddlca = (DropDownList)ctrlPlaceholder.FindControl("ddlChild1" + j + 1);
// TextBox txtcf = (TextBox)ctrlPlaceholder.FindControl("txtChildFN1" + j + 1);
// TextBox txtcl = (TextBox)ctrlPlaceholder.FindControl("txtChildLN1" + j + 1);
// BdC.RoomNo = 1;
// BdC.FirstName = txtcf.Text;
// BdC.LastName = txtcl.Text;
// BdC.Age = ddlca.SelectedValue;
// BdC.Type = "K";
// BdC.Status = 1;
// BdC.CreatedBy = 1;
// BdC.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// lstbd.Add(BdC);
//}
//Br.GuestDetails = lstbd;
//Bd.RoomNo = 1;
//Bd.Salutation = "Mr";
//Bd.FirstName = "Ravi";
//Bd.LastName = "Kumar";
//Bd.Age = "20";
//Bd.Type = "A";
//Bd.Status = 1;
//Bd.CreatedBy = 1;
//Bd.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Br.GuestDetails = lstbd;
List <BookingRequesttbl> lstbrd = new List <BookingRequesttbl>();
lstbrd = objBookReqBL.InsertRequest(Br).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Data Inserted Successfully');", true);
btnSubmit.Visible = true;
Response.Redirect("OfflineRequests.aspx");
}
public IEnumerable <BookingRequesttbl> GetBookingRequestByStatus(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(8, br));
}
public IEnumerable <BookingRequesttbl> UpdateBookingRequestStatus(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(7, br));
}
public IEnumerable <BookingRequesttbl> UpdateBookingRequestIsActive(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(6, br));
}
public IEnumerable <BookingRequesttbl> DeleteBookingRequest(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(5, br));
}
public IEnumerable <BookingRequesttbl> UpdateBookingRequest(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequestUpdate(4, br));
}
public IEnumerable <BookingRequesttbl> InsertBookingRequest(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(3, br));
}
public IEnumerable <BookingRequesttbl> GetBookingRequestbyId(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(2, br));
}
public IEnumerable <BookingRequesttbl> GetAllBookingRequest(BookingRequesttbl br)
{
return(objBookReqDA.BookingRequest(1, br));
}
protected void GetRequestByID(int RequestId)
{
BookingRequesttbl br = new BookingRequesttbl();
List <BookingRequesttbl> lbr = new List <BookingRequesttbl>();
br.RequestId = RequestId;
lbr = objBookReqBL.GetBookingRequestbyId(br).ToList();
List <BookingReqGuestDetailstbl> lstbd = new List <BookingReqGuestDetailstbl>();
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
foreach (var el in lbr)
{
hdnRequestId.Value = el.RequestId.ToString();
ddlAgency.SelectedValue = el.AgentId.ToString();
txtDest.Text = el.Destination;
ddlNationality.SelectedValue = el.Nationality;
txtCheckInDate.Text = Convert.ToDateTime(el.Checkin).ToShortDateString();
txtCheckOutDate.Text = Convert.ToDateTime(el.Checkout).ToShortDateString();
//Countrytbl cn = new Countrytbl();
//cn.CountryID = Convert.ToInt32(el.CountryId);
//var cval = objcountryBL.GetCountryById(cn);
//ddlNationality.SelectedValue = el.Nationality;
txtPrH.Text = el.PreferedHotels;
ddlSightSeeing.SelectedValue = el.SightSeeing.ToString();
int a = 0, k = 0;
for (int i = 0; i < el.GuestDetails.Count(); i++)
{
if (el.GuestDetails[i].Type == "A" && i == 0)
{
hdnAdultGuestId1.Value = el.GuestDetails[i].GuestId.ToString();
txtAdultFN1.Text = el.GuestDetails[i].FirstName;
txtAdultLN1.Text = el.GuestDetails[i].LastName;
ddlAdultSalutation1.SelectedValue = el.GuestDetails[i].Salutation;
a++;
}
if (el.GuestDetails[i].Type == "A" && i == 1)
{
hdnAdultGuestId2.Value = el.GuestDetails[i].GuestId.ToString();
txtAdultFN2.Text = el.GuestDetails[i].FirstName;
txtAdultLN2.Text = el.GuestDetails[i].LastName;
ddlAdultSalutation2.SelectedValue = el.GuestDetails[i].Salutation;
a++;
}
if (el.GuestDetails[i].Type == "K" && (i == 1 || i == 2))
{
hdnChildGuestId1.Value = el.GuestDetails[i].GuestId.ToString();
txtChildFName1.Text = el.GuestDetails[i].FirstName;
txtChildLName1.Text = el.GuestDetails[i].LastName;
ddlChildAge1.SelectedValue = el.GuestDetails[i].Age;
k++;
}
if (el.GuestDetails[i].Type == "K" && i == 3)
{
hdnChildGuestId2.Value = el.GuestDetails[i].GuestId.ToString();
txtChildFName2.Text = el.GuestDetails[i].FirstName;
txtChildLName2.Text = el.GuestDetails[i].LastName;
ddlChildAge2.SelectedValue = el.GuestDetails[i].Age;
k++;
}
}
ddlAdult.SelectedValue = a.ToString();
ddlChild.SelectedValue = k.ToString();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
BookingRequesttbl Br = new BookingRequesttbl();
Br.RequestId = Convert.ToInt32(hdnRequestId.Value);
Br.AgentId = Convert.ToInt32(ddlAgency.SelectedValue);
Br.Destination = txtDest.Text;
Br.Checkin = Convert.ToDateTime(txtCheckInDate.Text).ToString("yyyy-MM-dd");
Br.Checkout = Convert.ToDateTime(txtCheckInDate.Text).ToString("yyyy-MM-dd");
Br.Nationality = ddlNationality.SelectedValue;
Br.PreferedHotels = txtPrH.Text;
Br.SightSeeing = ddlSightSeeing.SelectedValue;
List <BookingRequesttbl> brl = new List <BookingRequesttbl>();
// List<BookingRequesttbl> lbr = new List<BookingRequesttbl>();
List <BookingReqGuestDetailstbl> lstbd = new List <BookingReqGuestDetailstbl>();
// BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
if (Convert.ToInt32(ddlAdult.SelectedValue) >= 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.GuestId = Convert.ToInt32(hdnAdultGuestId1.Value);
brg.RequestId = Convert.ToInt32(hdnRequestId.Value);
brg.Salutation = ddlAdultSalutation1.SelectedItem.Text;
brg.FirstName = txtAdultFN1.Text;
brg.LastName = txtAdultLN1.Text;
brg.Type = "A";
brg.Status = 1;
brg.CreatedBy = 1;
brg.RoomNo = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlAdult.SelectedValue) > 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.GuestId = Convert.ToInt32(hdnAdultGuestId2.Value);
brg.RequestId = Convert.ToInt32(hdnRequestId.Value);
brg.Salutation = ddlAdultSalutation2.SelectedItem.Text;
brg.FirstName = txtAdultFN2.Text;
brg.LastName = txtAdultLN2.Text;
brg.Type = "A";
brg.Status = 1;
brg.RoomNo = 1;
brg.CreatedBy = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlChild.SelectedValue) >= 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.GuestId = Convert.ToInt32(hdnChildGuestId1.Value);
brg.RequestId = Convert.ToInt32(hdnRequestId.Value);
brg.Age = ddlChildAge1.SelectedValue;
brg.FirstName = txtChildFName1.Text;
brg.LastName = txtChildLName1.Text;
brg.Type = "K";
brg.Status = 1;
brg.CreatedBy = 1;
brg.RoomNo = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
if (Convert.ToInt32(ddlChild.SelectedValue) > 1)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg.GuestId = Convert.ToInt32(hdnChildGuestId2.Value);
brg.RequestId = Convert.ToInt32(hdnRequestId.Value);
brg.Age = ddlChildAge2.SelectedValue;
brg.FirstName = txtChildFName2.Text;
brg.LastName = txtChildLName2.Text;
brg.Type = "K";
brg.Status = 1;
brg.RoomNo = 1;
brg.CreatedBy = 1;
brg.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
lstbd.Add(brg);
}
//brl = objBookReqBL.UpdateBookingRequest(Br).ToList();
Br.GuestDetails = lstbd;
brl = objBookReqBL.UpdateBookingRequest(Br).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Booking Request Updated Successfully');", true);
//Reset();
btnUpdate.Visible = false;
btnSubmit.Visible = true;
}
