// TODO! Прочитать про параметры
private void CreateDbContext()
{
DbContext = new MunicipalityContext();
DbContext.Configuration.LazyLoadingEnabled = false;
DbContext.Configuration.ValidateOnSaveEnabled = false;
}
public ActionResult Index()
{
using (
var ctx = new MunicipalityContext())
{
var model = ctx.Municipalitites.Include(m => m.Valuations).ToList();
return(View(model));
}
}
public ActionResult ViewMunicipalityValuations(int?id)
{
Municipality model = new Municipality();
using (var ctx = new MunicipalityContext())
{
model = ctx.Municipalitites.Include(m => m.Valuations).FirstOrDefault(m => m.MunicipalityId == id);
}
return(View(model));
}
public JsonResult DeleteMunicipalityValuations(int?id)
{
MunicipalityContext ctx = new MunicipalityContext();
MunicipalityValuation data = (from valuation in ctx.MunicipalityValuations
where valuation.MunicipalityValuationId == id
select valuation).SingleOrDefault();
ctx.MunicipalityValuations.Remove(data);
ctx.SaveChanges();
return(Json("Record Deleted Successfully", JsonRequestBehavior.AllowGet));
}
public ActionResult AddValuation(MunicipalityValuation model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var ctx = new MunicipalityContext())
{
ctx.MunicipalityValuations.Add(model);
ctx.SaveChanges();
}
return(RedirectToAction("ViewMunicipalityValuations", new { id = model.MunicipalityId }));
}
// [HttpPost]
public ActionResult EditValuation(int?id)
{
MunicipalityContext ctx = new MunicipalityContext();
MunicipalityValuation data = (from valuation in ctx.MunicipalityValuations
where valuation.MunicipalityValuationId == id
select valuation).SingleOrDefault();
ctx.MunicipalityValuations.Find(id);
return(PartialView("~/Views/Shared/_EditValuation.cshtml", data));
}
public ActionResult AddMunicipality(Municipality model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var ctx = new MunicipalityContext())
{
ctx.Municipalitites.Add(model);
ctx.SaveChanges();
}
return(RedirectToAction("Index"));
}
