public List <BrokerListingsModel> GetLatestBrokerListingDetailsForHomePage()
{
var _db = new DBUtility();
var token = new List <BrokerListingsModel>();
var _dt = new DataTable();
_cmd = new SqlCommand();
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "GP_SP_GetLatestListingsDetailsForHomePage";
_dt = _db.FillDataTable(_cmd, _dt);
if (_dt.Rows.Count > 0)
{
foreach (DataRow dr in _dt.Rows)
{
var temp = new BrokerListingsModel();
temp.ID = Convert.ToInt32(dr["ID"]);
temp.Name = Convert.ToString(dr["Name"]);
temp.Description = Convert.ToString(dr["Description"]);
temp.AmountRequired = Convert.ToDouble(dr["AmountRequired"]);
temp.ImagePath = Convert.ToString(dr["ImagePath"]);
temp.IsSponsored = Convert.ToBoolean(dr["IsSponsored"]);
temp.ListingType = Convert.ToString(dr["ListingType"]);
temp.ListingStatus = Convert.ToString(dr["ListingStatus"]);
temp.Location = Convert.ToString(dr["Location"]);
token.Add(temp);
}
}
return(token);
}
public List <BrokerListingsModel> GetBrokerListingDetails(Hashtable listingsCriteria)
{
var _db = new DBUtility();
var token = new List <BrokerListingsModel>();
var _dt = new DataTable();
_cmd = new SqlCommand();
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "GP_SP_GetBrokerListings";
if (string.IsNullOrWhiteSpace(Convert.ToString(listingsCriteria["UserID"])))
{
_cmd.Parameters.AddWithValue("@UserId", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@UserId", Convert.ToString(listingsCriteria["UserID"]).Trim());
}
_dt = _db.FillDataTable(_cmd, _dt);
if (_dt.Rows.Count > 0)
{
foreach (DataRow dr in _dt.Rows)
{
var temp = new BrokerListingsModel();
temp.ID = Convert.ToInt32(dr["ID"]);
temp.Name = Convert.ToString(dr["Name"]);
temp.Description = Convert.ToString(dr["Description"]);
temp.AmountRequired = Convert.ToDouble(dr["AmountRequired"]);
temp.ImagePath = Convert.ToString(dr["ImagePath"]);
temp.IsSponsored = Convert.ToBoolean(dr["IsSponsored"]);
temp.ListingType = Convert.ToString(dr["ListingType"]);
temp.ListingStatus = Convert.ToString(dr["ListingStatus"]);
temp.Location = Convert.ToString(dr["Location"]);
temp.MessageCount = Convert.ToInt32(dr["MessageCount"]);
token.Add(temp);
}
}
return(token);
}
