public IActionResult Get(int id) { Sightseen sightseen = appCtx.Sightseens.FirstOrDefault(s => s.Id == id); if (sightseen != null) { return(Json(sightseen)); } return(BadRequest(new { errorText = "Invalid username or password." })); }
public IActionResult DeleteSightseen(int id) { Sightseen ss = appCtx.Sightseens.FirstOrDefault(s => s.Id == id); if (ss != null) { appCtx.Sightseens.Remove(ss); appCtx.SaveChanges(); return(Ok()); } return(BadRequest(new { errorText = "Invalid SightseenId" })); }
public IActionResult EditSightseen(SightseenModel ssm) { Sightseen ss = appCtx.Sightseens.FirstOrDefault(s => s.Id == ssm.Id); if (ss != null) { ss.Name = ssm.Name == null ? ss.Name : ssm.Name; ss.Point = new Point { X = ssm.X == null? ss.Point.X : (float)ssm.X, Y = ssm.Y == null ? ss.Point.Y : (float)ssm.Y }; ss.Discription = ssm.Discription == null ? ss.Discription : ssm.Discription; appCtx.Entry(ss).State = Microsoft.EntityFrameworkCore.EntityState.Modified; appCtx.SaveChanges(); return(Ok()); } return(BadRequest(new { errorText = "Invalid SightseenId" })); }
public IActionResult AddSightseen([FromBody] SightseenModel ssm) { Sightseen ss = new Sightseen { BaseRate = 0, Count = 0, Discription = ssm.Discription, ImagePath = ssm.ImagePath, Name = ssm.Name, Point = new Point { X = (float)ssm.X, Y = (float)ssm.Y }, Type = "sightseen" }; appCtx.Sightseens.Add(ss); appCtx.SaveChanges(); return(Ok()); }
public void Rate(int Sightseenid, int rate) { Sightseen sightseen = appCtx.Sightseens.FirstOrDefault(s => s.Id == Sightseenid); User user = (User)HttpContext.Items["User"]; if (user.Statistics.Rates.Where(s => s.SightseenId == Sightseenid).FirstOrDefault() == null) { UserRate ur = new UserRate { StatisticsId = (int)user.StatisticsId, Rate = rate, SightseenId = sightseen.Id, Sightseen = sightseen }; user.Statistics.Rates.Add(ur); sightseen.Count++; sightseen.BaseRate += rate; } else { sightseen.BaseRate -= (int)user.Statistics.Rates.Where(s => s.SightseenId == Sightseenid).FirstOrDefault().Rate; sightseen.BaseRate += rate; } user.Statistics.Rates.Where(s => s.SightseenId == Sightseenid).FirstOrDefault().Rate = rate; appCtx.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified; appCtx.Entry(sightseen).State = Microsoft.EntityFrameworkCore.EntityState.Modified; appCtx.SaveChanges(); }