// DELETE: Employee
public ActionResult DeleteEmployee([DataSourceRequest] DataSourceRequest request, LoginPage_tblEmployee emp)
{
try
{
LoginPage_tblEmployee employee = db.LoginPage_tblEmployee.Find(emp.EmployeeID);
if (employee == null)
{
return(Json("Employee Not Found"));
}
db.LoginPage_tblEmployee.Remove(employee);
db.SaveChanges();
return(Json(db.LoginPage_tblEmployee.ToList()));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
// UPDATE: Employee
public ActionResult UpdateEmployee([DataSourceRequest] DataSourceRequest request, LoginPage_tblEmployee emp)
{
try
{
if (ModelState.IsValid)
{
db.Entry(emp).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(Json(new[] { emp }.ToDataSourceResult(request, ModelState)));
}
else
{
return(Json(db.LoginPage_tblEmployee.ToList()));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
// ADD: Employee
public ActionResult AddEmployee([DataSourceRequest] DataSourceRequest request, LoginPage_tblEmployee emp)
{
try
{
if (ModelState.IsValid)
{
db.LoginPage_tblEmployee.Add(emp);
db.SaveChanges();
var _emplist = db.LoginPage_tblEmployee.ToList();
return(Json(new[] { emp }.ToDataSourceResult(request, ModelState)));
}
else
{
return(Json(db.LoginPage_tblEmployee.ToList()));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
