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