protected void Page_Load(object sender, EventArgs e) { docid = int.Parse(Page.Request.QueryString["key"].ToString()); if (!IsPostBack) { SupplierGuidePriceStoredProcedure objinsertdoc = new SupplierGuidePriceStoredProcedure(); DataSet ds = objinsertdoc.getGuidePriceDocument(docid); guidedoc.HRef = "~/SupplierGuideDocument/" + docid + "/" + ds.Tables[0].Rows[0]["UPLOAD_RATE_DOCUMENT"].ToString(); } }
public void CopyData(int Supplierid) { SupplierGuidePriceStoredProcedure objguidecopy = new SupplierGuidePriceStoredProcedure(); System.Data.DataSet ds = objguidecopy.CopyData(Supplierid); // string N_TOUR_ID = ds.Tables[0].Rows[0]["TOUR_ID"].ToString(); }
public string InsertUpdateGuidePrice(ArrayList GuidePrice,string s) { SupplierGuidePriceStoredProcedure objinsertguideprice = new SupplierGuidePriceStoredProcedure(); GuidePrice.Insert(17, Session["usersid"].ToString()); System.Data.DataSet ds1 = objinsertguideprice.CheckValidation(); int j = 0; int k = 0; int l = 0; int n = 0; int q = 0; for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { if (ds1.Tables[0].Rows[i]["CURRENCY_NAME"].ToString().Equals(GuidePrice[12]) || GuidePrice[12].Equals("")) { j = 1; break; } } for (int i = 0; i < ds1.Tables[1].Rows.Count; i++) { if (ds1.Tables[1].Rows[i]["CHAIN_NAME"].ToString().Equals(GuidePrice[5]) || GuidePrice[5].Equals("")) { k = 1; break; } } for (int i = 0; i < ds1.Tables[2].Rows.Count; i++) { if (ds1.Tables[2].Rows[i]["PAYMENT_TERMS"].ToString().Equals(GuidePrice[13]) || GuidePrice[13].Equals("")) { l = 1; break; } } for (int i = 0; i < ds1.Tables[4].Rows.Count; i++) { if (ds1.Tables[4].Rows[i]["AGENT"].ToString().Equals(GuidePrice[4]) || GuidePrice[4].Equals("")) { n = 1; break; } } for (int i = 0; i < ds1.Tables[8].Rows.Count; i++) { if (ds1.Tables[8].Rows[i]["CITY_NAME"].ToString().Equals(GuidePrice[14]) || GuidePrice[14].Equals("")) { q = 1; break; } } if (j == 0) { s = "currency"; } else if (j == 1 && k == 0) { s = "Guide_Company"; } else if (j == 1 && k == 1 && l == 0) { s = "Payment"; } else if (j == 1 && k == 1 && l == 1 && n == 0) { s = "agent"; } else if (j == 1 && k == 1 && l == 1 && n == 1 && q == 0) { s = "City"; } else if (j == 1 && k == 1 && l == 1 && n == 1 && q == 1) { System.Data.DataSet ds = objinsertguideprice.InsertUpdateGuidePrice(GuidePrice); s = ds.Tables[0].Rows[0]["ABC"].ToString(); } else { } return s; }
public void delGuidePrice(int GuidePriceid) { SupplierGuidePriceStoredProcedure objdelguideprice = new SupplierGuidePriceStoredProcedure(); objdelguideprice.delGuidePrice(GuidePriceid); }