// EDIT public ActionResult EditDriverGroup(DriverGroupModel driverGroup) { try { var results = driverGroupAdapter.EditDriverGroup(driverGroup); if (results != 1) { return(View("~/Views/Error/EnterAllInfoError.cshtml")); } return(RedirectToAction("ViewAllDriverGroups")); } catch { return(View("~/Views/Error/EnterAllInfoError.cshtml")); } }
// DELETE public ActionResult DeleteDriverGroup(DriverGroupModel deleteGroup) { try { var results = driverGroupAdapter.DeleteDriverGroup(deleteGroup); if (results != 1) { Log.Info($"Unable to Delete {deleteGroup.Name} -- results == {results}"); return(View("~/Views/Error/DeleteCourseTypeError.cshtml")); } return(RedirectToAction("ViewAllDriverGroups")); } catch { Log.Info($"Unable to Delete {deleteGroup.Name} in DriverGroupController --- Id == {deleteGroup.Id}"); return(View("~/Views/Error/DeleteDriverGroupError.cshtml")); } }
// DELETE public int DeleteDriverGroup(DriverGroupModel driverGroup) { Log.MethodStart(); try { var sql = @"DELETE from DRIVER_GROUP where ID = @ID"; var parameters = new List <Parameter> { new Parameter("@ID", driverGroup.Id) }; return(db.ExecNonQuery(sql, CommandType.Text, parameters)); } catch (Exception ex) { Log.Info($"Unable to Delete {driverGroup.Name} from DRIVER_GROUP Table --- {ex}"); Log.Error(ex); throw; } }
// EDIT public int EditDriverGroup(DriverGroupModel driverGroup) { Log.MethodStart(); try { var sql = @"Update DRIVER_GROUP set NAME = @NAME where ID = @ID"; var parameters = new List <Parameter> { new Parameter("@ID", driverGroup.Id), new Parameter("@NAME", driverGroup.Name) }; return(db.ExecNonQuery(sql, CommandType.Text, parameters)); } catch (Exception ex) { Log.Info($"Unable to Edit {driverGroup.Name} in DRIVER_GROUP Table --- {ex}"); Log.Error(ex); throw; } }
// ADD public int AddDriverGroup(DriverGroupModel newGroupName) { Log.MethodStart(); try { var sql = @"INSERT into DRIVER_GROUP (NAME) values (@NAME);"; var parameters = new List <Parameter> { new Parameter("@NAME", newGroupName.Name) }; return(db.ExecNonQuery(sql, CommandType.Text, parameters)); } catch (Exception ex) { Log.Info($"Unable to Add {newGroupName.Name} from DRIVER_GROUP --- {ex}"); Log.Error(ex); throw ex; } }
public ActionResult RedirectToEditDriverGroup(DriverGroupModel driverGroup) { return(View("~/Views/Admin/Edit/EditDriverGroup.cshtml", driverGroup)); }