public void CopyData(int Supplierid) { CRM.DataAccess.AdministratorEntity.SupplierCoachPriceStoredProcedure objcoachprice = new CRM.DataAccess.AdministratorEntity.SupplierCoachPriceStoredProcedure(); //System.IO.File.Copy System.Data.DataSet ds = objcoachprice.CopyData(Supplierid); // string N_TOUR_ID = ds.Tables[0].Rows[0]["TOUR_ID"].ToString(); }
public void InsertUpdateCoachPrice(ArrayList CoachPrice) { SupplierCoachPriceStoredProcedure objinsertcoachprice = new SupplierCoachPriceStoredProcedure(); CoachPrice.Insert(20, Session["usersid"].ToString()); objinsertcoachprice.InsertUpdateCoachPrice(CoachPrice); //System.Data.DataSet ds1 = objinsertcoachprice.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(CoachPrice[12]) || CoachPrice[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(CoachPrice[5]) || CoachPrice[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(CoachPrice[13]) || CoachPrice[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(CoachPrice[4]) || CoachPrice[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(CoachPrice[17]) || CoachPrice[17].Equals("")) // { // p = 1; // break; // } //} //for (int i = 0; i < ds1.Tables[19].Rows.Count; i++) //{ // if (ds1.Tables[19].Rows[i]["COACH_NAME"].ToString().Equals(CoachPrice[3]) || CoachPrice[3].Equals("")) // { // q = 1; // break; // } //} //if (j == 0) //{ // s = "currency"; //} //else if (j == 1 && k == 0) //{ // s = "Coach_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 = "Coach"; //} //else if (j == 1 && k == 1 && l == 1 && n == 1 && p == 1 && q == 1) //{ // System.Data.DataSet ds = objinsertcoachprice.InsertUpdateCoachPrice(CoachPrice); // s = ds.Tables[0].Rows[0]["ABC"].ToString(); //} //else //{ //} //return s; }
public void delCoachPrice(int Coachpriceeid) { CRM.DataAccess.AdministratorEntity.SupplierCoachPriceStoredProcedure objdelcoachprice = new CRM.DataAccess.AdministratorEntity.SupplierCoachPriceStoredProcedure(); objdelcoachprice.delCoachPrice(Coachpriceeid); }