public ActionResult DeleteConfirmed(int id, audit_trail audit)
{
var check = db.employees.Where(s => s.Employee_Type_ID == id).FirstOrDefault();
if (check == null)
{
employee_type employee_type = db.employee_type.Find(id);
var userId = System.Web.HttpContext.Current.Session["UserID"] as String;
int IntID = Convert.ToInt32(userId);
audit.Employee_ID = IntID;
audit.Trail_DateTime = DateTime.Now.Date;
audit.Deleted_Record = employee_type.Employee_Type_ID.ToString() + " " + employee_type.Type_Name + " " + employee_type.Type_Description;
audit.Trail_Description = "Deleted a Employee Type";
db.audit_trail.Add(audit);
db.employee_type.Remove(employee_type);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
employee_type employee_type = db.employee_type.Find(id);
ViewBag.Error = "Can't delete a type that is in-use please add a new type instead, or delete all employees related to this type first.";
return(View(employee_type));
}
}
public ActionResult DeleteConfirmed(int id)
{
employee_type employee_type = db.employee_type.Find(id);
db.employee_type.Remove(employee_type);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type)
{
if (ModelState.IsValid)
{
db.Entry(employee_type).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee_type));
}
public ActionResult Create([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type)
{
if (ModelState.IsValid)
{
db.employee_type.Add(employee_type);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee_type));
}
// GET: employee_type/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
employee_type employee_type = db.employee_type.Find(id);
if (employee_type == null)
{
return(HttpNotFound());
}
return(View(employee_type));
}
public ActionResult Edit([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type)
{
bool val = db.employee_type.Any(s => s.Type_Name == employee_type.Type_Name && s.Employee_Type_ID != employee_type.Employee_Type_ID);
if (ModelState.IsValid && val == false)
{
db.Entry(employee_type).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already an: " + employee_type.Type_Name + " type in the database.";
return(View());
}
return(View(employee_type));
}
public ActionResult Create([Bind(Include = "Employee_Type_ID,Type_Name,Type_Description")] employee_type employee_type)
{
bool val = Validate(employee_type.Type_Name);
if (ModelState.IsValid && val == false)
{
db.employee_type.Add(employee_type);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (val == true)
{
ViewBag.StatusMessage = "There is already an: " + employee_type.Type_Name + " type in the database.";
return(View());
}
return(View(employee_type));
}
public void AddEmployeeType()
{
employee_type empType = new employee_type();
AddEmployeeType addWindow = new AddEmployeeType();
addWindow.DataContext = new { employeeType = empType };
addWindow.ShowDialog();
try
{
dataHandler.AddOrUpdate(empType);
}
catch (Exception e)
{
System.Windows.MessageBox.Show("Error: " + e.Message);
}
NotifyOfPropertyChange("EmployeeTypes");
}
public void Modify(employee_type empType)
{
AddEmployeeType addWindow = new AddEmployeeType();
addWindow.DataContext = new { employeeType = empType };
if (addWindow.ShowDialog() == true)
{
try
{
dataHandler.AddOrUpdate(empType);
}
catch (Exception e)
{
System.Windows.MessageBox.Show("Error: " + e.Message);
}
}
else
{
((System.Data.Entity.Infrastructure.IObjectContextAdapter)dataHandler.GetEntities()).ObjectContext.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, empType);
}
NotifyOfPropertyChange("EmployeeTypes");
}
public void Delete(employee_type obj)
{
dataHandler.RemoveData(obj);
NotifyOfPropertyChange("EmployeeTypes");
}
