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