public ZA3630LD DoLoadFrelncListDetail(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("ai_pageno", "") //new XElement("as_passwd", FilterData.Passwd) )); String XString = doc.ToString(); PLABSM.DAL dbObj = new PLABSM.DAL(); dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB; DataSet ds = dbObj.SelectSP("ZA3670_sel", XString, PLABSM.DbProvider.MSSql); System.Data.DataTable dt = PLWM.Utils.GetDataTable(ds, 0); System.Data.DataTable dtUser = PLWM.Utils.GetDataTable(ds, 1); //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 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 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); }