protected void Page_Load(object sender, EventArgs e)
{
docid = int.Parse(Page.Request.QueryString["key"].ToString());
if (!IsPostBack)
{
SupplierCarPriceStoredProcedure objinsercardoc = new SupplierCarPriceStoredProcedure();
DataSet ds = objinsercardoc.getCarPriceDocument(docid);
cardoc.HRef = "~/SupplierCarDocument/" + docid + "/" + ds.Tables[0].Rows[0]["UPLOAD_RATE_DOCUMENT"].ToString();
}
}
public void CopyData(int Supplierid)
{
SupplierCarPriceStoredProcedure objcarprice = new SupplierCarPriceStoredProcedure();
//System.IO.File.Copy
System.Data.DataSet ds = objcarprice.CopyData(Supplierid);
// string N_TOUR_ID = ds.Tables[0].Rows[0]["TOUR_ID"].ToString();
}
public void InsertUpdateCarPrice(ArrayList CarPrice)
{
SupplierCarPriceStoredProcedure objinsertcar = new SupplierCarPriceStoredProcedure();
CarPrice.Insert(20, Session["usersid"].ToString());
objinsertcar.InsertUpdateCarPrice(CarPrice);
//System.Data.DataSet ds1 = objinsertcar.CheckValidation();
//int j = 0;
//int k = 0;
//int l = 0;
//int n = 0;
//int p = 0;
//int q = 0;
//int r = 0;
//for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
//{
// if (ds1.Tables[0].Rows[i]["CURRENCY_NAME"].ToString().Equals(CarPrice[12]) || CarPrice[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(CarPrice[5]) || CarPrice[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(CarPrice[13]) || CarPrice[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(CarPrice[4]) || CarPrice[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(CarPrice[18]) || CarPrice[18].Equals(""))
// {
// p = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[17].Rows.Count; i++)
//{
// if (ds1.Tables[17].Rows[i]["CAR_NAME"].ToString().Equals(CarPrice[3]) || CarPrice[3].Equals(""))
// {
// q = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[18].Rows.Count; i++)
//{
// if (ds1.Tables[18].Rows[i]["RATE_UNIT_NAME"].ToString().Equals(CarPrice[19]) || CarPrice[19].Equals(""))
// {
// r = 1;
// break;
// }
//}
//if (j == 0)
//{
// s = "currency";
//}
//else if (j == 1 && k == 0)
//{
// s = "Car_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 && p == 0)
//{
// s = "City";
//}
//else if (j == 1 && k == 1 && l == 1 && n == 1 && p == 1 && q == 0)
//{
// s = "Car";
//}
//else if (j == 1 && k == 1 && l == 1 && n == 1 && p == 1 && q == 1 && r == 0)
//{
// s = "Rate_Unit";
//}
//else if (j == 1 && k == 1 && l == 1 && n == 1 && p == 1 && q == 1 && r == 1)
//{
// System.Data.DataSet ds=objinsertcar.InsertUpdateCarPrice(CarPrice);
// s = ds.Tables[0].Rows[0]["ABC"].ToString();
//}
//else
//{
//}
//return s;
}
public void delCarPrice(int Carpriceid)
{
SupplierCarPriceStoredProcedure objdelcarprice = new SupplierCarPriceStoredProcedure();
objdelcarprice.delCarPrice(Carpriceid);
}
