public ActionResult Add(mUnitVM model)
{
if (ModelState.IsValid)
{
if (mUnitRepo.cekNama(model) == true)
{
var result = new
{
success = false,
alertType = "error",
alertStrong = "Error!",
alertMessage = "Unit name " + model.name + " already exists!"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
mUnitRepo.insert(model);
var result = new
{
success = true,
alertType = "info",
alertStrong = "Data Saved!",
alertMessage = "New Unit has been added with code (" + model.code + ")"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(PartialView("_Add", model));
}
//ADD
public ActionResult Add()
{
mUnitVM model = new mUnitVM();
model.code = mUnitRepo.newCode();
return(PartialView("_Add", model));
}
public ActionResult Edit(mUnitVM model)
{
if (ModelState.IsValid)
{
if (mUnitRepo.cekNama(model) == true)
{
var result = new
{
success = false,
alertType = "error",
alertStrong = "Error!",
alertMessage = "Unit name " + model.name + " already exists!"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
mUnitRepo.update(model);
var result = new
{
success = true,
alertType = "info",
alertStrong = "Updated!",
alertMessage = "Data unit has been updated!"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(PartialView("_Edit", model));
}
public ActionResult Search(mUnitVM model)
{
var data = new List <mUnitVM>();
if (data.Count == 0 && model.code == null && model.name == null && model.createdDate == DateTime.MinValue && model.createdBy == 0)
{
data = mUnitRepo.get();
}
else
{
data = mUnitRepo.Search(model);
}
return(PartialView("_List", data));
}
public static bool cekNama(mUnitVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
var data = db.m_unit
.Where(x => x.name == model.name && x.id != model.id).ToList();
if (data.Count > 0)
{
result = true;
}
}
return(result);
}
// update
public static bool update(mUnitVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_unit item = db.m_unit.Find(model.id);
item.code = model.code;
item.name = model.name;
item.description = model.description;
item.updated_by = 2;
item.updated_date = DateTime.Now.Date;
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
// delete
public static bool HideUnit(int id)
{
var result = false;
mUnitVM data = mUnitRepo.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 static List <mUnitVM> Search(mUnitVM model)
{
var data = new List <mUnitVM>();
using (AppEntity db = new AppEntity())
{
data = db.m_unit.Select(x => new mUnitVM()
{
id = x.id,
code = x.code,
name = x.name,
description = x.description,
isActive = x.is_active,
createdBy = x.created_by,
createdDate = x.created_date,
}).Where(x => (x.isActive == true) && (x.code.Contains(model.code) || x.name.Contains(model.name)) || (x.createdDate.Day == model.createdDate.Day && x.createdDate.Month == model.createdDate.Month && x.createdDate.Year == model.createdDate.Year))
.ToList();
}
return(data);
}
public static bool insert(mUnitVM model)
{
bool result = false;
using (AppEntity db = new AppEntity())
{
m_unit item = new m_unit()
{
code = model.code,
name = model.name,
description = model.description,
is_active = true,
created_by = 1,
created_date = DateTime.Now.Date,
updated_by = 1,
updated_date = DateTime.Now.Date,
};
db.m_unit.Add(item);
try { db.SaveChanges(); result = true; } catch (Exception) { throw; }
}
return(result);
}
// get data by id
public static mUnitVM getById(int id)
{
mUnitVM result = new mUnitVM();
using (AppEntity db = new AppEntity())
{
result = db.m_unit.Select(x => new mUnitVM()
{
id = x.id,
code = x.code,
name = x.name,
description = x.description,
isActive = x.is_active,
createdBy = x.created_by,
createdDate = x.created_date,
updatedBy = x.updated_by,
updated_date = x.updated_date,
})
.Where(x => x.id == id)
.FirstOrDefault();
}
return(result);
}
