protected void Page_Load(object sender, EventArgs e)
{
docid = int.Parse(Page.Request.QueryString["key"].ToString());
if (!IsPostBack)
{
SupplierRestaurantPriceStoredProcedure objinsertdoc = new SupplierRestaurantPriceStoredProcedure();
DataSet ds = objinsertdoc.getRestaurantPriceDocument(docid);
restaurantdoc.HRef = "~/SupplierRestaurantDocument/" + docid + "/" + ds.Tables[0].Rows[0]["UPLOAD_RATE_DOCUMENT"].ToString();
}
}
public void CopyData(int Supplierid)
{
SupplierRestaurantPriceStoredProcedure objrestuprice = new SupplierRestaurantPriceStoredProcedure();
//System.IO.File.Copy
System.Data.DataSet ds = objrestuprice.CopyData(Supplierid);
// string N_TOUR_ID = ds.Tables[0].Rows[0]["TOUR_ID"].ToString();
}
public void InsertUpdateRestaurantPrice(ArrayList RestaurantPrice)
{
SupplierRestaurantPriceStoredProcedure objinsertpricelist = new SupplierRestaurantPriceStoredProcedure();
RestaurantPrice.Insert(32, Session["usersid"].ToString());
objinsertpricelist.InsertUpdateRestaurantPrice(RestaurantPrice);
//System.Data.DataSet ds1 = objinsertpricelist.CheckValidation();
//int j = 0;
//int k = 0;
//int l = 0;
//int n = 0;
//int p = 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(RestaurantPrice[15]) || RestaurantPrice[15].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(RestaurantPrice[18]) || RestaurantPrice[18].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(RestaurantPrice[16]) || RestaurantPrice[16].Equals(""))
// {
// l = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[4].Rows.Count; i++)
//{
// if (ds1.Tables[4].Rows[i]["AGENT"].ToString().Equals(RestaurantPrice[17]) || RestaurantPrice[17].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(RestaurantPrice[22]) || RestaurantPrice[22].Equals(""))
// {
// p = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[9].Rows.Count; i++)
//{
// if (ds1.Tables[9].Rows[i]["MEAL_TYPE"].ToString().Equals(RestaurantPrice[21]) || RestaurantPrice[21].Equals(""))
// {
// q = 1;
// break;
// }
//}
//if (j == 0)
//{
// s = "currency";
//}
//else if (j == 1 && k == 0)
//{
// s = "Restaurant";
//}
//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 = "MealType";
//}
//else if (j == 1 && k == 1 && l == 1 && n == 1 && p == 1 && q == 1)
//{
// System.Data.DataSet ds = objinsertpricelist.InsertUpdateRestaurantPrice(RestaurantPrice);
// s = ds.Tables[0].Rows[0]["ABC"].ToString();
//}
//else
//{
//}
//return s;
}
public void delRestaurantPrice(int delprice)
{
SupplierRestaurantPriceStoredProcedure objdelprice = new SupplierRestaurantPriceStoredProcedure();
objdelprice.delRestaurantPrice(delprice);
}