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