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