public ActionResult Edit(LessonPackagesModel modifiedModel, string FILTER_Keyword, int?FILTER_Active, Guid?FILTER_Languages_Id, Guid?FILTER_LessonTypes_Id)
{
if (ModelState.IsValid)
{
if (isExists(modifiedModel.Id, modifiedModel.Name))
{
ModelState.AddModelError(LessonPackagesModel.COL_Name.Name, $"{modifiedModel.Name} sudah terdaftar");
}
else
{
LessonPackagesModel originalModel = get(modifiedModel.Id);
string log = string.Empty;
log = Helper.append(log, originalModel.Name, modifiedModel.Name, LessonPackagesModel.COL_Name.LogDisplay);
log = Helper.append(log, originalModel.Active, modifiedModel.Active, LessonPackagesModel.COL_Active.LogDisplay);
log = Helper.append <LanguagesModel>(log, originalModel.Languages_Id, modifiedModel.Languages_Id, LessonPackagesModel.COL_Languages_Id.LogDisplay);
log = Helper.append <LessonTypesModel>(log, originalModel.LessonTypes_Id, modifiedModel.LessonTypes_Id, LessonPackagesModel.COL_LessonTypes_Id.LogDisplay);
log = Helper.append(log, originalModel.SessionHours, modifiedModel.SessionHours, LessonPackagesModel.COL_SessionHours.LogDisplay);
log = Helper.append(log, originalModel.ExpirationMonth, modifiedModel.ExpirationMonth, LessonPackagesModel.COL_ExpirationMonth.LogDisplay);
log = Helper.append(log, originalModel.Price, modifiedModel.Price, LessonPackagesModel.COL_Price.LogDisplay);
log = Helper.append(log, originalModel.Notes, modifiedModel.Notes, LessonPackagesModel.COL_Notes.LogDisplay);
log = Helper.append(log, originalModel.IsClubSubscription, modifiedModel.IsClubSubscription, LessonPackagesModel.COL_IsClubSubscription.LogDisplay);
if (!string.IsNullOrEmpty(log))
{
update(modifiedModel, log);
}
return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active, FILTER_Languages_Id = FILTER_Languages_Id, FILTER_LessonTypes_Id = FILTER_LessonTypes_Id }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active, FILTER_Languages_Id, FILTER_LessonTypes_Id);
return(View(modifiedModel));
}
public ActionResult Create(LessonPackagesModel model, string FILTER_Keyword, int?FILTER_Active, Guid?FILTER_Languages_Id, Guid?FILTER_LessonTypes_Id)
{
if (ModelState.IsValid)
{
if (isExists(null, model.Name))
{
ModelState.AddModelError(LessonPackagesModel.COL_Name.Name, $"{model.Name} sudah terdaftar");
}
else
{
add(model);
return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active, FILTER_Languages_Id = FILTER_Languages_Id, FILTER_LessonTypes_Id = FILTER_LessonTypes_Id }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active, FILTER_Languages_Id, FILTER_LessonTypes_Id);
return(View(model));
}
public void add(LessonPackagesModel model)
{
LIBWebMVC.WebDBConnection.Insert(db.Database, "LessonPackages",
DBConnection.getSqlParameter(LessonPackagesModel.COL_Id.Name, model.Id),
DBConnection.getSqlParameter(LessonPackagesModel.COL_Name.Name, model.Name),
DBConnection.getSqlParameter(LessonPackagesModel.COL_Active.Name, model.Active),
DBConnection.getSqlParameter(LessonPackagesModel.COL_Notes.Name, model.Notes),
DBConnection.getSqlParameter(LessonPackagesModel.COL_Languages_Id.Name, model.Languages_Id),
DBConnection.getSqlParameter(LessonPackagesModel.COL_LessonTypes_Id.Name, model.LessonTypes_Id),
DBConnection.getSqlParameter(LessonPackagesModel.COL_SessionHours.Name, model.SessionHours),
DBConnection.getSqlParameter(LessonPackagesModel.COL_ExpirationMonth.Name, model.ExpirationMonth),
DBConnection.getSqlParameter(LessonPackagesModel.COL_Price.Name, model.Price),
DBConnection.getSqlParameter(LessonPackagesModel.COL_IsClubSubscription.Name, model.IsClubSubscription)
);
ActivityLogsController.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
}
