public ZA3011LD DoLoadA(ZA3011D FilterData, String Mode)
{
ZA3011LD SaveDataV = new ZA3011LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
//new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_pack_deal_mast_id", FilterData.PackDealMastId),
new XElement("ai_deal_mast_id", FilterData.DealMastId),
new XElement("as_mode", Mode)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_SEL", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable DealcolDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 1);
if (UserDt.Rows.Count > 0)
{
SaveDataV.UserData = new ZA3000D()
{
//UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]),
FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["usr_FistNam"]),
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]),
},
};
}
foreach (DataRow dr in DealcolDt.Rows)
{
SaveDataV.Dealcol.Add(new ZA3011D()
{
DealMastId = PLWM.Utils.CnvToInt(dr["deal_mast_id"]),
PackDealMastId = PLWM.Utils.CnvToInt(dr["pack_deal_mast_id"]),
DealName = PLWM.Utils.CnvToStr(dr["deal_name"]),
Price = PLWM.Utils.CnvToStr(dr["price"]),
StartDt = PLWM.Utils.CnvToStr(dr["start_dt"]),
EndDt = PLWM.Utils.CnvToStr(dr["end_dt"]),
Descrptn = PLWM.Utils.CnvToStr(dr["descrptn"]),
});
}
}
catch (Exception e)
{
SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SaveDataV);
}
public ZA3011LD DoDelete(ZA3011D FilterData, String Mode)
{
ZA3011LD SaveDataV = new ZA3011LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_deal_mast_id", FilterData.DealMastId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_DEL", XString, PLABSM.DbProvider.MSSql);
}
catch (Exception e)
{
SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SaveDataV);
}
public ZA3011LD DoLoadBrand(ZA3011LD FilterData, String Mode)
{
ZA3011LD brandDet = new ZA3011LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_pack_deal_mast_id", FilterData.PackDealMast.PackDealMastID),
new XElement("ai_deal_mast_id", FilterData.PackDealMast.DealMastID),
//@ai_pageno
new XElement("ai_pageno", ""),
new XElement("as_mode", Mode)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_SEL", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable PackDealcolDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable DealcolDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 2);
foreach (DataRow dr in PackDealcolDt.Rows)
{
brandDet.PackDealMast = new ZA3010D()
{
PackDealMastID = PLWM.Utils.CnvToInt(dr["pack_deal_mast_id"]),
PlanMastId = PLWM.Utils.CnvToInt(dr["plan_mast_id"]),
PackageMastId = PLWM.Utils.CnvToInt(dr["package_mast_id"]),
PhoneNo = PLWM.Utils.CnvToStr(dr["Phone_No"]),
Email = PLWM.Utils.CnvToStr(dr["Email"]),
Website = PLWM.Utils.CnvToStr(dr["Website"]),
Location = PLWM.Utils.CnvToStr(dr["geo_Location"]),
Description = PLWM.Utils.CnvToStr(dr["descrptn"]),
BannerImage = PLWM.Utils.CnvToStr(dr["banner_img_url"]),
CompanyLogo = PLWM.Utils.CnvToStr(dr["logo_img_url"]),
};
}
foreach (DataRow dr in DealcolDt.Rows)
{
brandDet.Dealcol.Add(new ZA3011D()
{
DealMastId = PLWM.Utils.CnvToInt(dr["deal_mast_id"]),
PackDealMastId = PLWM.Utils.CnvToInt(dr["pack_deal_mast_id"]),
DealName = PLWM.Utils.CnvToStr(dr["deal_name"]),
Price = PLWM.Utils.CnvToStr(dr["price"]),
Descrptn = PLWM.Utils.CnvToStr(dr["descrptn"]),
Location = PLWM.Utils.CnvToStr(dr["geo_Location"]),
});
}
if (UserDt.Rows.Count > 0)
{
brandDet.UserData = new ZA3000D()
{
UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]),
FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["usr_FistNam"]),
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]),
},
};
}
}
catch (Exception e)
{
brandDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(brandDet);
}
