public ActionResult Edit(ConsignmentsModel modifiedModel, string FILTER_Keyword, int?FILTER_Active, Guid?FILTER_Branches_Id)
{
if (ModelState.IsValid)
{
if (isExists(modifiedModel.Id, modifiedModel.Name))
{
ModelState.AddModelError(ConsignmentsModel.COL_Name.Name, $"{modifiedModel.Name} sudah terdaftar");
}
else
{
ConsignmentsModel originalModel = get(modifiedModel.Id);
string log = string.Empty;
log = Helper.append(log, originalModel.Name, modifiedModel.Name, ConsignmentsModel.COL_Name.LogDisplay);
log = Helper.append(log, originalModel.Active, modifiedModel.Active, ConsignmentsModel.COL_Active.LogDisplay);
log = Helper.append(log, originalModel.Notes, modifiedModel.Notes, ConsignmentsModel.COL_Notes.LogDisplay);
log = Helper.append <BranchesModel>(log, originalModel.Branches_Id, modifiedModel.Branches_Id, ConsignmentsModel.COL_Branches_Id.LogDisplay);
if (!string.IsNullOrEmpty(log))
{
update(modifiedModel, log);
}
return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active, FILTER_Branches_Id = FILTER_Branches_Id }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active, FILTER_Branches_Id);
return(View(modifiedModel));
}
public void add(ConsignmentsModel model)
{
LIBWebMVC.WebDBConnection.Insert(db.Database, "Consignments",
DBConnection.getSqlParameter(ConsignmentsModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Name.Name, model.Name),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Active.Name, model.Active),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Notes.Name, model.Notes),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Branches_Id.Name, model.Branches_Id)
);
ActivityLogsController.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
}
public void update(ConsignmentsModel model, string log)
{
LIBWebMVC.WebDBConnection.Update(db.Database, "Consignments",
DBConnection.getSqlParameter(ConsignmentsModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Name.Name, model.Name),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Active.Name, model.Active),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Notes.Name, model.Notes),
DBConnection.getSqlParameter(ConsignmentsModel.COL_Branches_Id.Name, model.Branches_Id)
);
ActivityLogsController.AddEditLog(db, Session, model.Id, log);
db.SaveChanges();
}
public ActionResult Create(ConsignmentsModel model, string FILTER_Keyword, int?FILTER_Active, Guid?FILTER_Branches_Id)
{
if (ModelState.IsValid)
{
if (isExists(null, model.Name))
{
ModelState.AddModelError(ConsignmentsModel.COL_Name.Name, $"{model.Name} sudah terdaftar");
}
else
{
add(model);
return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active, FILTER_Branches_Id = FILTER_Branches_Id }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active, FILTER_Branches_Id);
return(View(model));
}
