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