public void InsertNewHotel(string Tour_Id) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.InsertNewHotel(Tour_Id); }
public void AssignStartEndCity(int TourId, string AssignStartEndCity) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.AssignStartEndCity(TourId, AssignStartEndCity); }
public void InsertUpdateDeck(ArrayList ary) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.InsertUpdateDeckDetail(ary); }
public void AssignCountry(int TourId, string Country) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.AssignCountry(TourId, Country); }
public void AssignCITY(int TourId, string AssignCITY) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.AssignCITY(TourId, AssignCITY); }
public void AssignStartEndCity(int TourId, ArrayList STARTENDCITY) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.AssignCountry(TourId, STARTENDCITY.ToString()); }
public void CopyData(int TourId) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); //System.IO.File.Copy System.Data.DataSet ds = objempentity.CopyData(TourId); string N_TOUR_ID = ds.Tables[0].Rows[0]["TOUR_ID"].ToString(); if (!System.IO.Directory.Exists(Server.MapPath("~/marketingdocuments/" + N_TOUR_ID.ToString() + "/"))) System.IO.Directory.CreateDirectory(Server.MapPath("~/marketingdocuments/" + N_TOUR_ID.ToString() + "/")); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { //System.IO.File.Copy(Server.MapPath("~/marketingdocuments/" + TourId.ToString() + ds.Tables[0].Rows[i]["DESCRIPTION"].ToString()), Server.MapPath("~/marketingdocuments/" + ds.Tables[0].Rows[i]["ATTACHMENT"].ToString())); System.IO.File.Copy(Server.MapPath("~/marketingdocuments/" + TourId.ToString() + "/" + TourId.ToString() + ds.Tables[0].Rows[i]["DESCRIPTION"].ToString()), Server.MapPath("~/marketingdocuments/" + N_TOUR_ID.ToString() + "/" + ds.Tables[0].Rows[i]["ATTACHMENT"].ToString())); } catch (Exception ex) { } } }
public void InsertUpdateCruise(ArrayList arr) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); arr.Insert(15, Session["empid"].ToString()); objempentity.InsertUpdateTourCruiseDetail(arr); }
public void AssignCountry(int TourId, ArrayList Country) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.AssignCountry(TourId, Country.ToString()); }
public void InsertUpdateTransportDetails(ArrayList tTour) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.InsertUpdateTransportDetails(tTour); }
public void InsertUpdateHotelDetails(ArrayList tTour) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); tTour.Insert(33, Session["empid"].ToString()); objempentity.InsertUpdateHotelDetails(tTour); }
public void InsertUpdateTourQuote(ArrayList tTour) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); tTour.Insert(20, Session["usersid"].ToString()); objempentity.InsertUpdateTourQuote(tTour); }
public void DeleteTourByTourID(int TourID) { TourmasterStoreprocedures objempentity = new TourmasterStoreprocedures(); objempentity.deleteTour(TourID); }
protected void Page_Load(object sender, EventArgs e) { tourid = int.Parse(Page.Request.QueryString["key"].ToString()); if (!IsPostBack) { TourmasterStoreprocedures objtourentity = new TourmasterStoreprocedures(); DataSet ds = objtourentity.getdataforuploaddetails(tourid); allcountry.DataSource = ds.Tables[0]; allcountry.DataBind(); allcountry.DataTextField = "COUNTRY_NAME"; allcountry.DataValueField = "COUNTRY_ID"; allcitytravel.DataSource = ds.Tables[1]; allcitytravel.DataBind(); allcitytravel.DataTextField = "CITY_NAME"; allcitytravel.DataTextField = "CITY_ID"; allstartendcity.DataSource = ds.Tables[1]; allstartendcity.DataBind(); allstartendcity.DataTextField = "CITY_NAME"; allstartendcity.DataValueField = "CITY_ID"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { if (ds.Tables[2].Rows[0]["COUNTRIES_FOR_VISA_TEXT"].ToString().Contains(ds.Tables[0].Rows[i]["COUNTRY_NAME"].ToString().Trim())) { ListItem item = new ListItem(ds.Tables[0].Rows[i]["COUNTRY_NAME"].ToString()); Selectedcountry.Items.Add(item); } } catch (Exception ex) { } } for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { try { if (ds.Tables[3].Rows[0]["CITY_TEXT"].ToString().Contains(ds.Tables[1].Rows[i]["CITY_NAME"].ToString().Trim())) { ListItem item = new ListItem(ds.Tables[1].Rows[i]["CITY_NAME"].ToString()); SelectedTravel.Items.Add(item); } } catch (Exception ex) { } } for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { try { if (ds.Tables[4].Rows[0]["START_END_CITY_TEXT"].ToString().Contains(ds.Tables[1].Rows[i]["CITY_NAME"].ToString().Trim())) { ListItem item = new ListItem(ds.Tables[1].Rows[i]["CITY_NAME"].ToString()); Selectedcity.Items.Add(item); } } catch (Exception ex) { } } //set anchor to all document for (int j = 0; j < ds.Tables[5].Rows.Count; j++) { if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupfulldetail" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancfulldetail.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfulldetail.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupfulldetail") { ancfulldetail.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfulldetail.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupitenary" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancitenary.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkitenary.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupitenary") { ancitenary.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkitenary.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCharges" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anccharged.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcharges.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCharges") { anccharged.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcharges.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupComparision" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anccomparision.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcomparision.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupComparision") { anccomparision.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcomparision.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCondition" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anccondition.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcondition.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCondition") { anccondition.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcondition.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCost" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anccost.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcost.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupCost") { anccost.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkcost.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupDetails" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancdetails.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkdetails.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupDetails") { ancdetails.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkdetails.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupfinalItenary" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancfinalitenary.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfinalitenary.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupfinalItenary") { ancfinalitenary.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfinalitenary.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupGuidelines" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancguidline.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkguidelines.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupGuidelines") { ancguidline.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkguidelines.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupHighlights" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anchighlight.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkhighlights.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupHighlights") { anchighlight.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkhighlights.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupLimitations" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anclimitations.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chklimitations.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupLimitations") { anclimitations.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chklimitations.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupNotes" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancnotes.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chknotes.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupNotes") { ancnotes.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chknotes.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupSheet" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancsheet.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chksheet.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupSheet") { ancsheet.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chksheet.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupTerms" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancterms.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkterms.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupTerms") { ancterms.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkterms.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupTermsCondition" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { anctermsandcondition.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfinalcondition.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupTermsCondition") { anctermsandcondition.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkfinalcondition.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupUSP" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancusp.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkusp.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupUSP") { ancusp.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkusp.Checked = false; } if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupVouchures" && ds.Tables[5].Rows[j]["IS_DEFAULT_DOC"].ToString() == "1") { ancvoucheres.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkvouchures.Checked = true; } else if (ds.Tables[5].Rows[j]["TITLE"].ToString() == "flupVouchures") { ancvoucheres.HRef = "~/marketingdocuments/" + tourid + "/" + ds.Tables[5].Rows[j]["ATTACHMENT"].ToString(); chkvouchures.Checked = false; } } } }