public JsonResult DeleteDB(int DatatabseID)
{
try
{
var database = new QueryDBAppEntities1();
EPIDatabases dbDetail = database.EPIDatabases.Find(DatatabseID);
database.EPIDatabases.Remove(dbDetail);
database.SaveChanges();
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult UpdateDB(EPIDatabases DBModel)
{
try
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }));
}
var database = new QueryDBAppEntities1();
database.Entry(DBModel).State = EntityState.Modified;
database.SaveChanges();
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult CreateDB(EPIDatabases DBModel)
{
try
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }));
}
var database = new QueryDBAppEntities1();
database.EPIDatabases.Add(DBModel);
database.SaveChanges();
return(Json(new { Result = "OK", Record = DBModel }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
