//insert
//menerima view model dari view
public static bool insert(MRoleVM model)
{
bool result = false;
//simpan datanya ke model
using (AppEntity db = new AppEntity())
{
m_role item = new m_role()
{
id = model.id,
code = model.code,
name = model.name,
description = model.description,
is_active = true,
created_by = 1,
created_date = DateTime.Now,
updated_by = 1,
updated_date = DateTime.Now,
};
db.m_role.Add(item);
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
// delete
public static bool hiddenRole(int id)
{
var result = false;
MRoleVM data = MRoleRepo.getById(id);
using (AppEntity db = new AppEntity())
{
m_role item = db.m_role.Find(id);
item.is_active = false;
item.updated_by = 1;
item.updated_date = DateTime.Now;
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public ActionResult Edit(MRoleVM model)
{
if (ModelState.IsValid)
{
if (MRoleRepo.CekNama2(model) == true)
{
var result = new
{
success = false,
alertType = "error",
alertStrong = "Error!",
alertMessage = "Role name already used"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else if (MRoleRepo.CekNama2(model) == false)
{
MRoleRepo.Edit(model);
var result = new
{
success = true,
alertType = "info",
alertStrong = "Data Updated !",
alertMessage = "Data Role has been updated !"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(PartialView("_Edit", model));
}
public ActionResult Add(MRoleVM model)
{
if (ModelState.IsValid)
{
if (MRoleRepo.CekNama(model) == true)
{
var result = new
{
success = false,
alertType = "error",
alertStrong = "Error!",
alertMessage = "Role name already used"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else if (MRoleRepo.CekNama(model) == false)
{
MRoleRepo.insert(model);
var result = new
{
success = true,
alertType = "info",
alertStrong = "Data Saved !",
alertMessage = "New role has been added with code " + model.code + " !"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(PartialView("_Add", model));
}
public ActionResult Add()
{
MRoleVM model = new MRoleVM();
model.code = MRoleRepo.NewCode();
return(PartialView("_Add", model));
}
public static bool CekNama2(MRoleVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
var data = db.m_role.Where(x => x.name == model.name && x.is_active == true && x.id != model.id).ToList();
if (data.Count > 0)
{
result = true;
}
}
return(result);
}
// update
public static bool Edit(MRoleVM model)
{
bool result = false;
// simpan datanya ke model
using (AppEntity db = new AppEntity())
{
// get data dari database
m_role item = db.m_role.Find(model.id);
item.id = model.id;
item.code = model.code;
item.name = model.name;
item.description = model.description;
item.updated_by = 1;
item.updated_date = DateTime.Now;
try { db.SaveChanges(); result = true; }
catch (Exception) { throw; }
}
return(result);
}
// update
// get data by id
public static MRoleVM getById(int id)
{
MRoleVM result = new MRoleVM();
using (AppEntity db = new AppEntity())
{
result = db.m_role.Select(model => new MRoleVM()
{
id = model.id,
code = model.code,
name = model.name,
description = model.description,
is_active = model.is_active,
created_by = model.created_by,
created_date = model.created_date,
updated_by = model.updated_by,
updated_date = model.updated_date,
})
.Where(model => model.id == id)
.FirstOrDefault();
}
return(result);
}
public ActionResult Detail(int id)
{
MRoleVM role = MRoleRepo.getById(id);
return(PartialView("_Detail", role));
}
