public void InsertUpdateTransferPackage(ArrayList TransferPackage)
{
TransferPackageStoredProcedure objinserttransfer = new TransferPackageStoredProcedure();
TransferPackage.Insert(19, Session["usersid"].ToString());
objinserttransfer.InsertUpdateTransferPackage(TransferPackage);
//System.Data.DataSet ds1 = objinserttransfer.CheckValidation();
//int j = 0;
//int k = 0;
//int l = 0;
//int m = 0;
//int n = 0;
//int O = 0;
//for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
//{
// if (ds1.Tables[0].Rows[i]["CURRENCY_NAME"].ToString().Equals(TransferPackage[6]) || TransferPackage[6].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(TransferPackage[10]) || TransferPackage[10].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(TransferPackage[7]) || TransferPackage[7].Equals(""))
// {
// l = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[3].Rows.Count; i++)
//{
// if (ds1.Tables[3].Rows[i]["STATUS"].ToString().Equals(TransferPackage[11]) || TransferPackage[11].Equals(""))
// {
// m = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[4].Rows.Count; i++)
//{
// if (ds1.Tables[4].Rows[i]["AGENT"].ToString().Equals(TransferPackage[8]) || TransferPackage[8].Equals(""))
// {
// n = 1;
// break;
// }
//}
//for (int i = 0; i < ds1.Tables[7].Rows.Count; i++)
//{
// if (ds1.Tables[7].Rows[i]["FIT_PACKAGE_NAME"].ToString().Equals(TransferPackage[9]) || TransferPackage[9].Equals(""))
// {
// O = 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 = "Package";
//}
//else if (j == 1 && k == 1 && l == 1 && m == 1 && n == 1 && O == 1)
//{
// System.Data.DataSet ds = objinserttransfer.InsertUpdateTransferPackage(TransferPackage);
// s = ds.Tables[0].Rows[0]["ABC"].ToString();
//}
//else
//{
//}
//return s;
}
public void InsertNewTransferDetail(string TRANSFER_PACKAGE_PRICE_ID)
{
TransferPackageStoredProcedure objinsertnewdetail = new TransferPackageStoredProcedure();
objinsertnewdetail.InsertNewTransferDetail(TRANSFER_PACKAGE_PRICE_ID);
}
public void CopyData(int transid)
{
TransferPackageStoredProcedure objempentity = new TransferPackageStoredProcedure();
System.Data.DataSet ds = objempentity.CopyData(transid);
}
public string InsertUpdateTransferPackagedetail(ArrayList detail,string d)
{
CRM.DataAccess.AdministratorEntity.TransferPackageStoredProcedure objinserttransferdetail = new CRM.DataAccess.AdministratorEntity.TransferPackageStoredProcedure();
System.Data.DataSet ds2 = objinserttransferdetail.CheckValidation();
int j = 0;
int k = 0;
int l = 0;
int m = 0;
for (int i = 0; i < ds2.Tables[13].Rows.Count; i++)
{
if (ds2.Tables[13].Rows[i]["TRANSFER_PACKAGE_FROM_TO_NAME"].ToString().Equals(detail[1]) || detail[1].Equals(""))
{
j = 1;
break;
}
}
for (int i = 0; i < ds2.Tables[13].Rows.Count; i++)
{
if (ds2.Tables[13].Rows[i]["TRANSFER_PACKAGE_FROM_TO_NAME"].ToString().Equals(detail[2]) || detail[2].Equals(""))
{
k = 1;
break;
}
}
for (int i = 0; i < ds2.Tables[15].Rows.Count; i++)
{
if (ds2.Tables[15].Rows[i]["SIGHT_SEEING_PACKAGE_NAME"].ToString().Equals(detail[3]) || detail[3].Equals(""))
{
l = 1;
break;
}
}
for (int i = 0; i < ds2.Tables[14].Rows.Count; i++)
{
if (ds2.Tables[14].Rows[i]["ARRIVAL_DEPARTURE_TYPE"].ToString().Equals(detail[4]) || detail[4].Equals(""))
{
m = 1;
break;
}
}
if (j == 0)
{
d = "From_Place";
}
else if (j == 1 && k == 0)
{
d = "To_Place";
}
else if (j == 1 && k == 1 && l == 0)
{
d = "Sight_Package";
}
else if (j == 1 && k == 1 && l == 1 && m == 0)
{
d = "flag";
}
else if (j == 1 && k == 1 && l == 1 && m == 1)
{
objinserttransferdetail.InsertUpdateTransferDetail(detail);
}
else
{
}
return d;
}
public void delTransferPackage(int deltransferpackageid)
{
TransferPackageStoredProcedure objdeltransfer = new TransferPackageStoredProcedure();
objdeltransfer.delTransferPackage(deltransferpackageid);
}