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