public ViewResult AllEmployees()
{
var context = new LnTTrainingEntities();
var model = context.EmpTables.ToList();
return(View(model));
}
public ViewResult Delete(string id)
{
var empId = int.Parse(id);
var context = new LnTTrainingEntities();
var model = context.EmpTables.FirstOrDefault((e) => e.EmpID == empId);
return(View(model));
}
public ActionResult NewEmployee(EmpTable emp)
{
var context = new LnTTrainingEntities();
context.EmpTables.Add(emp);
context.SaveChanges();
return(RedirectToAction("AllEmployees"));
}
public ActionResult Find(EmpTable emp)
{
var context = new LnTTrainingEntities();
var model = context.EmpTables.FirstOrDefault((e) => e.EmpID == emp.EmpID);
model.EmpName = emp.EmpName;
model.EmpAddress = emp.EmpAddress;
model.EmpSalary = emp.EmpSalary;
context.SaveChanges();//Commits the changes made to the records...
return(RedirectToAction("AllEmployees"));
}
public ActionResult Delete(string id, string conformbutton)
{
//convert string to int
int empId = int.Parse(id);
var context = new LnTTrainingEntities();
var model = context.EmpTables.FirstOrDefault((e) => e.EmpID == empId);
context.EmpTables.Remove(model);
context.SaveChanges();
Console.WriteLine("Thank you!");
return(RedirectToAction("AllEmployees"));
}
