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