public ZA3010D DoLoad(ZA3010D FilterData, String Mode)
{
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("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);
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"]);
}
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);
}
public ZA3650SD DoSave(ZA3650SD SaveData, String Mode, long FileLength)
{
ZA3650SD UsageD = new ZA3650SD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("ai_compny_job_mast_id", SaveData.CompnyJobMastId),
new XElement("as_company_name", SaveData.CompnyName),
new XElement("as_trade_lic", SaveData.TradeLicns),
new XElement("as_contact_name", SaveData.ContctName),
new XElement("ai_industry", SaveData.Indstry.EmpJobDtlId),
new XElement("as_phone", SaveData.Phone),
new XElement("ai_company_size", SaveData.CompnySize.EmpJobDtlId),
new XElement("as_compny_website", SaveData.CompnyWebsit),
new XElement("as_adrs", SaveData.Addrs),
new XElement("as_dscrptn_step_one", SaveData.DescrpnStepOne),
new XElement("as_job_title", SaveData.JobTitle),
new XElement("ai_empl_type", SaveData.EmplymntTyp.EmpJobDtlId),
new XElement("ai_monthly_salry", SaveData.MonthlySalary.EmpJobDtlId),
new XElement("as_neighbrhd", SaveData.Neighbrhd),
new XElement("ai_exprnce", SaveData.Exprnce.EmpJobDtlId),
new XElement("ai_eductn_lvl", SaveData.EductnLvl.EmpJobDtlId),
new XElement("ai_listed_by", SaveData.ListedBy.EmpJobDtlId),
new XElement("ai_career_lvl", SaveData.CareerLvl.EmpJobDtlId),
new XElement("as_location", SaveData.Location),
new XElement("as_dscrptn_step_two", SaveData.DescrptnStepTwo),
new XElement("as_PhotoLength", FileLength)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3650_IU", XString, PLABSM.DbProvider.MSSql);
DataTable dt = PLWM.Utils.GetDataTable(ds, 0);
DataTable dt_id = PLWM.Utils.GetDataTable(ds, 1);
if (dt.Rows.Count > 0)
{
UsageD.PhotoPath = PLWM.Utils.CnvToStr(dt.Rows[0]["UsrFldrName"]);
}
if (dt_id.Rows.Count > 0)
{
UsageD.CompnyJobMastId = PLWM.Utils.CnvToInt(dt_id.Rows[0]["compny_job_mast_id"]);
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3011LD DoLoadA(ZA3011D FilterData, String Mode)
{
ZA3011LD SaveDataV = new ZA3011LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
//new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_pack_deal_mast_id", FilterData.PackDealMastId),
new XElement("ai_deal_mast_id", FilterData.DealMastId),
new XElement("as_mode", Mode)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_SEL", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable DealcolDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 1);
if (UserDt.Rows.Count > 0)
{
SaveDataV.UserData = new ZA3000D()
{
//UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]),
FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["usr_FistNam"]),
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]),
},
};
}
foreach (DataRow dr in DealcolDt.Rows)
{
SaveDataV.Dealcol.Add(new ZA3011D()
{
DealMastId = PLWM.Utils.CnvToInt(dr["deal_mast_id"]),
PackDealMastId = PLWM.Utils.CnvToInt(dr["pack_deal_mast_id"]),
DealName = PLWM.Utils.CnvToStr(dr["deal_name"]),
Price = PLWM.Utils.CnvToStr(dr["price"]),
StartDt = PLWM.Utils.CnvToStr(dr["start_dt"]),
EndDt = PLWM.Utils.CnvToStr(dr["end_dt"]),
Descrptn = PLWM.Utils.CnvToStr(dr["descrptn"]),
});
}
}
catch (Exception e)
{
SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SaveDataV);
}
//DoLoadData
public ZA2011LD DoLoadData(ZA2010D FilterData, String Mode)
{
ZA2011LD UsageD = new ZA2011LD();
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("ZA2010_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable SilDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable GoldDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable PlatDt = PLWM.Utils.GetDataTable(ds, 2);
foreach (DataRow dr in SilDt.Rows)
{
UsageD.SilverCol.Add(new ZA2011D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlanValue = PLWM.Utils.CnvToStr(dr["plan_value"]),
});
}
foreach (DataRow dr in GoldDt.Rows)
{
UsageD.GoldCol.Add(new ZA2011D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlanValue = PLWM.Utils.CnvToStr(dr["plan_value"]),
});
}
foreach (DataRow dr in PlatDt.Rows)
{
UsageD.PlatinumCol.Add(new ZA2011D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlanValue = PLWM.Utils.CnvToStr(dr["plan_value"]),
});
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3631RPD DoLoad(ZA3631RPD FilterData, String Mode)
{
ZA3631RPD JobWantDet = new ZA3631RPD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
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("ZA3671_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["frelnc_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"]),
};
}
}
catch (Exception e)
{
JobWantDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(JobWantDet);
}
//DeleteProduct
public JobsmyaddsLD DeleteJob(JobsmyaddsD FilterData)
{
JobsmyaddsLD UsageD = new JobsmyaddsLD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("ai_job_mast_id", FilterData.EmpJobMastId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
if (FilterData.JobType == "JW")
{
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3630_Del", XString, PLABSM.DbProvider.MSSql);
}
else if (FilterData.JobType == "JH")
{
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3650_Del", XString, PLABSM.DbProvider.MSSql);
}
else if (FilterData.JobType == "FW")
{
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3670_Del", XString, PLABSM.DbProvider.MSSql);
}
else if (FilterData.JobType == "FH")
{
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3680_Del", XString, PLABSM.DbProvider.MSSql);
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3000D DoLoad(ZA3000D FilterData, String Mode)
{
ZA3000D SignUpV = new ZA3000D();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_otp", FilterData.Otp),
new XElement("as_Email", FilterData.Email),
new XElement("as_Passwd", FilterData.Passwd),
new XElement("ai_usr_mast_id", FilterData.UsrMastID),
new XElement("ai_SessionId", FilterData.ZaBase.SessionId),
new XElement("as_mode", Mode)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3000_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 1);
if (dtComn.Rows.Count > 0)
{
System.Data.DataRow dr1 = dtComn.Rows[0];
SignUpV = new ZA3000D()
{
UsrMastID = PLWM.Utils.CnvToNullableInt(dr1["usr_mast_id"]),
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()
{
SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]),
UserName = PLWM.Utils.CnvToStr(dr1["usr_FistNam"]),
ErrorMsg = "",
ZaKey = Utils.GetKey()
}
};
}
}
catch (Exception e)
{
SignUpV.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SignUpV);
}
public ZA3630SD DoSave(ZA3630SD SaveData, String Mode, long FileLength)
{
ZA3630SD UsageD = new ZA3630SD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_emp_job_mast_id", SaveData.EmpJobMastID),
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_FirstName", SaveData.FirstName),
new XElement("as_LastName", SaveData.LastName),
new XElement("as_Gender", SaveData.Gender),
new XElement("as_Nationality_id", SaveData.Nationality.EmpJobDtlId),
new XElement("as_Title", SaveData.Title),
new XElement("as_Description", SaveData.Description),
new XElement("as_Mobile", SaveData.Mobile),
new XElement("as_Email", SaveData.Email),
new XElement("as_CurrentLoc_id", SaveData.CurrentLoc.EmpJobDtlId),
new XElement("as_CurrentCompany", SaveData.CurrentCompany),
new XElement("as_CurrentPos", SaveData.CurrentPos),
new XElement("as_NoticePeriod", SaveData.NoticePeriod),
new XElement("as_VisaStatus_id", SaveData.VisaStatus.EmpJobDtlId),
new XElement("as_CarrierLevel_id", SaveData.CarrierLevel.EmpJobDtlId),
new XElement("as_CurrentSalary_id", SaveData.CurrentSalary.EmpJobDtlId),
new XElement("as_WorkExperiance_id", SaveData.WorkExperiance.EmpJobDtlId),
new XElement("as_EducationalLevel_id", SaveData.EducationalLevel.EmpJobDtlId),
new XElement("as_Commitment_id", SaveData.Commitment.EmpJobDtlId),
new XElement("as_Industry_id", SaveData.Industry.EmpJobDtlId),
new XElement("as_PhotoLength", FileLength)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3630_IU", XString, PLABSM.DbProvider.MSSql);
DataTable dt = PLWM.Utils.GetDataTable(ds, 0);
if (dt.Rows.Count > 0)
{
UsageD.PhotoPath = PLWM.Utils.CnvToStr(dt.Rows[0]["UsrFldrName"]);
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3600LD DoSave(ZA3600SD SaveData, String Mode)
{
ZA3600LD MotorSpecD = new ZA3600LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_Year", SaveData.Year.MotorSpecDtlId),
new XElement("as_Colour", SaveData.Colour.MotorSpecDtlId),
new XElement("as_Doors", SaveData.Doors.MotorSpecDtlId),
new XElement("as_Warranty", SaveData.Warranty.MotorSpecDtlId),
new XElement("as_RegionalSpecs", SaveData.RegionalSpecs.MotorSpecDtlId),
new XElement("as_Transmisson", SaveData.Transmisson.MotorSpecDtlId),
new XElement("as_BodyType", SaveData.BodyType.MotorSpecDtlId),
new XElement("as_FuelType", SaveData.FuelType.MotorSpecDtlId),
new XElement("as_Cylinders", SaveData.Cylinders.MotorSpecDtlId),
new XElement("as_SellerType", SaveData.SellerType.MotorSpecDtlId),
new XElement("as_Brand", SaveData.Brand.MotorSpecDtlId),
new XElement("as_HoursePower", SaveData.HoursePower.MotorSpecDtlId),
new XElement("as_Title", SaveData.Title),
new XElement("as_KiloMetrs", SaveData.KiloMetrs),
new XElement("as_Description", SaveData.Description),
new XElement("as_MotorsADMastID", SaveData.MotorsADMastID),
new XElement("as_ConditionID", SaveData.Condition.MotorSpecDtlId)));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3600_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable MotorData = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable MotorFileData = PLWM.Utils.GetDataTable(ds, 1);
if (MotorData.Rows.Count > 0)
{
DataRow Dr = MotorData.Rows[0];
MotorSpecD.MotorsADMastID = PLWM.Utils.CnvToNullableInt(Dr["MotorsADMastID"]);
MotorSpecD.UserData.ZaBase.SessionId = PLWM.Utils.CnvToStr(Dr["sessionid"]);
MotorSpecD.UserData.ZaBase.ErrorMsg = "";
}
}
catch (Exception e)
{
MotorSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(MotorSpecD);
}
public ZA2010LD DoSubscribe(ZA2010D FilterData, String Mode)
{
ZA2010LD UsageD = new ZA2010LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.ZaBase.SessionId),
new XElement("as_EmailID", FilterData.ZaBase.UserName),
new XElement("ai_Otp", FilterData.ZaBase.PKID),
new XElement("as_Pkg", FilterData.ZaBase.Fld)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA2010_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable SilDt = PLWM.Utils.GetDataTable(ds, 0);
if (SilDt.Rows.Count > 0)
{
String Otp = PLWM.Utils.CnvToStr(SilDt.Rows[0]["OTP"]);
String UserName = PLWM.Utils.CnvToStr(SilDt.Rows[0]["UserEmail"]);
String Message = GetSmsEmailFormats.GetSubscriptionEmail(Otp, UserName);
Utils.SendEmail(Message, "*****@*****.**", "Please find the otp in this email for activation of Subscription", "Zeroori", "Zeroori Active");
UsageD.Otp = Otp;
UsageD.UserAccount = Otp;
}
else
{
UsageD.UserData = new ZA3000D()
{
ZaBase = new BaseD()
{
ErrorMsg = "Invalid Operation"
},
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3641RPD DoLoadFrelncListDetails(ZA3641RPD FilterData, String Mode)
{
ZA3641RPD FrelncDet = new ZA3641RPD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_com_job_mast_id", FilterData.ComJobMast.CompanyJobMastId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3681_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable FrelncColDt = PLWM.Utils.GetDataTable(ds, 1);
foreach (DataRow dr in FrelncColDt.Rows)
{
FrelncDet.ComJobMast = new ZA3640D()
{
CompanyJobMastId = PLWM.Utils.CnvToStr(dr["frelnc_comp_job_mast_id"]),
CompanyName = PLWM.Utils.CnvToStr(dr["comp_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"]),
};
}
}
catch (Exception e)
{
FrelncDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(FrelncDet);
}
public ZA3610LD DoSave(ZA3610SD SaveData, String Mode)
{
ZA3610LD PropSpecD = new ZA3610LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_bed_room", SaveData.Bedroom.PropSpecDtlId),
new XElement("as_bath_room", SaveData.BathRoom.PropSpecDtlId),
new XElement("as_size", SaveData.Size.PropSpecDtlId),
new XElement("as_is_Furnished", SaveData.Furnished.PropSpecDtlId),
new XElement("as_apartment_for", SaveData.ApartmentFor.PropSpecDtlId),
new XElement("as_Rent_Is_Paid", SaveData.RentIsPaid.PropSpecDtlId),
new XElement("as_listed_by", SaveData.ListedBy.PropSpecDtlId),
new XElement("as_Category", SaveData.Category.PropSpecDtlId),
new XElement("as_title", SaveData.Title),
new XElement("as_Description", SaveData.Description),
new XElement("as_PropADMastID", SaveData.PropADMastID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3610_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable MotorData = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable MotorFileData = PLWM.Utils.GetDataTable(ds, 1);
if (MotorData.Rows.Count > 0)
{
DataRow Dr = MotorData.Rows[0];
PropSpecD.PropADMastID = PLWM.Utils.CnvToNullableInt(Dr["PropADMastID"]);
PropSpecD.UserData.ZaBase.SessionId = PLWM.Utils.CnvToStr(Dr["sessionid"]);
PropSpecD.UserData.ZaBase.ErrorMsg = "";
}
}
catch (Exception e)
{
PropSpecD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(PropSpecD);
}
public ZA3011D DoSave(ZA3011D FilterData, String Mode)
{
ZA3011D SaveDataV = new ZA3011D();
if (FilterData.DealMastId > 0)
{
Mode = "U";
}
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_packdeal_mast_id", FilterData.PackDealMastId),
new XElement("ai_deal_mast_id", FilterData.DealMastId),
new XElement("as_deal_name", FilterData.DealName),
new XElement("an_price", FilterData.Price),
new XElement("as_descrptn", FilterData.Descrptn),
new XElement("ad_start_dt", FilterData.StartDt),
new XElement("ad_end_dt", FilterData.EndDt)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0);
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"]);
}
}
catch (Exception e)
{
SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SaveDataV);
}
public ZA3620LD DoSave(ZA3620SD SaveData, String Mode)
{
ZA3620LD UsageD = new ZA3620LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", SaveData.UserData.ZaBase.SessionId),
new XElement("as_Category", SaveData.Category.ClasifdSpecDtlId),
new XElement("as_Sub_Category", SaveData.SubCategory.ClasifdSpecDtlId),
new XElement("as_Age", SaveData.Age.ClasifdSpecDtlId),
new XElement("as_Usage", SaveData.Usage.ClasifdSpecDtlId),
new XElement("as_Condition", SaveData.Condition.ClasifdSpecDtlId),
new XElement("as_Warranty", SaveData.Warranty.ClasifdSpecDtlId),
new XElement("as_title", SaveData.Title),
new XElement("as_Description", SaveData.Description),
new XElement("as_clasifdADMastID", SaveData.ClasifdADMastID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3620_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable MotorData = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable MotorFileData = PLWM.Utils.GetDataTable(ds, 1);
if (MotorData.Rows.Count > 0)
{
DataRow Dr = MotorData.Rows[0];
UsageD.ClasifdADMastID = PLWM.Utils.CnvToNullableInt(Dr["clasifdADMastID"]);
UsageD.UserData.ZaBase.SessionId = PLWM.Utils.CnvToStr(Dr["sessionid"]);
UsageD.UserData.ZaBase.ErrorMsg = "";
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
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 ZA3500D DoLoad(ZA3000D FilterData, String Mode)
{
ZA3500D SignUpV = new ZA3500D();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.ZaBase.SessionId),
new XElement("as_mode", Mode)));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3500_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 ZA3500D()
{
UserData = new ZA3000D()
{
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(dr1["SessionId"]),
UserName = PLWM.Utils.CnvToStr(dr1["FirstName"]),
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 ZA3661DD DoLoadDirDetail(ZA3661DD FilterData, String Mode)
{
ZA3661DD DirDet = new ZA3661DD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("ai_pageno", ""),
new XElement("ai_dir_dtl_id", FilterData.DirMast.DirDtlId),
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 DirDt = PLWM.Utils.GetDataTable(ds, 0);
foreach (DataRow dr in DirDt.Rows)
{
DirDet.DirMast = 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"]),
Fax = PLWM.Utils.CnvToStr(dr["fax"]),
Web = PLWM.Utils.CnvToStr(dr["web"]),
};
}
}
catch (Exception e)
{
DirDet.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(DirDet);
}
public ZA3621SD DoRemove(ZA3621SD FilterData, String Mode)
{
ZA3621SD SignUpV = new ZA3621SD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_clasifdADMastID", FilterData.AddclasifdADMastID),
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)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3621_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable dtComn = PLWM.Utils.GetDataTable(ds, 0);
if (dtComn.Rows.Count > 0)
{
SignUpV.FileNames = new ComDisValDCol();
foreach (DataRow dr in dtComn.Rows)
{
SignUpV.FileNames.Add(new ComDisValD()
{
Descriptn = PLWM.Utils.CnvToStr(dr["clasifd_img_fldr_full_path"])
});
}
}
}
catch (Exception e)
{
SignUpV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return SignUpV;
}
//DeleteProduct
public ZA3720ILD DeleteProduct(ZA3620SD FilterData)
{
ZA3720ILD UsageD = new ZA3720ILD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("ai_clasifdad_mast_id", FilterData.ClasifdADMastID)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3620AD_Del", XString, PLABSM.DbProvider.MSSql);
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA3011LD DoDelete(ZA3011D FilterData, String Mode)
{
ZA3011LD SaveDataV = new ZA3011LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("ai_deal_mast_id", FilterData.DealMastId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3011_DEL", XString, PLABSM.DbProvider.MSSql);
}
catch (Exception e)
{
SaveDataV.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(SaveDataV);
}
public ZA3800D DoLoad(ZA3800D FilterData, String Mode)
{
ZA3800D UsageD = new ZA3800D();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_sessionid", FilterData.UserData.ZaBase.SessionId),
new XElement("as_mode", Mode)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3800_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable Dt = PLWM.Utils.GetDataTable(ds, 0);
foreach (DataRow dr in Dt.Rows)
{
UsageD = new ZA3800D()
{
MotorsCount = PLWM.Utils.CnvToNullableInt(dr["motors_count"]),
PropertiesCount = PLWM.Utils.CnvToNullableInt(dr["prop_count"]),
ClasiifiedsCount = PLWM.Utils.CnvToNullableInt(dr["clasfds_count"]),
JobCountJW = PLWM.Utils.CnvToNullableInt(dr["jobs_JW_counts"]),
JobCountJH = PLWM.Utils.CnvToNullableInt(dr["jobs_JH_counts"]),
JobCountFW = PLWM.Utils.CnvToNullableInt(dr["jobs_FW_counts"]),
JobCountFH = PLWM.Utils.CnvToNullableInt(dr["jobs_FH_counts"]),
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA2010LD DoLoad(ZA2010D FilterData, String Mode)
{
ZA2010LD UsageD = new ZA2010LD();
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("ZA2010_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable SilDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable GoldDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable PlatDt = PLWM.Utils.GetDataTable(ds, 2);
System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 3);
foreach (DataRow dr in SilDt.Rows)
{
UsageD.SilverMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
foreach (DataRow dr in GoldDt.Rows)
{
UsageD.GoldMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
foreach (DataRow dr in PlatDt.Rows)
{
UsageD.PlatinumMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
UsageD.UserData = new ZA3000D();
foreach (DataRow Dr in UserDt.Rows)
{
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"]),
},
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
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 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("ai_pageno", FilterData.PageNo),
new XElement("as_sessionid", ""),
new XElement("as_Option", FilterData.Catagory.MotorSpecDtlId),
new XElement("as_location", FilterData.Location.ValMembr < 0?null: FilterData.Location.ValMembr),
new XElement("as_sortby", FilterData.SortBy.ValMembr < 0?null:FilterData.SortBy.ValMembr),
new XElement("ai_model", FilterData.Model.MotorSpecDtlId < 0?null:FilterData.Model.MotorSpecValue),
new XElement("ai_fuelType", FilterData.FuelType.MotorSpecDtlId < 0 ? null : FilterData.FuelType.MotorSpecValue),
new XElement("ai_color", FilterData.Color.MotorSpecDtlId < 0 ? null : FilterData.Color.MotorSpecValue),
new XElement("ai_bodyType", FilterData.BodyType.MotorSpecDtlId < 0 ? null : FilterData.BodyType.MotorSpecValue)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3700_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("ai_pageno", ""),
new XElement("as_sessionid", FilterData.ZaBase.SessionId),
new XElement("as_Option", ""),
new XElement("as_location", ""),
new XElement("as_sortby", 2),
new XElement("ai_model", ""),
new XElement("ai_fuelType", ""),
new XElement("ai_color", ""),
new XElement("ai_bodyType", "")
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3700_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable MotorDt = 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 LocationDt = PLWM.Utils.GetDataTable(ds, 3);
System.Data.DataTable SortByDt = PLWM.Utils.GetDataTable(ds, 4);
System.Data.DataTable BodyTypeDt = PLWM.Utils.GetDataTable(ds, 5);
System.Data.DataTable BrandDt = PLWM.Utils.GetDataTable(ds, 6);
System.Data.DataTable ModelDt = PLWM.Utils.GetDataTable(ds, 7);
System.Data.DataTable FuelTypeDt = PLWM.Utils.GetDataTable(ds, 8);
System.Data.DataTable ColorDt = PLWM.Utils.GetDataTable(ds, 9);
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"]),
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.LocationCol = new ComDisValDCol();
UsageD.LocationCol.Add(new ComDisValD()
{
DisPlyMembr = "Location", ValMembr = -1
});
foreach (DataRow Dr in LocationDt.Rows)
{
UsageD.LocationCol.Add(new ComDisValD()
{
DisPlyMembr = PLWM.Utils.CnvToStr(Dr["place_name"]),
ValMembr = PLWM.Utils.CnvToInt(Dr["city_mast_id"]),
});
}
UsageD.SortByCol = new ComDisValDCol();
UsageD.SortByCol.Add(new ComDisValD()
{
DisPlyMembr = "Sort 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.BrandCol = new ZA3200DCol();
foreach (DataRow Dr in BrandDt.Rows)
{
UsageD.BrandCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToInt(Dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(Dr["motor_spec_value"]),
MotorSpecImgPath = PLWM.Utils.CnvToStr(Dr["motor_spec_img_path"])
});
}
UsageD.ModelCol = new ZA3200DCol();
UsageD.ModelCol.Add(new ZA3200D()
{
MotorSpecValue = "Model", MotorSpecDtlId = -1
});
foreach (DataRow Dr in ModelDt.Rows)
{
UsageD.ModelCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToInt(Dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(Dr["motor_spec_value"]),
});
}
UsageD.FuelTypeCol = new ZA3200DCol();
UsageD.FuelTypeCol.Add(new ZA3200D()
{
MotorSpecValue = "Fuel Type", MotorSpecDtlId = -1
});
foreach (DataRow Dr in FuelTypeDt.Rows)
{
UsageD.FuelTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToInt(Dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(Dr["motor_spec_value"]),
});
}
UsageD.BodyTypeCol = new ZA3200DCol();
UsageD.BodyTypeCol.Add(new ZA3200D()
{
MotorSpecValue = "Body Type", MotorSpecDtlId = -1
});
foreach (DataRow Dr in BodyTypeDt.Rows)
{
UsageD.BodyTypeCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToInt(Dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(Dr["motor_spec_value"]),
});
}
UsageD.ColorCol = new ZA3200DCol();
UsageD.ColorCol.Add(new ZA3200D()
{
MotorSpecValue = "Colour", MotorSpecDtlId = -1
});
foreach (DataRow Dr in ColorDt.Rows)
{
UsageD.ColorCol.Add(new ZA3200D()
{
MotorSpecDtlId = PLWM.Utils.CnvToInt(Dr["motor_spec_dtl_id"]),
MotorSpecValue = PLWM.Utils.CnvToStr(Dr["motor_spec_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 ZA3710ILD DoInit(ZA3000D FilterData, String Mode)
{
ZA3710ILD UsageD = new ZA3710ILD();
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("ZA3710_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable PropDt = 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.PropDataCol = new ZA3710BDCol();
foreach (DataRow Dr in PropDt.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.LocationCol = new ComDisValDCol();
UsageD.LocationCol.Add(new ComDisValD()
{
DisPlyMembr = "Location", ValMembr = -1
});
foreach (DataRow Dr in LocationDt.Rows)
{
UsageD.LocationCol.Add(new ComDisValD()
{
DisPlyMembr = PLWM.Utils.CnvToStr(Dr["place_name"]),
ValMembr = PLWM.Utils.CnvToInt(Dr["city_mast_id"]),
});
}
UsageD.SortByCol = new ComDisValDCol();
UsageD.SortByCol.Add(new ComDisValD()
{
DisPlyMembr = "Sort 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 ZA3210DCol();
foreach (DataRow Dr in CatagoryDt.Rows)
{
UsageD.CatagoryCol.Add(new ZA3210D()
{
PropSpecDtlId = PLWM.Utils.CnvToInt(Dr["Prop_dtl_id"]),
PropSpecValue = PLWM.Utils.CnvToStr(Dr["Prop_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 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 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 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 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);
}