public CompanyRatingsDomain GetRatingAverageByCompanyId(int companyId) { CompanyRatingsDomain singleRating = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.CompanyRating_GetAvgByCompanyId" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@companyId", companyId); }, map : delegate(IDataReader reader, short set) { singleRating = new CompanyRatingsDomain(); int startingIndex = 0; //startingOrdinal singleRating.ratingAverage = reader.GetSafeDecimal(startingIndex++); }); } catch (Exception ex) { throw ex; } return(singleRating); }
public HttpResponseMessage GetAvgRatingById(int companyId) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } CompanyRatingsDomain averageRating = _CompanyRatingService.GetRatingAverageByCompanyId(companyId); var response = new ItemResponse <CompanyRatingsDomain> { Item = averageRating }; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public List <CompanyRatingsDomain> GetRatingsByCompanyId(int companyId) { List <CompanyRatingsDomain> ratingList = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.CompanyRating_GetByCompanyId" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@companyId", companyId); }, map : delegate(IDataReader reader, short set) { var singleRating = new CompanyRatingsDomain(); int startingIndex = 0; //startingOrdinal singleRating.CompanyRatingsId = reader.GetSafeInt32(startingIndex++); singleRating.companyId = reader.GetSafeInt32(startingIndex++); singleRating.rating = reader.GetSafeDecimal(startingIndex++); singleRating.ratingComment = reader.GetSafeString(startingIndex++); singleRating.raterId = reader.GetSafeString(startingIndex++); singleRating.createdDate = reader.GetSafeDateTime(startingIndex++); singleRating.reviewerFullName = reader.GetSafeString(startingIndex++); if (ratingList == null) { ratingList = new List <CompanyRatingsDomain>(); } ratingList.Add(singleRating); }); } catch (Exception ex) { throw ex; } return(ratingList); }