public DataTable GetResidentialProperties() { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetResidentialProperties"; objMSSqlHelper.Parameters.Add(new SqlParameter("@MLSID_City_PostalCode", MLSID_City_PostalCode)); objMSSqlHelper.Parameters.Add(new SqlParameter("@PropertyType", PropertyType)); objMSSqlHelper.Parameters.Add(new SqlParameter("@MinPrice", MinPrice)); objMSSqlHelper.Parameters.Add(new SqlParameter("@MaxPrice", MaxPrice)); objMSSqlHelper.Parameters.Add(new SqlParameter("@BedRooms", BedRooms)); objMSSqlHelper.Parameters.Add(new SqlParameter("@BathRooms", BathRooms)); objMSSqlHelper.Parameters.Add(new SqlParameter("@SaleLease", SaleLease)); DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable IsExistEmail(string emailID) { DataTable dt = new DataTable(); try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); objMSSqlHelper.Parameters.Add(new SqlParameter("@EmailId", emailID)); dt = objMSSqlHelper.ExecuteDataSet("IsExistEmail").Tables[0]; } catch (Exception ex) { throw ex; } return(dt); }
//its for web public DataTable GetAllImagesByVID(string Gid) { DataTable dt = new DataTable(); try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); objMSSqlHelper.Parameters.Add(new SqlParameter("@Vid", Gid)); dt = objMSSqlHelper.ExecuteDataSet("GetAllImagesByVID").Tables[0]; } catch (Exception ex) { throw ex; } return(dt); }
public DataTable LoginCheck(string emailid, string Password) { DataTable dt = new DataTable(); try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); objMSSqlHelper.Parameters.Add(new SqlParameter("@EmailId", emailid)); objMSSqlHelper.Parameters.Add(new SqlParameter("@Password", Password)); dt = objMSSqlHelper.ExecuteDataSet("SpLoginCheck").Tables[0]; } catch (Exception ex) { throw ex; } return(dt); }
public DataTable GetFeatures() { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "sp_Features"; DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetAutoCompleteData_Condo(string City_PostalCode) { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); objMSSqlHelper.Parameters.Add(new SqlParameter("@City_PostalCode", City_PostalCode)); DataTable dt = objMSSqlHelper.ExecuteDataSet("GetSearchList_Condo").Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetSaleLease_Residential() { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetSaleLease_Residential"; DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetPropertyTypes_Condo() { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetPropertyTypes_Condo"; DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetIsValidMLS(string mlsid) { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetIsValidMLSID"; objMSSqlHelper.Parameters.Add(new SqlParameter("@MLSID", mlsid)); DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable FeatureListingTop3(string MlsIDs) { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetFeatureListingByMLSIDsTop3"; objMSSqlHelper.Parameters.Add(new SqlParameter("@MLSID", MlsIDs)); DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetAllOrSingleVirtualRecord(string Gid, int userid, int startindex, int endindex) { DataTable dt = new DataTable(); try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); objMSSqlHelper.Parameters.Add(new SqlParameter("@Vid", Gid)); objMSSqlHelper.Parameters.Add(new SqlParameter("@UserID", userid)); objMSSqlHelper.Parameters.Add(new SqlParameter("@StartIndex", startindex)); objMSSqlHelper.Parameters.Add(new SqlParameter("@EndIndex", endindex)); dt = objMSSqlHelper.ExecuteDataSet("SpGetAllTourDetails").Tables[0]; } catch (Exception ex) { throw ex; } return(dt); }
public DataTable GetAllVirtualTourImagesData(int startindex, int pagesize) { DataTable result; try { MSSqlHelper objMSSqlHelper = new MSSqlHelper(); string strQuery = "GetAllVirtualTourData"; objMSSqlHelper.Parameters.Add(new SqlParameter("@StartIndex", startindex)); objMSSqlHelper.Parameters.Add(new SqlParameter("@PageSize", pagesize)); DataTable dt = objMSSqlHelper.ExecuteDataSet(strQuery).Tables[0]; result = dt; } catch (Exception ex) { throw ex; } return(result); }