/// <summary>
/// Add or Update Rating to a project
/// </summary>
/// <param name="ProjectId"></param>
/// <param name="Rating"></param>
/// <returns></returns>
public string AddRating(int ProjectId, string Rating, string ratingtype)
{
string returnStatus = "Success";
try
{
ProjectRating rating = (from rate in context.ProjectRatings where rate.projectId == ProjectId select rate).FirstOrDefault();
if (rating != null)
{
if (ratingtype == "P")
{
rating.rating = Rating;//1 for high, 2 for Optimum and 3 for Expensive.
}
if (ratingtype == "Q")
{
rating.QualityRating = Rating;
}
if (ratingtype == "R")
{
rating.UserRating = Rating;
}
}
else
{
ProjectRating projRating = new ProjectRating();
if (ratingtype == "i4irating")
{
projRating.projectId = ProjectId;
projRating.rating = Rating;
context.ProjectRatings.Add(projRating);
}
if (ratingtype == "Qualityrating")
{
projRating.projectId = ProjectId;
projRating.QualityRating = Rating;
context.ProjectRatings.Add(projRating);
}
if (ratingtype == "userrating")
{
projRating.projectId = ProjectId;
projRating.UserRating = Rating;
context.ProjectRatings.Add(projRating);
}
}
ProjectRatingHistory projHis = new ProjectRatingHistory();
projHis.ProjectId = ProjectId;
projHis.rating = Rating;
projHis.date = DateTime.Now;
context.ProjectRatingHistories.Add(projHis);
context.SaveChanges();
}
catch
{
returnStatus = "Fail";
}
return(returnStatus);
}
/// <summary>
/// Add or Update Rating to a project
/// </summary>
/// <param name="ProjectId"></param>
/// <param name="Rating"></param>
/// <returns></returns>
public string AddRating(int ProjectId, string Rating, string ratingtype)
{
string returnStatus = "Success";
try
{
ProjectRating rating = (from rate in context.ProjectRatings where rate.projectId == ProjectId select rate).FirstOrDefault();
if (rating != null)
{
if (ratingtype == "P")
{
rating.rating = Rating;//1 for high, 2 for Optimum and 3 for Expensive.
}
if (ratingtype == "Q")
{
rating.QualityRating = Rating;
}
if (ratingtype == "R")
{
rating.UserRating = Rating;
}
}
else
{
ProjectRating projRating = new ProjectRating();
if (ratingtype == "i4irating")
{
projRating.projectId = ProjectId;
projRating.rating = Rating;
context.ProjectRatings.Add(projRating);
}
if (ratingtype == "Qualityrating")
{
projRating.projectId = ProjectId;
projRating.QualityRating = Rating;
context.ProjectRatings.Add(projRating);
}
if (ratingtype == "userrating")
{
projRating.projectId = ProjectId;
projRating.UserRating = Rating;
context.ProjectRatings.Add(projRating);
}
}
ProjectRatingHistory projHis = new ProjectRatingHistory();
projHis.ProjectId = ProjectId;
projHis.rating = Rating;
projHis.date = DateTime.Now;
context.ProjectRatingHistories.Add(projHis);
context.SaveChanges();
}
catch
{
returnStatus = "Fail";
}
return returnStatus;
}
