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);
}