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