public ZA3710ILD DoDelete(ZA3710BD FilterData)
{
ZA3710ILD UsageD = new ZA3710ILD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("ai_prop_ad_mast_id", FilterData.PropAdMastId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3610_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 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 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("as_sessionid", FilterData.ZaBase.SessionId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA3710AD_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable PropDt = 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.PropDataCol = new ZA3710BDCol();
foreach (DataRow Dr in PropDt.Rows)
{
UsageD.PropDataCol.Add(new ZA3710BD
{
Title = PLWM.Utils.CnvToStr(Dr["Prop_title"]),
ProductImage = PLWM.Utils.CnvToStr(Dr["full_path"]),
Rate = PLWM.Utils.CnvToStr(Dr["Price"]),
PropAdMastId = PLWM.Utils.CnvToStr(Dr["prop_ad_mast_id"]),
});
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}