public JsonResult DeleteStat(int id)
{
bool bReturn = false;
string message = "failed";
EResStat myStat = _db.EResStats.Find(id);
if (myStat != null)
{
EResStat deletedStat = _db.EResStats.Remove(myStat);
if (deletedStat != null)
{
try
{
if (_db.SaveChanges() > 0)
{
bReturn = true;
message = "success";
}
}
catch (Exception ex)
{
message = ex.Message;
}
}
}
return(Json(new
{
Success = bReturn,
Message = message
}, JsonRequestBehavior.AllowGet));
}
public JsonResult CreateStat(EResStatViewModel viewModel)
{
bool bReturn = false;
string message = "failed";
// TODO: Add insert logic here
EResStat newStat = new EResStat()
{
DatabaseID = viewModel.DatabaseID,
Year = viewModel.Year,
Month = viewModel.Month,
Searches = viewModel.Searches,
Downloads = viewModel.Downloads,
LinkedTo = viewModel.LinkedTo,
LinkedFrom = viewModel.LinkedFrom
};
if (_db.EResStats.Add(newStat) != null)
{
if (_db.SaveChanges() > 0)
{
bReturn = true;
message = "success";
}
}
return(Json(new
{
Success = bReturn,
Message = message
}, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateStat(EResStatViewModel viewModel)
{
bool bReturn = false;
string message = "failed";
EResStat myStat = _db.EResStats.Find(viewModel.StatID);
if (myStat != null)
{
myStat.DatabaseID = viewModel.DatabaseID;
myStat.Year = viewModel.Year;
myStat.Month = viewModel.Month;
myStat.Searches = viewModel.Searches;
myStat.Downloads = viewModel.Downloads;
myStat.LinkedTo = viewModel.LinkedTo;
myStat.LinkedFrom = viewModel.LinkedFrom;
try
{
_db.SaveChanges();
bReturn = true;
message = "success";
}
catch (InvalidOperationException ex)
{
message = ex.Message;
}
}
return(Json(new
{
Success = bReturn,
Message = message
}, JsonRequestBehavior.AllowGet));
}