public Response UpdateRateScore(LogRateSite data)
{
Response res = new Response();
string message = "Failed Update Rate Score";
bool result = false;
var dataRateScore = (from x in db.LogRateSite
where x.SiteID == data.SiteID
select x.RateScore).ToList();
if (dataRateScore != null && dataRateScore.Count > 0)
{
var rateScoreTotal = dataRateScore.Select(x => x).Sum();
var rateScoreAverage = rateScoreTotal / dataRateScore.Count;
var find = db.TitikLokasi.Where(x => x.ID == data.SiteID).FirstOrDefault();
if (find != null)
{
find.RateScoreAverage = rateScoreAverage;
find.RateScoreTotal = rateScoreTotal;
db.SaveChanges();
message = "Update data success";
result = true;
}
}
res.ID = data.ID;
res.Message = message;
res.Result = result;
return(res);
}
public Response Insert(LogRateSite data)
{
string message = "Failed";
bool result = false;
Response res = new Response();
try
{
if (data.ID == Guid.Empty)
{
data.ID = Guid.NewGuid();
db.Set <LogRateSite>().Add(data);
db.SaveChanges();
message = "Save data bank success";
result = true;
}
res.ID = data.ID;
res.Message = message;
res.Result = result;
return(res);
}
catch (Exception ex)
{
res.Message = ex.Message;
res.Result = false;
return(res);
}
}
public AddRateOutputModel Save(AddRateInputModel data)
{
RateRepository repo = new RateRepository(db);
AddRateOutputModel output = new AddRateOutputModel();
LogRateSite temp = new LogRateSite();
temp.SiteID = data.SiteID;
temp.RateScore = data.RateScore;
temp.UserID = data.UserID;
var res = repo.Insert(temp);
if (res.ID != Guid.Empty)
{
SiteRepository siteRepo = new SiteRepository(db);
var updateRes = siteRepo.UpdateRateScore(temp);
output.ID = updateRes.ID;
}
return(output);
}
