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(); }