public ActionResult EditStaff(Staff staff)
{
using (var context = new StaffDbContext())
{
if (staff.Id > 0)
{
// Edit
var val = context.Staffs.Where(data => data.Id == staff.Id).FirstOrDefault();
if (val != null)
{
val.Name = staff.Name;
val.Age = staff.Age;
val.City = staff.City;
}
}
else
{
//Save
context.Staffs.Add(staff);
}
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult CreateStaff(Staff new_staff)
{
using (var context = new StaffDbContext())
{
context.Staffs.Add(new_staff);
//saving changes
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
//-------------------------
// Editing
//-------------------------
public ActionResult EditStaff(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
using (var context = new StaffDbContext())
{
var staff = context.Staffs.Where(data => data.Id == id).FirstOrDefault();
return(View(staff));
}
}
// GET: Staff
public ActionResult Index()
{
// The Using Statement used
using (var context = new StaffDbContext())
{
//selecting all data input in the database
var allstaff = (from data in context.Staffs select data).ToList();
return(View(allstaff));
}
}
public ActionResult ConfirmDeleteStaff(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
using (var context = new StaffDbContext())
{
var value = context.Staffs.Where(data => data.Id == id).FirstOrDefault();
context.Staffs.Remove(value);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Login(Staff objUser)
{
if (ModelState.IsValid)
{
using (StaffDbContext db = new StaffDbContext()) {
var obj = db.Staffs.Where(a => a.StaffUsername.Equals(objUser.StaffUsername) && a.StaffPassword.Equals(objUser.StaffPassword)).FirstOrDefault();
if (obj != null)
{
Session["StaffId"] = obj.StaffId.ToString();
Session["StaffUsername"] = obj.StaffUsername.ToString();
return(RedirectToAction("Menu"));
}
}
}
return(View(objUser));
}
public StaffService(StaffDbContext context)
{
this.context = context;
}
public HomeController(StaffDbContext context)
{
_context = context;
}
public StaffRepository(StaffDbContext db)
{
dbCpntext = db;
entities = dbCpntext.Set <T>();
}
