public ActionResult Add(MEmployeeVM model)
{
ViewBag.ListCompany = new SelectList(MCompanyRepo.get(), "id", "name");
if (ModelState.IsValid)
{
if (MEmployeeRepo.HitungEmplo(model) == true)
{
var result = new
{
success = true,
alertType = "warning",
alertStrong = "Error!",
alertMessage = "Employee number already used"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else if (MEmployeeRepo.HitungEmplo(model) == false)
{
MEmployeeRepo.insert(model);
var result = new
{
success = false,
alertType = "success",
alertStrong = "Data Saved !",
alertMessage = "New Employee has been add with employee ID number" + model.employee_number
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(PartialView("_Add", model));
}
public ActionResult Edit(MEmployeeVM model)
{
ViewBag.ListCompany = new SelectList(MEmployeeRepo.get(), "id", "name");
if (MEmployeeRepo.HitungEmplo(model) == true)
{
var result = new
{
success = true,
alertType = "warning",
alertStrong = "Error!",
alertMessage = "Employee number already used"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else if (MEmployeeRepo.HitungEmplo(model) == false)
{
MEmployeeRepo.update(model);
var result = new
{
success = false,
alertType = "success",
alertStrong = "Data Updated !",
alertMessage = "Data Updated! Data employee has been Updated"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(PartialView(model));
}
public ActionResult Add()
{
MEmployeeVM model = new MEmployeeVM();
ViewBag.ListCompany = new SelectList(MCompanyRepo.get(), "id", "name");
ViewBag.Title = "Add";
return(PartialView("_Add", model));
}
public ActionResult Edit(int id)
{
ViewBag.ListCompany = new SelectList(MCompanyRepo.get(), "id", "name");
MEmployeeVM model = MEmployeeRepo.getbyid(id);
ViewBag.Title = "Edit Company-" + model.first_name + model.last_name + "(" + model.employee_number + ")";
return(PartialView(model));
}
public ActionResult Detail(int id)
{
MEmployeeVM model = MEmployeeRepo.GetDetail(id);
ViewBag.Title = "View Company-" + model.first_name + model.last_name + "(" + model.employee_number + ")";
return(PartialView(model));
}
public ActionResult Delete(int id)
{
MEmployeeVM model = MEmployeeRepo.getbyid(id);
MEmployeeRepo.Delete(id);
var result = new
{
success = true,
alertType = "info",
alertStrong = "Data Deleted !",
alertMessage = "Data Deleted! Data Company With Employee ID Number" + model.employee_number + "Has been deleted"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static bool HitungEmplo(MEmployeeVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
var data = db.m_employee.Where(x => x.employee_number == model.employee_number && x.id != model.id).ToList();
{
if (data.Count > 0)
{
result = true;
}
}
}
return(result);
}
public static MEmployeeVM getDataById(int id)
{
MEmployeeVM hasil = new MEmployeeVM();
using (AppEntities db = new AppEntities())
{
hasil = db.m_employee
.Include("m_company")
.Select(x => new MEmployeeVM()
{
id = x.id,
company = x.m_company.name
})
.Where(x => x.id == id)
.FirstOrDefault();
}
return(hasil);
}
public static bool update(MEmployeeVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_employee item = db.m_employee.Find(model.id);
item.employee_number = model.employee_number;
item.first_name = model.first_name;
item.last_name = model.last_name;
item.m_company_id = model.m_company_id;
item.email = model.email;
item.is_active = true;
item.created_by = 1;
item.created_date = DateTime.Now;
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
public static MEmployeeVM getbyid(int id)
{
MEmployeeVM hasil = new MEmployeeVM();
using (AppEntity db = new AppEntity())
{
hasil = db.m_employee.Select(x => new MEmployeeVM()
{
id = x.id,
employee_number = x.employee_number,
first_name = x.first_name,
last_name = x.last_name,
m_company_id = x.m_company_id,
NmCompany = x.m_company.name,
email = x.email,
created_by = x.created_by,
created_date = x.created_date,
FullName = x.first_name + " " + x.last_name
}).Where(x => x.id == id).FirstOrDefault();
}
return(hasil);
}
public static bool insert(MEmployeeVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_employee item = new m_employee()
{
employee_number = model.employee_number,
first_name = model.first_name,
last_name = model.last_name,
m_company_id = model.m_company_id,
email = model.email,
is_active = true,
created_by = 1,
created_date = DateTime.Now
};
db.m_employee.Add(item);
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
