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