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