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