public void InsertUpdateHotelPrice(ArrayList HotelPrice) { SupplierHotelPriceStoredProcedure objinserthotelprice = new SupplierHotelPriceStoredProcedure(); HotelPrice.Insert(27, Session["usersid"].ToString()); objinserthotelprice.InsertUpdateHotelPrice(HotelPrice); //System.Data.DataSet ds1 = objinserthotelprice.CheckValidation(); //return s; //int j = 0; //int k = 0; //int l = 0; //int m = 0; //int n = 0; //int O = 0; //int p= 0; //for (int i=0; i < ds1.Tables[0].Rows.Count;i++ ) //{ // if (ds1.Tables[0].Rows[i]["CURRENCY_NAME"].ToString().Equals(HotelPrice[7]) || HotelPrice[7].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(HotelPrice[9]) || HotelPrice[9].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(HotelPrice[8]) || HotelPrice[8].Equals("")) // { // l = 1; // break; // } //} //for (int i = 0; i < ds1.Tables[3].Rows.Count; i++) //{ // if (ds1.Tables[3].Rows[i]["STATUS"].ToString().Equals(HotelPrice[19]) || HotelPrice[19].Equals("")) // { // m = 1; // break; // } //} //for (int i = 0; i < ds1.Tables[4].Rows.Count; i++) //{ // if (ds1.Tables[4].Rows[i]["AGENT"].ToString().Equals(HotelPrice[10]) || HotelPrice[10].Equals("")) // { // n = 1; // break; // } //} //for (int i = 0; i < ds1.Tables[5].Rows.Count; i++) //{ // if (ds1.Tables[5].Rows[i]["ROOM_TYPE_NAME"].ToString().Equals(HotelPrice[1]) || HotelPrice[1].Equals("")) // { // O= 1; // break; // } //} //for (int i = 0; i < ds1.Tables[6].Rows.Count; i++) //{ // if (ds1.Tables[6].Rows[i]["TF_TYPE"].ToString().Equals(HotelPrice[16]) || HotelPrice[16].Equals("")) // { // p = 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 && m == 0) //{ // s= "status"; //} //else if (j == 1 && k == 1 && l == 1 && m == 1 && n==0) //{ // s = "agent"; //} //else if (j == 1 && k == 1 && l == 1 && m == 1 && n == 1 && O==0) //{ // s = "Room"; //} //else if (j == 1 && k == 1 && l == 1 && m == 1 && n == 1 && O == 1 && p==0) //{ // s = "IsQuote"; //} //else if (j == 1 && k == 1 && l == 1 && m == 1 && n == 1 && O==1 && p==1) //{ // System.Data.DataSet ds = objinserthotelprice.InsertUpdateHotelPrice(HotelPrice); // s = ds.Tables[0].Rows[0]["ABC"].ToString(); //} //else //{ //} //return s; }
public void InsertUpdateHotelRoomInventory(ArrayList RoomInventory) { SupplierHotelPriceStoredProcedure objinserthotelRoomInventory = new SupplierHotelPriceStoredProcedure(); objinserthotelRoomInventory.InsertUpdateHotelRoomInventory(RoomInventory); }
public void CopyData(int Supplierid) { SupplierHotelPriceStoredProcedure objempentity = new SupplierHotelPriceStoredProcedure(); System.Data.DataSet ds = objempentity.CopyData(Supplierid); }
public void delHotelPrice(int delHotel) { SupplierHotelPriceStoredProcedure objdelHotelPrice = new SupplierHotelPriceStoredProcedure(); objdelHotelPrice.delHotelPrice(delHotel); }