public ZA3641RPD DoLoad(ZA3641RPD FilterData, String Mode) { ZA3641RPD JobHirDet = new ZA3641RPD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("ai_com_job_mast_id", FilterData.ComJobMast.CompanyJobMastId), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3641RP_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable EmpJobColDt = PLWM.Utils.GetDataTable(ds, 1); foreach (DataRow dr in EmpJobColDt.Rows) { JobHirDet.ComJobMast = new ZA3640D() { CompanyJobMastId = PLWM.Utils.CnvToStr(dr["compny_job_mast_id"]), CompanyName = PLWM.Utils.CnvToStr(dr["compny_name"]), EmpType = PLWM.Utils.CnvToStr(dr["EmpTyp"]), Title = PLWM.Utils.CnvToStr(dr["job_title"]), Description = PLWM.Utils.CnvToStr(dr["Descr"]), Neighbr = PLWM.Utils.CnvToStr(dr["neighbrhd"]), MinWorkExp = PLWM.Utils.CnvToStr(dr["MinWorkExp"]), MinEduLvl = PLWM.Utils.CnvToStr(dr["MinEduLvl"]), ListedBy = PLWM.Utils.CnvToStr(dr["ListedBy"]), Compnysize = PLWM.Utils.CnvToStr(dr["CompnySize"]), CarierLvl = PLWM.Utils.CnvToStr(dr["CarierLvl"]), CurrentLoc = PLWM.Utils.CnvToStr(dr["location"]), CrtdDt = PLWM.Utils.CnvToStr(dr["crtd_dt"]), Phone = PLWM.Utils.CnvToStr(dr["ph_num"]), Email = PLWM.Utils.CnvToStr(dr["compny_websit"]), Proimg = PLWM.Utils.CnvToStr(dr["proimg"]), }; } if (UserDt.Rows.Count > 0) { JobHirDet.UserData = new ZA3000D() { UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]), FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), }, }; } //UserData } catch (Exception e) { JobHirDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(JobHirDet); }
public ZA3650LD DoLoad(ZA3650SD FilterData, String Mode) { ZA3650LD UsageD = new ZA3650LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("ai_compny_job_mast_id", FilterData.UserData.ZaBase.PKID), new XElement("as_mode", Mode) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3650_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable IndstryTypDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable CompnySizeDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable EmplymntTypeDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable MonthlySlryDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable ExprnceDt = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable EductnLvlDt = PLWM.Utils.GetDataTable(ds, 5); System.Data.DataTable ListedByDt = PLWM.Utils.GetDataTable(ds, 6); System.Data.DataTable CareerLvlDt = PLWM.Utils.GetDataTable(ds, 7); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 8); System.Data.DataTable dtSel = PLWM.Utils.GetDataTable(ds, 9); DataRow drUser = null; if (dtUser.Rows.Count > 0) { drUser = dtUser.Rows[0]; } UsageD.IndstryCol = new ZA3230DCol(); UsageD.IndstryCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Jobs" }); foreach (DataRow dr in IndstryTypDt.Rows) { UsageD.IndstryCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CompnySizeCol = new ZA3230DCol(); UsageD.CompnySizeCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Company Size" }); foreach (DataRow dr in CompnySizeDt.Rows) { UsageD.CompnySizeCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.EmploymntTypeCol = new ZA3230DCol(); UsageD.EmploymntTypeCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Commitment" }); foreach (DataRow dr in EmplymntTypeDt.Rows) { UsageD.EmploymntTypeCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.MonthlySalaryCol = new ZA3230DCol(); UsageD.MonthlySalaryCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Current Salary" }); foreach (DataRow dr in MonthlySlryDt.Rows) { UsageD.MonthlySalaryCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.ExprnceCol = new ZA3230DCol(); UsageD.ExprnceCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Work Experience" }); foreach (DataRow dr in ExprnceDt.Rows) { UsageD.ExprnceCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.EductnLevlCol = new ZA3230DCol(); UsageD.EductnLevlCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Education Level" }); foreach (DataRow dr in EductnLvlDt.Rows) { UsageD.EductnLevlCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.ListedBycol = new ZA3230DCol(); UsageD.ListedBycol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Listed By" }); foreach (DataRow dr in ListedByDt.Rows) { UsageD.ListedBycol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CareervLevelCol = new ZA3230DCol(); UsageD.CareervLevelCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Career Level" }); foreach (DataRow dr in CareerLvlDt.Rows) { UsageD.CareervLevelCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } if (drUser != null) { UsageD.UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]), UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; } foreach (DataRow dr in dtSel.Rows) { UsageD.FrelncMast = new ZA3650SD() { CompnyJobMastId = PLWM.Utils.CnvToInt(dr["compny_job_mast_id"]), CompnyName = PLWM.Utils.CnvToStr(dr["compny_name"]), TradeLicns = PLWM.Utils.CnvToStr(dr["trade_licns"]), ContctName = PLWM.Utils.CnvToStr(dr["contct_name"]), Phone = PLWM.Utils.CnvToStr(dr["ph_num"]), CompnyWebsit = PLWM.Utils.CnvToStr(dr["compny_websit"]), Addrs = PLWM.Utils.CnvToStr(dr["addrs"]), DescrpnStepOne = PLWM.Utils.CnvToStr(dr["descrpn_step_one"]), Indstry = UsageD.IndstryCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["indstry"])), CompnySize = UsageD.CompnySizeCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["compny_size"])), //StepTwo JobTitle = PLWM.Utils.CnvToStr(dr["job_title"]), Neighbrhd = PLWM.Utils.CnvToStr(dr["neighbrhd"]), Location = PLWM.Utils.CnvToStr(dr["location"]), DescrptnStepTwo = PLWM.Utils.CnvToStr(dr["descrptn_step_two"]), EmplymntTyp = UsageD.EmploymntTypeCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["emplymnt_typ"])), MonthlySalary = UsageD.MonthlySalaryCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["monthly_salary"])), Exprnce = UsageD.ExprnceCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["exprnce"])), EductnLvl = UsageD.EductnLevlCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["eductn_lvl"])), ListedBy = UsageD.ListedBycol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["listed_by"])), CareerLvl = UsageD.CareervLevelCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtSel.Rows[0]["career_lvl"])), }; } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3270LD DoLoad(ZA3270LD FilterData, String Mode) { ZA3270LD UsageD = new ZA3270LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_pageno", FilterData.PageNo), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("as_Option", ""), new XElement("as_location", ""), new XElement("as_sortby", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3270_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable MallcolDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 2); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } foreach (DataRow dr in MallcolDt.Rows) { UsageD.Mallcol.Add(new ZA3270D() { MallAdMastId = PLWM.Utils.CnvToStr(dr["mall_mast_id"]), MallName = PLWM.Utils.CnvToStr(dr["mall_name"]), MallLocation = PLWM.Utils.CnvToStr(dr["mall_location"]), MallStartTiming = PLWM.Utils.CnvToStr(dr["mall_start_timing"]), MallEndTiming = PLWM.Utils.CnvToStr(dr["mall_end_timing"]), MallPhone = PLWM.Utils.CnvToStr(dr["Phone"]), MallEmaild = PLWM.Utils.CnvToStr(dr["email"]), MallUrl = PLWM.Utils.CnvToStr(dr["mall_url"]), MallDecrp = PLWM.Utils.CnvToStr(dr["mall_decrp"]), MallMastImgPath = PLWM.Utils.CnvToStr(dr["mall_mast_img_path"]), }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public JobsmyaddsLD DoInit(ZA3000D FilterData, String Mode) { JobsmyaddsLD UsageD = new JobsmyaddsLD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZAJobList_Sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 1); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } else { UsageD.UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = "", ErrorMsg = "", } }; } UsageD.JobMastCol = new JobsmyaddsDCol(); foreach (DataRow Dr in ClasifiedDt.Rows) { UsageD.JobMastCol.Add(new JobsmyaddsD { EmpJobMastId = PLWM.Utils.CnvToInt(Dr["emp_job_mast_id"]), JobType = PLWM.Utils.CnvToStr(Dr["jobtype"]), Title = PLWM.Utils.CnvToStr(Dr["title"]), Descrptn = PLWM.Utils.CnvToStr(Dr["descrptn"]), Proimg = PLWM.Utils.CnvToStr(Dr["proimg"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3720ILD DoInit(ZA3000D FilterData, String Mode) { ZA3720ILD UsageD = new ZA3720ILD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("ai_pageno", ""), new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("as_Option", ""), new XElement("as_location", ""), new XElement("as_sortby", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3720_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable CatagoryDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable LocationDt = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable SortByDt = PLWM.Utils.GetDataTable(ds, 5); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } else { UsageD.UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = "", ErrorMsg = "", } }; } UsageD.ClasifiedsDataCol = new ZA3720BDCol(); foreach (DataRow Dr in ClasifiedDt.Rows) { UsageD.ClasifiedsDataCol.Add(new ZA3720BD { Title = PLWM.Utils.CnvToStr(Dr["clasifd_title"]), Age = PLWM.Utils.CnvToStr(Dr["Age"]), Condition = PLWM.Utils.CnvToStr(Dr["Condition"]), Email = PLWM.Utils.CnvToStr(Dr["usr_email"]), Location = PLWM.Utils.CnvToStr(Dr["Location"]), PhNo = PLWM.Utils.CnvToStr(Dr["usr_phno"]), PostDate = PLWM.Utils.CnvToStr(Dr["crtd_dt"]), ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]), Rate = PLWM.Utils.CnvToStr(Dr["Price"]), Usage = PLWM.Utils.CnvToStr(Dr["Usage"]), Warranty = PLWM.Utils.CnvToStr(Dr["warrenty"]), ClasifdAdMastId = PLWM.Utils.CnvToStr(Dr["clasifd_ad_mast_id"]), }); } UsageD.AgeCol = new ComDisValDCol(); UsageD.AgeCol.Add(new ComDisValD() { DisPlyMembr = "Age", ValMembr = -1 }); foreach (DataRow Dr in LocationDt.Rows) { UsageD.AgeCol.Add(new ComDisValD() { DisPlyMembr = PLWM.Utils.CnvToStr(Dr["clasifd_value"]), ValMembr = PLWM.Utils.CnvToInt(Dr["clasifd_dtl_id"]), }); } UsageD.SortByCol = new ComDisValDCol(); UsageD.SortByCol.Add(new ComDisValD() { DisPlyMembr = "Sorted By", ValMembr = -1 }); foreach (DataRow Dr in SortByDt.Rows) { UsageD.SortByCol.Add(new ComDisValD() { DisPlyMembr = PLWM.Utils.CnvToStr(Dr["SortMode"]), ValMembr = PLWM.Utils.CnvToInt(Dr["SortValue"]), }); } UsageD.CatagoryCol = new ZA3220DCol(); foreach (DataRow Dr in CatagoryDt.Rows) { UsageD.CatagoryCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToInt(Dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(Dr["clasifd_value"]), }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3611SD DoLoad(ZA3611SD FilterData, String Mode) { ZA3611SD SignUpV = new ZA3611SD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_Email", FilterData.UserData.Email), new XElement("as_Passwd", FilterData.UserData.Passwd), new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("prop_ad_mast_id", FilterData.UserData.ZaBase.PKID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3611_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtLocation = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable dtSelData = PLWM.Utils.GetDataTable(ds, 2); if (dtComn.Rows.Count > 0) { System.Data.DataRow dr1 = dtComn.Rows[0]; SignUpV = new ZA3611SD() { UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(dr1["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } } }; } else { SignUpV = new ZA3611SD() { UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { SessionId = "", UserName = "", ErrorMsg = "", ZaKey = Utils.GetKey() } } }; } foreach (DataRow dr in dtLocation.Rows) { SignUpV.LocationCol.Add(new ZA2000D() { CityMastID = PLWM.Utils.CnvToStr(dr["city_mast_id"]), PlaceName = PLWM.Utils.CnvToStr(dr["place_name"]) }); } if (dtSelData.Rows.Count > 0) { DataRow dr = dtSelData.Rows[0]; SignUpV.Price = PLWM.Utils.CnvToInt(dr["Price"]); SignUpV.Location = SignUpV.LocationCol.FirstOrDefault(x => x.CityMastID == PLWM.Utils.CnvToStr(dtSelData.Rows[0]["city_mast_id"])); } } catch (Exception e) { SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SignUpV); }
public ZA3600LD DoLoad(ZA3000D FilterData, String Mode) { ZA3600LD MotorSpecD = new ZA3600LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("as_mode", Mode), new XElement("as_email", FilterData.Email), new XElement("as_passwd", FilterData.Passwd), new XElement("ai_motors_ad_mast_id", FilterData.ZaBase.PKID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3600_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable YearDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable ColourDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable DoorsDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable WarrantyDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable RegionalSpecsDT = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable TransmissonDT = PLWM.Utils.GetDataTable(ds, 5); System.Data.DataTable BodyTypeDT = PLWM.Utils.GetDataTable(ds, 6); System.Data.DataTable FuelTypeDT = PLWM.Utils.GetDataTable(ds, 7); System.Data.DataTable CylindersDT = PLWM.Utils.GetDataTable(ds, 8); System.Data.DataTable SellerTypeDT = PLWM.Utils.GetDataTable(ds, 9); System.Data.DataTable ExtrasDT = PLWM.Utils.GetDataTable(ds, 10); System.Data.DataTable TechinalFeaturesDT = PLWM.Utils.GetDataTable(ds, 11); System.Data.DataTable HoursePowerDT = PLWM.Utils.GetDataTable(ds, 12); System.Data.DataTable BrandColDT = PLWM.Utils.GetDataTable(ds, 13); System.Data.DataTable ConditionDT = PLWM.Utils.GetDataTable(ds, 14); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 15); System.Data.DataTable dtSelectedData = PLWM.Utils.GetDataTable(ds, 16); DataRow drUser = null; if (dtUser.Rows.Count > 0) { drUser = dtUser.Rows[0]; } MotorSpecD.YearCol = new ZA3200DCol(); MotorSpecD.YearCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Year" }); foreach (DataRow dr in YearDt.Rows) { MotorSpecD.YearCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.ColourCol = new ZA3200DCol(); MotorSpecD.ColourCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Colour" }); foreach (DataRow dr in ColourDt.Rows) { MotorSpecD.ColourCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.DoorsCol = new ZA3200DCol(); MotorSpecD.DoorsCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Doors" }); foreach (DataRow dr in DoorsDt.Rows) { MotorSpecD.DoorsCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.WarrantyCol = new ZA3200DCol(); MotorSpecD.WarrantyCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Warranty" }); foreach (DataRow dr in WarrantyDt.Rows) { MotorSpecD.WarrantyCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.RegionalSpecsCol = new ZA3200DCol(); MotorSpecD.RegionalSpecsCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Regional Specs" }); foreach (DataRow dr in RegionalSpecsDT.Rows) { MotorSpecD.RegionalSpecsCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.TransmissonCol = new ZA3200DCol(); MotorSpecD.TransmissonCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Transmisson Type" }); foreach (DataRow dr in TransmissonDT.Rows) { MotorSpecD.TransmissonCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.BodyTypeCol = new ZA3200DCol(); MotorSpecD.BodyTypeCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Body Type" }); foreach (DataRow dr in BodyTypeDT.Rows) { MotorSpecD.BodyTypeCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.FuelTypeCol = new ZA3200DCol(); MotorSpecD.FuelTypeCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Fuel Type" }); foreach (DataRow dr in FuelTypeDT.Rows) { MotorSpecD.FuelTypeCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.CylindersCol = new ZA3200DCol(); MotorSpecD.CylindersCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = " No. of Cylinders" }); foreach (DataRow dr in CylindersDT.Rows) { MotorSpecD.CylindersCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.SellerTypeCol = new ZA3200DCol(); MotorSpecD.SellerTypeCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Listed by" }); foreach (DataRow dr in SellerTypeDT.Rows) { MotorSpecD.SellerTypeCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.ExtrasCol = new ZA3200DCol(); foreach (DataRow dr in ExtrasDT.Rows) { MotorSpecD.ExtrasCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.TechinalFeaturesCol = new ZA3200DCol(); foreach (DataRow dr in TechinalFeaturesDT.Rows) { MotorSpecD.TechinalFeaturesCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.HoursePowerCol = new ZA3200DCol(); MotorSpecD.HoursePowerCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Horsepower" }); foreach (DataRow dr in HoursePowerDT.Rows) { MotorSpecD.HoursePowerCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.BrandCol = new ZA3200DCol(); MotorSpecD.BrandCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Brand" }); foreach (DataRow dr in BrandColDT.Rows) { MotorSpecD.BrandCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.ConditionCol = new ZA3200DCol(); MotorSpecD.ConditionCol.Add(new ZA3200D() { MotorSpecDtlId = -1, MotorSpecValue = "Condition" }); foreach (DataRow dr in ConditionDT.Rows) { MotorSpecD.ConditionCol.Add(new ZA3200D() { MotorSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["motor_spec_dtl_id"]), MotorSpecValue = PLWM.Utils.CnvToStr(dr["motor_spec_value"]), }); } MotorSpecD.UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]), UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; if (dtSelectedData.Rows.Count > 0) { MotorSpecD.SelectedData = new ZA3600SD() { BodyType = MotorSpecD.BodyTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["BodyType_id"])), Brand = MotorSpecD.BrandCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Brand_id"])), Colour = MotorSpecD.ColourCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Colour_id"])), Condition = MotorSpecD.ConditionCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["condition_id"])), Cylinders = MotorSpecD.CylindersCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Cylinders_id"])), Doors = MotorSpecD.DoorsCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Doors_id"])), FuelType = MotorSpecD.FuelTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["FuelType_id"])), HoursePower = MotorSpecD.HoursePowerCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["HoursePower_id"])), RegionalSpecs = MotorSpecD.RegionalSpecsCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["RegionalSpecs_id"])), SellerType = MotorSpecD.SellerTypeCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["SellerType_id"])), Year = MotorSpecD.YearCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Year_id"])), Warranty = MotorSpecD.WarrantyCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Warranty_id"])), Transmisson = MotorSpecD.TransmissonCol.FirstOrDefault(x => x.MotorSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["Transmisson_id"])), KiloMetrs = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["Kmters"]), Title = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["mot_Title"]), Description = PLWM.Utils.CnvToStr(dtSelectedData.Rows[0]["mot_Description"]), MotorsADMastID = PLWM.Utils.CnvToNullableInt(dtSelectedData.Rows[0]["motors_ad_mast_id"]), }; } } catch (Exception e) { MotorSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(MotorSpecD); }
public ZA3720ILD DoInit(ZA3000D FilterData, String Mode) { ZA3720ILD UsageD = new ZA3720ILD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3620AD_Sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 2); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } else { UsageD.UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = "", ErrorMsg = "", } }; } UsageD.ClasifiedsDataCol = new ZA3720BDCol(); foreach (DataRow Dr in ClasifiedDt.Rows) { UsageD.ClasifiedsDataCol.Add(new ZA3720BD { Title = PLWM.Utils.CnvToStr(Dr["clasifd_title"]), Age = PLWM.Utils.CnvToStr(Dr["Age"]), Condition = PLWM.Utils.CnvToStr(Dr["Condition"]), Email = PLWM.Utils.CnvToStr(Dr["usr_email"]), Location = PLWM.Utils.CnvToStr(Dr["Location"]), PhNo = PLWM.Utils.CnvToStr(Dr["usr_phno"]), PostDate = PLWM.Utils.CnvToStr(Dr["crtd_dt"]), ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]), Rate = PLWM.Utils.CnvToStr(Dr["Price"]), Usage = PLWM.Utils.CnvToStr(Dr["Usage"]), Warranty = PLWM.Utils.CnvToStr(Dr["warrenty"]), ClasifdAdMastId = PLWM.Utils.CnvToStr(Dr["clasifd_ad_mast_id"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3661LD DoLoad(ZA3661D FilterData, String Mode) { ZA3661LD UsageD = new ZA3661LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("ai_pageno", FilterData.PageNo), new XElement("ai_dir_dtl_id", ""), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3661_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable MallcolDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 2); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } foreach (DataRow dr in MallcolDt.Rows) { UsageD.DirCol.Add(new ZA3661D() { DirDtlId = PLWM.Utils.CnvToInt(dr["dir_dtl_id"]), CompName = PLWM.Utils.CnvToStr(dr["comp_name"]), Addrs = PLWM.Utils.CnvToStr(dr["addrs"]), Phone_1 = PLWM.Utils.CnvToStr(dr["phone_1"]), Mobile = PLWM.Utils.CnvToStr(dr["Mobile"]), Email = PLWM.Utils.CnvToStr(dr["email"]), }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3010D DoSave(ZA3010D FilterData, String Mode, long FileLength) { ZA3010D SaveDataV = new ZA3010D(); try { XDocument doc = new XDocument(new XElement("Root", //new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("ai_deal_mast_id", FilterData.DealMastID), new XElement("as_busines_Name", FilterData.BusinessName), new XElement("as_busines_Url", FilterData.URL), new XElement("ai_catgry_id", FilterData.Category), new XElement("as_banner_img_url", FilterData.BannerImage), new XElement("as_logo_img_url", FilterData.CompanyLogo), new XElement("as_fb_url", FilterData.Facebook), new XElement("as_Instagram_url", FilterData.Instagram), new XElement("as_Twitter_url", FilterData.Twitter), new XElement("as_Phone_No", FilterData.PhoneNo), new XElement("as_Email", FilterData.Email), new XElement("as_Website", FilterData.Website), new XElement("as_geo_Location", FilterData.Location), new XElement("as_Description", FilterData.Description), new XElement("as_PhotoLength", FileLength) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3010_IU", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); if (dtComn.Rows.Count > 0) { SaveDataV.BusinessName = PLWM.Utils.CnvToStr(dtComn.Rows[0]["busines_Name"]); SaveDataV.URL = PLWM.Utils.CnvToStr(dtComn.Rows[0]["busines_Url"]); SaveDataV.Category = PLWM.Utils.CnvToStr(dtComn.Rows[0]["catgry_id"]); SaveDataV.BannerImage = PLWM.Utils.CnvToStr(dtComn.Rows[0]["banner_img_url"]); SaveDataV.CompanyLogo = PLWM.Utils.CnvToStr(dtComn.Rows[0]["logo_img_url"]); SaveDataV.Facebook = PLWM.Utils.CnvToStr(dtComn.Rows[0]["fb_url"]); SaveDataV.Instagram = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Instagram_url"]); SaveDataV.Twitter = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Twitter_url"]); SaveDataV.PhoneNo = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Phone_No"]); SaveDataV.Email = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Email"]); SaveDataV.Website = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Website"]); SaveDataV.Location = PLWM.Utils.CnvToStr(dtComn.Rows[0]["geo_Location"]); SaveDataV.Description = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Description"]); } } catch (Exception e) { SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SaveDataV); }
public ZA3630LD DoInit(ZA3630RPD FilterData, String Mode) { ZA3630LD UsageD = new ZA3630LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("ai_pageno", FilterData.PageNo), new XElement("as_jobfilter", FilterData.IndstryCol.EmpJobDtlId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3630RP_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable MallcolDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable filterDt = PLWM.Utils.GetDataTable(ds, 7); if (UserDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]), FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), }, }; } foreach (DataRow dr in MallcolDt.Rows) { UsageD.EmpJobCol.Add(new ZA3630D() { EmpJobMastID = PLWM.Utils.CnvToStr(dr["emp_job_mast_id"]), FirstName = PLWM.Utils.CnvToStr(dr["FirstName"]), Title = PLWM.Utils.CnvToStr(dr["Title"]), CrtdDt = PLWM.Utils.CnvToStr(dr["crtd_dt"]), WorkExperiance = PLWM.Utils.CnvToStr(dr["WorkExp"]), CurrentLoc = PLWM.Utils.CnvToStr(dr["CurLoc"]), EducationalLevel = PLWM.Utils.CnvToStr(dr["EduLevel"]), Proimg = PLWM.Utils.CnvToStr(dr["proimg"]) }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } UsageD.ReportypCol.Add(new ComDisValD() { DisPlyMembr = "Hiring", ValMembr = 0 }); UsageD.ReportypCol.Add(new ComDisValD() { DisPlyMembr = "Jobs Wanted", ValMembr = 1 }); foreach (DataRow dr in filterDt.Rows) { UsageD.IndustryCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
//DoLoadPackage public ZA3010LD DoLoadPackage(ZA3000D FilterData, String Mode) { ZA3010LD UsageData = new ZA3010LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("ai_deal_mast_id", ""), new XElement("as_sessionid", FilterData.ZaBase.SessionId), 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("ZA3010_SEL", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 2); if (dtComn.Rows.Count > 0) { UsageData.PackCol.Add(new ZA3010D() { PackDealMastID = PLWM.Utils.CnvToInt(dtComn.Rows[0]["pack_deal_mast_id"]), BusinessName = PLWM.Utils.CnvToStr(dtComn.Rows[0]["busines_Name"]), Location = PLWM.Utils.CnvToStr(dtComn.Rows[0]["geo_Location"]), Email = PLWM.Utils.CnvToStr(dtComn.Rows[0]["Email"]), CompanyLogo = PLWM.Utils.CnvToStr(dtComn.Rows[0]["logo_img_url"]), }); } if (dtUser.Rows.Count > 0) { UsageData.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(dtUser.Rows[0]["usr_FistNam"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dtUser.Rows[0]["sessionid"]), } }; } UsageData.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageData.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageData.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageData); }
public ZA3700ILD DoLoad(ZA3700LFD FilterData, String Mode) { ZA3700ILD UsageD = new ZA3700ILD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("as_sessionid", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3700AD_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 1); UsageD.UserData = new ZA3000D() { ZaBase = new BaseD() { ZaKey = Utils.GetKey(), ErrorMsg = "" } }; UsageD.MotorDataCol = new ZA3700BDCol(); foreach (DataRow Dr in ClasifiedDt.Rows) { UsageD.MotorDataCol.Add(new ZA3700BD { Title = PLWM.Utils.CnvToStr(Dr["mot_Title"]), Years = PLWM.Utils.CnvToStr(Dr["Years"]), Kmters = PLWM.Utils.CnvToStr(Dr["Kmters"]), Email = PLWM.Utils.CnvToStr(Dr["usr_email"]), Location = PLWM.Utils.CnvToStr(Dr["Location"]), PhNo = PLWM.Utils.CnvToStr(Dr["usr_phno"]), PostDate = PLWM.Utils.CnvToStr(Dr["crtd_dt"]), ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]), Rate = PLWM.Utils.CnvToStr(Dr["Price"]), Colors = PLWM.Utils.CnvToStr(Dr["Colors"]), Doors = PLWM.Utils.CnvToStr(Dr["Doors"]), MotorsAdMastId = PLWM.Utils.CnvToStr(Dr["motors_ad_mast_id"]) }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3700ILD DoInit(ZA3000D FilterData, String Mode) { ZA3700ILD UsageD = new ZA3700ILD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3700AD_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable MotorDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 1); if (UserDataDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } else { UsageD.UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = "", ErrorMsg = "", } }; } UsageD.MotorDataCol = new ZA3700BDCol(); foreach (DataRow Dr in MotorDt.Rows) { UsageD.MotorDataCol.Add(new ZA3700BD { Title = PLWM.Utils.CnvToStr(Dr["mot_Title"]), ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]), Rate = PLWM.Utils.CnvToStr(Dr["Price"]), MotorsAdMastId = PLWM.Utils.CnvToStr(Dr["motors_ad_mast_id"]) }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3620LD DoLoad(ZA3000D FilterData, String Mode) { ZA3620LD UsageD = new ZA3620LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("as_mode", Mode), new XElement("as_email", FilterData.Email), new XElement("as_passwd", FilterData.Passwd), new XElement("ai_clasifd_ad_mast_id", FilterData.ZaBase.PKID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3620_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable CategoryDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable SubCategoryDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable AgeDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable UsageDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable ConditionDT = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable WarrantyDT = PLWM.Utils.GetDataTable(ds, 5); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 6); System.Data.DataTable dtSelData = PLWM.Utils.GetDataTable(ds, 7); DataRow drUser = null; if (dtUser.Rows.Count > 0) { drUser = dtUser.Rows[0]; } UsageD.CategoryCol = new ZA3220DCol(); UsageD.CategoryCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Category" }); foreach (DataRow dr in CategoryDt.Rows) { UsageD.CategoryCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.SubCategoryCol = new ZA3220DCol(); UsageD.SubCategoryCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Sub Category" }); foreach (DataRow dr in SubCategoryDt.Rows) { UsageD.SubCategoryCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.AgeCol = new ZA3220DCol(); UsageD.AgeCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Age" }); foreach (DataRow dr in AgeDt.Rows) { UsageD.AgeCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.UsageCol = new ZA3220DCol(); UsageD.UsageCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Usage" }); foreach (DataRow dr in UsageDt.Rows) { UsageD.UsageCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.ConditionCol = new ZA3220DCol(); UsageD.ConditionCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Condition" }); foreach (DataRow dr in ConditionDT.Rows) { UsageD.ConditionCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.WarrantyCol = new ZA3220DCol(); UsageD.WarrantyCol.Add(new ZA3220D() { ClasifdSpecDtlId = -1, ClasifdSpecValue = "Warranty" }); foreach (DataRow dr in WarrantyDT.Rows) { UsageD.WarrantyCol.Add(new ZA3220D() { ClasifdSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["clasifd_dtl_id"]), ClasifdSpecValue = PLWM.Utils.CnvToStr(dr["clasifd_value"]), }); } UsageD.UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]), UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; foreach (DataRow dr in dtSelData.Rows) { UsageD.SelectedDataDtl = new ZA3621SD() { Location = UsageD.LocationCol.FirstOrDefault(x => x.CityMastID == PLWM.Utils.CnvToStr(dtSelData.Rows[0]["city_mast_id"])), Price = PLWM.Utils.CnvToInt(dtSelData.Rows[0]["Price"]), }; } foreach (DataRow dr in dtSelData.Rows) { UsageD.SelectedData = new ZA3620SD() { ClasifdADMastID = PLWM.Utils.CnvToInt(dtSelData.Rows[0]["clasifd_ad_mast_id"]), Title = PLWM.Utils.CnvToStr(dtSelData.Rows[0]["clasifd_title"]), Description = PLWM.Utils.CnvToStr(dtSelData.Rows[0]["clasifd_Description"]), Category = UsageD.CategoryCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Category_id"])), Age = UsageD.AgeCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Age_id"])), Usage = UsageD.UsageCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Usage_id"])), Condition = UsageD.ConditionCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Condition_id"])), Warranty = UsageD.WarrantyCol.FirstOrDefault(x => x.ClasifdSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSelData.Rows[0]["Warranty_id"])), }; } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3240LD DoLoad(ZA3240D FilterData, String Mode) { ZA3240LD SignUpV = new ZA3240LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("ai_deal_mast_id", FilterData.UsrBusinesMastId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3240_sel", XString, PLABSM.DbProvider.MSSql); if (Mode == "LM") { System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtPlanNames = PLWM.Utils.GetDataTable(ds, 1); if (dtComn.Rows.Count > 0) { DataRow dr1 = dtComn.Rows[0]; SignUpV.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(dr1["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; } if (dtPlanNames.Rows.Count > 0) { foreach (DataRow drPlans in dtPlanNames.Rows) { SignUpV.Business.Add(new ZA3240D() { PlanName = PLWM.Utils.CnvToStr(drPlans["plan_name"]), UsrBusinesMastId = PLWM.Utils.CnvToNullableInt(drPlans["pack_deal_mast_id"]), UsrBusinesName = PLWM.Utils.CnvToStr(drPlans["busines_Name"]), }); } } } //else if (Mode == "SE") //{ // System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); // System.Data.DataTable dtPlanNames = PLWM.Utils.GetDataTable(ds, 1); // if (dtComn.Rows.Count > 0) // { // System.Data.DataRow dr1 = dtComn.Rows[0]; // SignUpV = new ZA3240D() // { // UserData = new ZA3000D() // { // FistNam = PLWM.Utils.CnvToStr(dr1["FirstName"]), // ZaBase = new BaseD() // { // SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), // UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), // ErrorMsg = "", // ZaKey = Utils.GetKey() // } // } // }; // } // if (dtPlanNames.Rows.Count > 0) // { // DataRow drPlans = dtPlanNames.Rows[0]; // SignUpV.PlanName = PLWM.Utils.CnvToStr(drPlans["plan_name"]); // SignUpV.UsrBusinesMastId = PLWM.Utils.CnvToNullableInt(drPlans["usr_busines_mast_id"]); // SignUpV.UsrBusinesName = PLWM.Utils.CnvToStr(drPlans["usr_busines_Name"]); // SignUpV.UsrBusinesUrl = PLWM.Utils.CnvToStr(drPlans["usr_busines_url"]); // SignUpV.CategryMastId = PLWM.Utils.CnvToStr(drPlans["categry_mast_id"]); // SignUpV.TitleLogoUrl = PLWM.Utils.CnvToStr(drPlans["title_logo_url"]); // SignUpV.BusinesLogoUrl = PLWM.Utils.CnvToStr(drPlans["busines_logo_url"]); // SignUpV.FacebookUrl = PLWM.Utils.CnvToStr(drPlans["Facebook_url"]); // SignUpV.InstagramUrl = PLWM.Utils.CnvToStr(drPlans["Instagram_url"]); // SignUpV.TwitterUrl = PLWM.Utils.CnvToStr(drPlans["Twitter_url"]); // SignUpV.PhoneNo = PLWM.Utils.CnvToStr(drPlans["Phone_No"]); // SignUpV.EmailId = PLWM.Utils.CnvToStr(drPlans["Email_id"]); // SignUpV.BusinesUrl = PLWM.Utils.CnvToStr(drPlans["busines_url"]); // SignUpV.GeoLocation = PLWM.Utils.CnvToStr(drPlans["geo_Location"]); // SignUpV.DescriptionAboutus = PLWM.Utils.CnvToStr(drPlans["Description_aboutus"]); // } //} } catch (Exception e) { SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SignUpV); }
public ZA3611SD DoSave(ZA3611SD FilterData, String Mode) { ZA3611SD SignUpV = new ZA3611SD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_PropADMastID", FilterData.AddPropADMastID), new XElement("as_seq", FilterData.AdSeq), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("as_Price", FilterData.Price), new XElement("as_mode", Mode), new XElement("as_Location", FilterData.Location.CityMastID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3611_IU", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtFiles = PLWM.Utils.GetDataTable(ds, 1); if (dtComn.Rows.Count > 0) { System.Data.DataRow dr1 = dtComn.Rows[0]; SignUpV = new ZA3611SD() { UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } } }; SignUpV.FileNames = new ComDisValDCol(); foreach (DataRow dr in dtFiles.Rows) { SignUpV.FileNames.Add(new ComDisValD() { DisPlyMembr = PLWM.Utils.CnvToStr(dr["ImgFullPath"]), ValMembr = PLWM.Utils.CnvToNullableInt(dr["seqnc"]), Descriptn = PLWM.Utils.CnvToStr(dr["ImageUrl"]), }); } } else { SignUpV = new ZA3611SD() { UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = "", UserName = "", ErrorMsg = "", ZaKey = Utils.GetKey() } } }; SignUpV.FileNames = new ComDisValDCol(); } } catch (Exception e) { SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SignUpV); }
public ZA2990D DoLoad(ZA3000D FilterData, String Mode) { ZA2990D SignUpV = new ZA2990D(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_Email", FilterData.Email), new XElement("as_Passwd", FilterData.Passwd), new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("ai_usr_mast_id", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA2990_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); if (dtComn.Rows.Count > 0) { System.Data.DataRow dr1 = dtComn.Rows[0]; SignUpV = new ZA2990D() { UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(dr1["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } } }; } else { SignUpV = new ZA2990D() { UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { SessionId = "", UserName = "", ErrorMsg = "", ZaKey = Utils.GetKey() } } }; } } catch (Exception e) { SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SignUpV); }
public ZA3631RPD DoLoad(ZA3631RPD FilterData, String Mode) { ZA3631RPD JobWantDet = new ZA3631RPD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_emp_job_mast_id", FilterData.EmpJobMast.EmpJobMastID), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3631RP_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable EmpJobColDt = PLWM.Utils.GetDataTable(ds, 1); foreach (DataRow dr in EmpJobColDt.Rows) { JobWantDet.EmpJobMast = new ZA3630D() { EmpJobMastID = PLWM.Utils.CnvToStr(dr["emp_job_mast_id"]), FirstName = PLWM.Utils.CnvToStr(dr["FirstName"]), Gender = PLWM.Utils.CnvToStr(dr["Gender"]), Title = PLWM.Utils.CnvToStr(dr["Title"]), Description = PLWM.Utils.CnvToStr(dr["descr"]), Mobile = PLWM.Utils.CnvToStr(dr["Mobile"]), Email = PLWM.Utils.CnvToStr(dr["Email"]), CurrentCompany = PLWM.Utils.CnvToStr(dr["CurrentCompany"]), CurrentPos = PLWM.Utils.CnvToStr(dr["CurrentPos"]), NoticePeriod = PLWM.Utils.CnvToStr(dr["NoticePeriod"]), Nationality = PLWM.Utils.CnvToStr(dr["Nationality"]), CurrentLoc = PLWM.Utils.CnvToStr(dr["CurLoc"]), VisaStatus = PLWM.Utils.CnvToStr(dr["VisaStatus"]), CarrierLevel = PLWM.Utils.CnvToStr(dr["CarrierLevl"]), CurrentSalary = PLWM.Utils.CnvToStr(dr["CurrentSal"]), WorkExperiance = PLWM.Utils.CnvToStr(dr["WorkExp"]), EducationalLevel = PLWM.Utils.CnvToStr(dr["EduLevel"]), Commitment = PLWM.Utils.CnvToStr(dr["Commitment"]), CrtdDt = PLWM.Utils.CnvToStr(dr["crtd_dt"]), Proimg = PLWM.Utils.CnvToStr(dr["proimg"]), }; } if (UserDt.Rows.Count > 0) { JobWantDet.UserData = new ZA3000D() { UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]), FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), }, }; } //UserData } catch (Exception e) { JobWantDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(JobWantDet); }
public ZA2990D SendPwd(ZA3000D FilterData, String Mode) { ZA2990D SignUpV = new ZA2990D(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_Email", FilterData.Email), new XElement("as_Passwd", FilterData.Passwd), new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("ai_usr_mast_id", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA2990_IU", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); if (dtComn.Rows.Count > 0) { String Password = PLWM.Utils.CnvToStr(dtComn.Rows[0]["usr_passwd"]); String UsrFistNam = PLWM.Utils.CnvToStr(dtComn.Rows[0]["usr_FistNam"]); String PhoneNo = PLWM.Utils.CnvToStr(dtComn.Rows[0]["usr_phno"]); String Message = GetSmsEmailFormats.GetResetPwdEmail(Password); Utils.SendEmail(Message, FilterData.Email, "Please find the new password", "Zeroori", UsrFistNam); //String Message = GetSmsEmailFormats.GetOtp(Otp); Utils.GetSms(PhoneNo, Password); SignUpV = new ZA2990D() { UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { SessionId = "", UserName = UsrFistNam, ErrorMsg = "", ZaKey = Utils.GetKey() } } }; } else { SignUpV = new ZA2990D() { UserData = new ZA3000D() { FistNam = "", ZaBase = new BaseD() { SessionId = "", UserName = "", ErrorMsg = "Invalid email ID", ZaKey = Utils.GetKey() } } }; } } catch (Exception e) { SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SignUpV); }
public ZA3650LD DoLoadFrelncList(ZA3650LD FilterData, String Mode) { ZA3650LD UsageD = new ZA3650LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", Mode), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("ai_pageno", FilterData.PageNo), new XElement("ai_frelnc_comp_job_mast_id", "") )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3680_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable FrelncColDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 2); if (UserDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]), FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), }, }; } foreach (DataRow dr in FrelncColDt.Rows) { UsageD.ComCol.Add(new ZA3650SD() { CompnyJobMastId = PLWM.Utils.CnvToInt(dr["frelnc_comp_job_mast_id"]), CompnyName = PLWM.Utils.CnvToStr(dr["comp_name"]), JobTitle = PLWM.Utils.CnvToStr(dr["Title"]), CrtdDt = PLWM.Utils.CnvToStr(dr["crtd_dt"]), Location = PLWM.Utils.CnvToStr(dr["location"]), DescrpnStepOne = PLWM.Utils.CnvToStr(dr["descrpn"]), }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } UsageD.ReportypCol.Add(new ComDisValD() { DisPlyMembr = "Hiring", ValMembr = 0 }); UsageD.ReportypCol.Add(new ComDisValD() { DisPlyMembr = "Jobs Wanted", ValMembr = 1 }); } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3711LD DoLoad(ZA3711LD FilterData, String Mode) { ZA3711LD UsageD = new ZA3711LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_prop_ad_mast_id", FilterData.PropAdMastId), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3711_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable MotorDataDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable FileNamesDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 2); UsageD.PropTitle = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["prop_title"]); UsageD.CrtdDt = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["crtd_dt"]); UsageD.BedRoom = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["bedRoom"]); UsageD.BathRoom = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["bathRoom"]); UsageD.Size = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["size"]); UsageD.IsFurnished = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["isFurnished"]); UsageD.Appartment = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["appartment"]); UsageD.RentIsPaid = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["rentIsPaid"]); UsageD.ListedBy = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["listedBy"]); UsageD.Category = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["category"]); UsageD.City = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["city"]); UsageD.UsrEmail = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["usr_email"]); UsageD.UsrPhno = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["usr_phno"]); UsageD.PropDescription = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["prop_Description"]); UsageD.PlaceName = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Location"]); UsageD.Price = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Price"]); UsageD.FileNames = new ComDisValDCol(); foreach (DataRow Dr in FileNamesDt.Rows) { UsageD.FileNames.Add(new ComDisValD { DisPlyMembr = PLWM.Utils.CnvToStr(Dr["full_path"]), }); } if (UserDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3610LD DoLoad(ZA3000D FilterData, String Mode) { ZA3610LD PropSpecD = new ZA3610LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_sessionid", FilterData.ZaBase.SessionId), new XElement("as_mode", Mode), new XElement("as_email", FilterData.Email), new XElement("as_passwd", FilterData.Passwd), new XElement("ai_prop_ad_mast_id", FilterData.ZaBase.PKID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3610_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable BedroomDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable BathRoomDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable SizeDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable PropSpecDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable ApartmentForDT = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable RentIsPaidDT = PLWM.Utils.GetDataTable(ds, 5); System.Data.DataTable ListedByDT = PLWM.Utils.GetDataTable(ds, 6); System.Data.DataTable CategoryDT = PLWM.Utils.GetDataTable(ds, 7); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 8); System.Data.DataTable dtSel = PLWM.Utils.GetDataTable(ds, 9); DataRow drUser = null; if (dtUser.Rows.Count > 0) { drUser = dtUser.Rows[0]; } PropSpecD.BedroomCol = new ZA3210DCol(); PropSpecD.BedroomCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Bed Room" }); foreach (DataRow dr in BedroomDt.Rows) { PropSpecD.BedroomCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.BathRoomCol = new ZA3210DCol(); PropSpecD.BathRoomCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Bath Room" }); foreach (DataRow dr in BathRoomDt.Rows) { PropSpecD.BathRoomCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.SizeCol = new ZA3210DCol(); PropSpecD.SizeCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Size ( Sq.Mtr)" }); foreach (DataRow dr in SizeDt.Rows) { PropSpecD.SizeCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.FurnishedCol = new ZA3210DCol(); PropSpecD.FurnishedCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Furnished" }); foreach (DataRow dr in PropSpecDt.Rows) { PropSpecD.FurnishedCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.ApartmentForCol = new ZA3210DCol(); PropSpecD.ApartmentForCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Apartment For" }); foreach (DataRow dr in ApartmentForDT.Rows) { PropSpecD.ApartmentForCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.RentIsPaidCol = new ZA3210DCol(); PropSpecD.RentIsPaidCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Rent Is Paid" }); foreach (DataRow dr in RentIsPaidDT.Rows) { PropSpecD.RentIsPaidCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.ListedByCol = new ZA3210DCol(); PropSpecD.ListedByCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Listed By" }); foreach (DataRow dr in ListedByDT.Rows) { PropSpecD.ListedByCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.CategoryCol = new ZA3210DCol(); PropSpecD.CategoryCol.Add(new ZA3210D() { PropSpecDtlId = -1, PropSpecValue = "Category" }); foreach (DataRow dr in CategoryDT.Rows) { PropSpecD.CategoryCol.Add(new ZA3210D() { PropSpecDtlId = PLWM.Utils.CnvToNullableInt(dr["Prop_dtl_id"]), PropSpecValue = PLWM.Utils.CnvToStr(dr["Prop_value"]), }); } PropSpecD.UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]), UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; if (dtSel.Rows.Count > 0) { PropSpecD.SelectedData = new ZA3610SD() { BathRoom = PropSpecD.BathRoomCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["bath_room_id"])), Bedroom = PropSpecD.BedroomCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["bed_room_id"])), Size = PropSpecD.SizeCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["size_id"])), Furnished = PropSpecD.FurnishedCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["is_Furnished_id"])), ApartmentFor = PropSpecD.ApartmentForCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["apartment_for_id"])), RentIsPaid = PropSpecD.RentIsPaidCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["Rent_Is_Paid_id"])), ListedBy = PropSpecD.ListedByCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["listed_by_id"])), Category = PropSpecD.CategoryCol.FirstOrDefault(x => x.PropSpecDtlId == PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["Category_id"])), Description = PLWM.Utils.CnvToStr(dtSel.Rows[0]["prop_Description"]), Title = PLWM.Utils.CnvToStr(dtSel.Rows[0]["prop_title"]), PropADMastID = PLWM.Utils.CnvToNullableInt(dtSel.Rows[0]["prop_ad_mast_id"]), }; } } catch (Exception e) { PropSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(PropSpecD); }
public ZA3000D DoSave(ZA3000D FilterData, String Mode) { ZA3000D SignUpV = new ZA3000D(); if (FilterData.FistNam.Trim() == "") { SignUpV.ZaBase.ErrorMsg = "Please Enter First Name"; } else if (!Regex.IsMatch(FilterData.FistNam.Trim(), @"^[a-zA-Z]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid First Name"; } else if (FilterData.LastNam.Trim() == "") { SignUpV.ZaBase.ErrorMsg = "Please Enter Last Name"; } else if (!Regex.IsMatch(FilterData.LastNam.Trim(), @"^[a-zA-Z]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid Last Name"; } else if (!Regex.IsMatch(FilterData.Mob.Trim(), @"^[0-9]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid Mobile Number"; } else if (FilterData.Mob.Trim().Length < 8) { SignUpV.ZaBase.ErrorMsg = " Mobile Number Must Be Grater Than 8 Digits"; } else if (FilterData.Passwd.Trim().Length < 8) { SignUpV.ZaBase.ErrorMsg = "Your password must be at least 8 characters.";; } else { try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_FistNam", FilterData.FistNam), new XElement("as_LastNam", FilterData.LastNam), new XElement("as_Email", FilterData.Email), new XElement("as_Passwd", FilterData.Passwd), new XElement("as_Mob", FilterData.Mob), new XElement("as_mode", Mode), new XElement("ai_usr_mast_id", FilterData.UsrMastID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3000_IU", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtOtpEmail = PLWM.Utils.GetDataTable(ds, 1); if (dtComn.Rows.Count > 0) { System.Data.DataRow dr1 = dtComn.Rows[0]; SignUpV = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]), UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey(), Fld = PLWM.Utils.CnvToStr(dr1["usr_fldr_nam"]) } }; } if (dtOtpEmail.Rows.Count > 0) { String Otp = PLWM.Utils.CnvToStr(dtOtpEmail.Rows[0]["OTP"]); String PhoneNo = PLWM.Utils.CnvToStr(dtOtpEmail.Rows[0]["Mobno"]); String Email = PLWM.Utils.CnvToStr(dtOtpEmail.Rows[0]["Email"]); String Message = GetSmsEmailFormats.GetOtp(Otp); Utils.GetSms(PhoneNo, Otp); Message = GetSmsEmailFormats.GetEmail(Otp); Utils.SendEmail(Message, Email, "Please find the otp in this email for activation", "Zeroori", SignUpV.ZaBase.UserName); } } catch (Exception e) { SignUpV.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } } return(SignUpV); }
public ZA3271LD DoLoad(ZA3271LD FilterData, String Mode) { ZA3271LD MallDet = new ZA3271LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_mallMastId", FilterData.MallMast.MallAdMastId), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3271_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable MallcolDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable FileNamesDt = PLWM.Utils.GetDataTable(ds, 2); foreach (DataRow dr in MallcolDt.Rows) { MallDet.MallMast = new ZA3270D() { MallAdMastId = PLWM.Utils.CnvToStr(dr["mall_mast_id"]), MallName = PLWM.Utils.CnvToStr(dr["mall_name"]), MallLocation = PLWM.Utils.CnvToStr(dr["mall_location"]), MallStartTiming = PLWM.Utils.CnvToStr(dr["mall_start_timing"]), MallEndTiming = PLWM.Utils.CnvToStr(dr["mall_end_timing"]), MallPhone = PLWM.Utils.CnvToStr(dr["Phone"]), MallEmaild = PLWM.Utils.CnvToStr(dr["email"]), MallUrl = PLWM.Utils.CnvToStr(dr["mall_url"]), MallDecrp = PLWM.Utils.CnvToStr(dr["mall_decrp"]) }; } MallDet.FileNames = new ComDisValDCol(); foreach (DataRow Dr in FileNamesDt.Rows) { MallDet.FileNames.Add(new ComDisValD { DisPlyMembr = PLWM.Utils.CnvToStr(Dr["mall_mast_img_path"]), }); } if (UserDt.Rows.Count > 0) { MallDet.UserData = new ZA3000D() { UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]), FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), }, }; } //UserData } catch (Exception e) { MallDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(MallDet); }
public ZA3000D DoUpdate(ZA3000D FilterData, String Mode) { ZA3000D SignUpV = new ZA3000D(); if (FilterData.FistNam.Trim() == "") { SignUpV.ZaBase.ErrorMsg = "Please Enter First Name"; } else if (!Regex.IsMatch(FilterData.FistNam.Trim(), @"^[a-zA-Z]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid First Name"; } else if (FilterData.LastNam.Trim() == "") { SignUpV.ZaBase.ErrorMsg = "Please Enter Last Name"; } else if (!Regex.IsMatch(FilterData.LastNam.Trim(), @"^[a-zA-Z]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid Last Name"; } else if (!Regex.IsMatch(FilterData.Mob.Trim(), @"^[0-9]+$")) { SignUpV.ZaBase.ErrorMsg = "Please Enter A Valid Mobile Number"; } else { try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_FistNam", FilterData.FistNam), new XElement("as_LastNam", FilterData.LastNam), new XElement("as_Email", FilterData.Email), new XElement("as_Mob", FilterData.Mob), new XElement("as_mode", Mode), new XElement("ai_usr_mast_id", FilterData.UsrMastID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3000_IU", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 0); if (dtUser.Rows.Count > 0) { System.Data.DataRow dr1 = dtUser.Rows[0]; SignUpV = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(dr1["usr_FistNam"]), LastNam = PLWM.Utils.CnvToStr(dr1["usr_LastNam"]), Email = PLWM.Utils.CnvToStr(dr1["usr_email"]), Mob = PLWM.Utils.CnvToStr(dr1["usr_phno"]), ZaBase = new BaseD() { ErrorMsg = "", ZaKey = Utils.GetKey(), } }; } } catch (Exception e) { SignUpV.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } } return(SignUpV); }
public ZA3630LD DoLoad(ZA3630SD FilterData, String Mode) { ZA3630LD UsageD = new ZA3630LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId), new XElement("as_mode", Mode), new XElement("as_email", FilterData.Email), new XElement("as_passwd", FilterData.Passwd), new XElement("ai_emp_job_mast_id", FilterData.UserData.ZaBase.PKID) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3630_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable NationalityDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable CurrentLocationDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable VisaStatusDt = PLWM.Utils.GetDataTable(ds, 2); System.Data.DataTable CarrierLevelDt = PLWM.Utils.GetDataTable(ds, 3); System.Data.DataTable CurrentSalaryDT = PLWM.Utils.GetDataTable(ds, 4); System.Data.DataTable WorkExperienceDT = PLWM.Utils.GetDataTable(ds, 5); System.Data.DataTable EducationLevelDT = PLWM.Utils.GetDataTable(ds, 6); System.Data.DataTable CommitmentDT = PLWM.Utils.GetDataTable(ds, 7); System.Data.DataTable IndustryDT = PLWM.Utils.GetDataTable(ds, 8); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 9); System.Data.DataTable dtJob = PLWM.Utils.GetDataTable(ds, 10); DataRow drUser = null; if (dtUser.Rows.Count > 0) { drUser = dtUser.Rows[0]; } UsageD.NationalityCol = new ZA3230DCol(); UsageD.NationalityCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Nationality" }); foreach (DataRow dr in NationalityDt.Rows) { UsageD.NationalityCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CurrentLocCol = new ZA3230DCol(); UsageD.CurrentLocCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Current Location" }); foreach (DataRow dr in CurrentLocationDt.Rows) { UsageD.CurrentLocCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.VisaStatusCol = new ZA3230DCol(); UsageD.VisaStatusCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Visa Status" }); foreach (DataRow dr in VisaStatusDt.Rows) { UsageD.VisaStatusCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CarrierLevelCol = new ZA3230DCol(); UsageD.CarrierLevelCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Carrier Level" }); foreach (DataRow dr in CarrierLevelDt.Rows) { UsageD.CarrierLevelCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CurrentSalaryCol = new ZA3230DCol(); UsageD.CurrentSalaryCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Current Salary" }); foreach (DataRow dr in CurrentSalaryDT.Rows) { UsageD.CurrentSalaryCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.WorkExperianceCol = new ZA3230DCol(); UsageD.WorkExperianceCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Work Experience" }); foreach (DataRow dr in WorkExperienceDT.Rows) { UsageD.WorkExperianceCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.EducationalLevelCol = new ZA3230DCol(); UsageD.EducationalLevelCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Education Level" }); foreach (DataRow dr in EducationLevelDT.Rows) { UsageD.EducationalLevelCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.CommitmentCol = new ZA3230DCol(); UsageD.CommitmentCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Commitment" }); foreach (DataRow dr in CommitmentDT.Rows) { UsageD.CommitmentCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } UsageD.IndustryCol = new ZA3230DCol(); UsageD.IndustryCol.Add(new ZA3230D() { EmpJobDtlId = -1, EmpJobValue = "Industry" }); foreach (DataRow dr in IndustryDT.Rows) { UsageD.IndustryCol.Add(new ZA3230D() { EmpJobDtlId = PLWM.Utils.CnvToNullableInt(dr["Emp_Job_Dtl_Id"]), EmpJobValue = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), }); } //UsageD.IndustryCol = new ZA3230DCol(); foreach (DataRow dr in dtJob.Rows) { UsageD.JobMast = new ZA3630SD() { FirstName = PLWM.Utils.CnvToStr(dr["FirstName"]), LastName = PLWM.Utils.CnvToStr(dr["LastName"]), Gender = PLWM.Utils.CnvToStr(dr["Gender"]), Title = PLWM.Utils.CnvToStr(dr["Title"]), Description = PLWM.Utils.CnvToStr(dr["Description"]), Mobile = PLWM.Utils.CnvToStr(dr["Mobile"]), Email = PLWM.Utils.CnvToStr(dr["Email"]), CurrentPos = PLWM.Utils.CnvToStr(dr["CurrentPos"]), NoticePeriod = PLWM.Utils.CnvToStr(dr["NoticePeriod"]), CurrentCompany = PLWM.Utils.CnvToStr(dr["CurrentCompany"]), // PhotoPath = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), // CvPath = PLWM.Utils.CnvToStr(dr["Emp_Job_Value"]), Nationality = UsageD.NationalityCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["Nationality_id"])), Industry = UsageD.IndustryCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["industry_id"])), CurrentLoc = UsageD.CurrentLocCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["CurrentLoc_id"])), VisaStatus = UsageD.VisaStatusCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["VisaStatus_id"])), CarrierLevel = UsageD.CarrierLevelCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["CarrierLevel_id"])), CurrentSalary = UsageD.CurrentSalaryCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["CurrentSalary_id"])), WorkExperiance = UsageD.WorkExperianceCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["WorkExperiance_id"])), EducationalLevel = UsageD.EducationalLevelCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["EducationalLevel_id"])), Commitment = UsageD.CommitmentCol.FirstOrDefault(x => x.EmpJobDtlId == PLWM.Utils.CnvToInt(dtJob.Rows[0]["Commitment_id"])), }; } UsageD.UserData = new ZA3000D() { ZaBase = new BaseD() { SessionId = PLWM.Utils.CnvToStr(drUser["SessionId"]), UserName = PLWM.Utils.CnvToStr(drUser["FirstName"]), ErrorMsg = "", ZaKey = Utils.GetKey() } }; } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3701LD DoLoad(ZA3701LD FilterData, String Mode) { ZA3701LD UsageD = new ZA3701LD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_motors_ad_mast_id", FilterData.MotorsAdMastId), new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId))); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3701_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable MotorDataDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable FileNamesDt = PLWM.Utils.GetDataTable(ds, 1); System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 2); UsageD.BodyType = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["BodyType"]); UsageD.Brand = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Brand"]); UsageD.Years = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Years"]); UsageD.Kmters = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Kmters"]); UsageD.Colors = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Colors"]); UsageD.Doors = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Doors"]); UsageD.Warenty = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Warenty"]); UsageD.RegionalSpecs = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["RegionalSpecs"]); UsageD.Transmisson = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Transmisson"]); UsageD.FuelType = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["FuelType"]); UsageD.SellerType = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["SellerType"]); UsageD.Cylinders = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Cylinders"]); UsageD.HoursePower = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["HoursePower"]); UsageD.Condition = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["condition"]); UsageD.UsrEmail = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["usr_email"]); UsageD.UsrPhno = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["usr_phno"]); UsageD.MotorDescription = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["mot_Description"]); UsageD.Location = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Location"]); UsageD.CrtdDt = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["crtd_dt"]); UsageD.Price = PLWM.Utils.CnvToStr(MotorDataDt.Rows[0]["Price"]); UsageD.FileNames = new ComDisValDCol(); foreach (DataRow Dr in FileNamesDt.Rows) { UsageD.FileNames.Add(new ComDisValD { DisPlyMembr = PLWM.Utils.CnvToStr(Dr["full_path"]), }); } if (UserDt.Rows.Count > 0) { UsageD.UserData = new ZA3000D() { FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]), ZaBase = new BaseD() { ZaKey = Utils.GetKey(), SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]), ErrorMsg = "", } }; } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3710ILD DoLoad(ZA3710LFD FilterData, String Mode) { ZA3710ILD UsageD = new ZA3710ILD(); try { XDocument doc = new XDocument(new XElement("Root", new XElement("as_mode", "LD"), new XElement("ai_pageno", FilterData.PageNo), new XElement("as_sessionid", ""), new XElement("as_Option", FilterData.Category.PropSpecDtlId), new XElement("as_location", FilterData.Location.ValMembr), new XElement("as_sortby", FilterData.SortBy.ValMembr) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3710_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable PageNoDt = PLWM.Utils.GetDataTable(ds, 1); UsageD.UserData = new ZA3000D() { ZaBase = new BaseD() { ZaKey = Utils.GetKey(), ErrorMsg = "" } }; UsageD.PropDataCol = new ZA3710BDCol(); foreach (DataRow Dr in ClasifiedDt.Rows) { UsageD.PropDataCol.Add(new ZA3710BD { Title = PLWM.Utils.CnvToStr(Dr["Prop_title"]), BedRoom = PLWM.Utils.CnvToStr(Dr["BedRoom"]), BathRoom = PLWM.Utils.CnvToStr(Dr["BathRoom"]), Email = PLWM.Utils.CnvToStr(Dr["usr_email"]), Location = PLWM.Utils.CnvToStr(Dr["Location"]), PhNo = PLWM.Utils.CnvToStr(Dr["usr_phno"]), PostDate = PLWM.Utils.CnvToStr(Dr["crtd_dt"]), ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]), Rate = PLWM.Utils.CnvToStr(Dr["Price"]), ISFurnised = PLWM.Utils.CnvToStr(Dr["Furnished"]), Area = PLWM.Utils.CnvToStr(Dr["size"]), PropAdMastId = PLWM.Utils.CnvToStr(Dr["prop_ad_mast_id"]), }); } UsageD.PageNoCol = new ComDisValDCol(); foreach (DataRow Dr in PageNoDt.Rows) { UsageD.PageNoCol.Add(new ComDisValD() { ValMembr = PLWM.Utils.CnvToInt(Dr["TotalPages"]), DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]), }); } } catch (Exception e) { UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(UsageD); }
public ZA3011LD DoLoadDeal(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_deal_mast_id", FilterData.DealMastId), new XElement("ai_pack_deal_mast_id", ""), new XElement("ai_pageno", FilterData.PageNo) )); 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); 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"]), Descrptn = PLWM.Utils.CnvToStr(dr["descrptn"]), Price = PLWM.Utils.CnvToStr(dr["price"]), StartDt = PLWM.Utils.CnvToStr(dr["start_dt"]), EndDt = PLWM.Utils.CnvToStr(dr["end_dt"]), }); } //System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0); //System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 1); //if (dtComn.Rows.Count > 0) //{ // SaveDataV.DealName = PLWM.Utils.CnvToStr(dtComn.Rows[0]["deal_name"]); // SaveDataV.Price = PLWM.Utils.CnvToStr(dtComn.Rows[0]["price"]); // SaveDataV.Descrptn = PLWM.Utils.CnvToStr(dtComn.Rows[0]["descrptn"]); // SaveDataV.StartDt = PLWM.Utils.CnvToStr(dtComn.Rows[0]["start_dt"]); // SaveDataV.EndDt = PLWM.Utils.CnvToStr(dtComn.Rows[0]["end_dt"]); //} //if (dtUser.Rows.Count > 0) //{ // SaveDataV.UserData = new ZA3000D() // { // FistNam = PLWM.Utils.CnvToStr(dtUser.Rows[0]["usr_FistNam"]), // ZaBase = new BaseD() // { // SessionId = PLWM.Utils.CnvToStr(dtUser.Rows[0]["sessionid"]), // } // }; //} } catch (Exception e) { SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim()); } return(SaveDataV); }