public ClsEnquire GetEnquiryDetails(string prEnquireId)
{
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("EnquireId", prEnquireId);
DataTable lcResult = ClsDbConnection.GetDataTable("SELECT * FROM Enquire INNER JOIN PropertyInfo " +
"ON Enquire.PropertyId = PropertyInfo.PropertyId AND Enquire.EnquireId = @EnquireId", par);
if (lcResult.Rows.Count > 0)
{
return new ClsEnquire()
{
EnquireId = Convert.ToInt16(lcResult.Rows[0]["EnquireId"]),
PropertyAddress = Convert.ToString(lcResult.Rows[0]["PropertyAddress"]),
EnquireName = Convert.ToString(lcResult.Rows[0]["EnquireName"]),
EnquirePh = Convert.ToString(lcResult.Rows[0]["EnquirePh"]),
EnquirePrice = Convert.ToDecimal(lcResult.Rows[0]["EnquirePrice"]),
EnquireDate = Convert.ToDateTime(lcResult.Rows[0]["EnquireDate"])
}
}
;
else
{
return(null);
}
}
public ClsRegion GetRegion(string RegionName)
{
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("RegionName", RegionName);
DataTable lcResult =
ClsDbConnection.GetDataTable("SELECT * FROM RegionInfo WHERE RegionName = @RegionName", par);
if (lcResult.Rows.Count > 0)
{
return new ClsRegion()
{
RegionName = (string)lcResult.Rows[0]["RegionName"],
RealtorName = (string)lcResult.Rows[0]["RealtorName"],
RealtorLocation = (string)lcResult.Rows[0]["RealtorLocation"],
RealtorPh = (string)lcResult.Rows[0]["ContactPh"],
PropertyList = getRegionProperties(RegionName)
}
}
;
else
{
return(null);
}
}
public List <string> GetRegionNames()
{
DataTable lcResult = ClsDbConnection.GetDataTable("SELECT RegionName FROM RegionInfo", null);
List <string> lcRegionNames = new List <string>();
foreach (DataRow dr in lcResult.Rows)
{
lcRegionNames.Add((string)dr[0]);
}
return(lcRegionNames);
}
private List <ClsAllProperties> getRegionProperties(string RegionName)
{
Dictionary <string, object> par = new Dictionary <string, object>(1);
par.Add("RegionName", RegionName);
DataTable lcResult = ClsDbConnection.GetDataTable
("SELECT * FROM PropertyInfo WHERE RegionName = @RegionName", par);
List <ClsAllProperties> lcProperty = new List <ClsAllProperties>();
foreach (DataRow dr in lcResult.Rows)
{
lcProperty.Add(dataRow2AllProperties(dr));
}
return(lcProperty);
}
public List <ClsEnquire> GetEnquiries()
{
DataTable lcResult = ClsDbConnection.GetDataTable("SELECT * FROM Enquire INNER JOIN PropertyInfo " +
"ON Enquire.PropertyId = PropertyInfo.PropertyId", null);
List <ClsEnquire> lcEnquire = new List <ClsEnquire>();
foreach (DataRow dr in lcResult.Rows)
{
lcEnquire.Add(new ClsEnquire
{
EnquireId = Convert.ToInt16(dr["EnquireId"]),
PropertyAddress = Convert.ToString(dr["PropertyAddress"]),
EnquireName = Convert.ToString(dr["EnquireName"]),
EnquirePh = Convert.ToString(dr["EnquirePh"]),
EnquirePrice = Convert.ToDecimal(dr["EnquirePrice"]),
EnquireDate = Convert.ToDateTime(dr["EnquireDate"])
});
}
return(lcEnquire);
}