// EDIT
public int EditAssignedCourseToDriver(DriverLinkCourseModel updatedEntry)
{
Log.MethodStart();
try
{
string sql = @"UPDATE LINK_DRIVER_COURSE Set PRIORITY = @PRIORITY, ASSIGNED_DATETIME = @ASSIGNED_DATETIME, DUE_DATE = @DUE_DATE
Where ID = @ID";
List <Parameter> parameters = new List <Parameter>
{
new Parameter("@ID", updatedEntry.Id),
new Parameter("@PRIORITY", updatedEntry.SelectedPriorityId),
new Parameter("@ASSIGNED_DATETIME", DateTime.UtcNow.ToLocalTime()),
new Parameter("@DUE_DATE", updatedEntry.Due_Date)
};
return(database.ExecNonQuery(sql, CommandType.Text, parameters));
}
catch (Exception ex)
{
Log.Info($"Unable to Edit {updatedEntry.Course.Title} at {updatedEntry.Id} in LINK_DRIVER_COURSE Table --- {ex}");
Log.Error(ex);
throw;
}
}
public DriverLinkCourseModel AssignCourseToDriver(CourseModel selectedCourse, DriverModel driver, CourseConfigModel config)
{
try
{
var newEntry = new DriverLinkCourseModel()
{
User_Id = driver.Id,
DriverId = driver.DriverId,
Driver_Group_Id = driver.Driver_Group_Id,
Course_Id = selectedCourse.Id,
Course_Type = selectedCourse.Course_Type,
Title = selectedCourse.Title,
State = Assigned,
Priority = config.Priority,
Required = config.Required,
Reactivate_Training = config.Reactivate_Training,
Hidden_Course = selectedCourse.Hidden_Course,
Assigned_Datetime = DateTime.Now
};
return(newEntry);
}
catch (Exception ex)
{
Log.Trace(ex.ToString());
throw;
}
}
// ADD
public int AssignCourseToDriver(DriverLinkCourseModel assignToDriver)
{
Log.MethodStart();
try
{
string sql = @"Insert into LINK_DRIVER_COURSE (USER_ID, DRIVER_ID, COURSE_ID, STATE, PRIORITY, ASSIGNED_DATETIME, DUE_DATE, CREATED_DATETIME)
values (@USER_ID, @DRIVER_ID, @COURSE_ID, @STATE, @PRIORITY, @ASSIGNED_DATETIME, @DUE_DATE, @CREATED_DATETIME)";
List <Parameter> parameters = new List <Parameter>
{
new Parameter("@USER_ID", assignToDriver.User_Id),
new Parameter("@DRIVER_ID", assignToDriver.SelectedDriverId),
new Parameter("@COURSE_ID", assignToDriver.SelectedCourseId),
new Parameter("@STATE", assignToDriver.State),
new Parameter("@PRIORITY", assignToDriver.SelectedPriorityId),
new Parameter("@ASSIGNED_DATETIME", DateTime.UtcNow),
new Parameter("@DUE_DATE", assignToDriver.Due_Date),
new Parameter("@CREATED_DATETIME", DateTime.UtcNow)
};
//var test = database.ExecNonQuery(sql, CommandType.Text, parameters);
return(database.ExecNonQuery(sql, CommandType.Text, parameters));
}
catch (Exception ex)
{
Log.Info($"Unable to Assign {assignToDriver.Course.Title} to {assignToDriver.Driver.DriverId} in LINK_DRIVER_COURSE Table --- {ex} ");
Log.Error(ex);
throw;
}
}
public ActionResult GetDriverId(string driverid)
{
DriverLinkCourseModel sendDriverId = new DriverLinkCourseModel();
sendDriverId.DriverId = driverid;
return(RedirectToAction("SelectAllCoursesAssignedToDriver", "LinkDriverCourse", sendDriverId));
}
//public ActionResult RedirectToEditAssignedCourse(int assignedCourse)
//{
// var entryToUpdate = linkDriverCourseAdapter.SelectCourseToEdit(assignedCourse);
// return View("~/Views/Admin/Edit/EditAssignedCourseToDriver.cshtml", entryToUpdate);
//}
public ActionResult RedirectToEditAssignedCourse(int assignedCourse)
{
DriverLinkCourseModel entryToUpdate = linkDriverCourseAdapter.SelectCourseToEdit(assignedCourse);
IEnumerable <Priority> priorityList = priorityAdapter.SelectAllPriorities();
entryToUpdate.PriorityList = new SelectList(priorityList, "Id", "NAME");
return(View("~/Views/Admin/Edit/EditAssignedCourseToDriver.cshtml", entryToUpdate));
}
public void AssignCourseToMultipleDrivers(DriverLinkCourseModel course)
{
var driverList = driverAdapter.SelectAllDrivers();
foreach (var driver in driverList)
{
linkDriverCourseAdapter.AssignCourseToDriver(course);
}
}
public ActionResult RedirectToAssignCourseToAllDrivers()
{
IEnumerable <CourseModel> courseList = courseAdapter.SelectAllCourses().OrderBy(x => x.Title);
IEnumerable <Priority> priorityList = priorityAdapter.SelectAllPriorities().OrderBy(x => x.Name);
DriverLinkCourseModel linkModel = new DriverLinkCourseModel()
{
CourseList = new SelectList(courseList, "Id", "Title"),
PriorityList = new SelectList(priorityList, "Id", "NAME")
};
return(View("~/Views/Admin/Assign/AssignCourseToAllDrivers.cshtml", linkModel));
}
public DriverLinkCourseModel SelectCourseToEdit(int entryToEdit)
{
Log.MethodStart();
try
{
string sql = @"select link.ID, us.DRIVER_ID, cs.ID as CourseId, cs.TITLE, pr.ID as PriorityId, pr.NAME, link.ASSIGNED_DATETIME, link.DUE_DATE from LINK_DRIVER_COURSE link
join COURSE cs on cs.ID = link.COURSE_ID
join [USER] us on us.ID = link.DRIVER_ID
join PRIORITY pr on pr.ID = link.PRIORITY
where link.ID = @ID";
List <Parameter> parameters = new List <Parameter>
{
new Parameter("@ID", entryToEdit)
};
DataSet dataSet = database.GetDataSet(sql, CommandType.Text, parameters.ToArray());
if (dataSet.IsEmptyDataSet())
{
return(null);
}
DataRow results = dataSet.Tables[0].Rows[0];
DriverLinkCourseModel newEntry = new DriverLinkCourseModel
{
Id = results["ID"].To <int>(),
DriverId = results["DRIVER_ID"].To <string>(),
Title = results["TITLE"].To <string>(),
SelectedCourseId = results["CourseId"].To <int>(),
Priority = new Priority {
Name = results["NAME"].To <string>()
},
SelectedPriorityId = results["PriorityId"].To <int>(),
Assigned_Datetime = results["ASSIGNED_DATETIME"].To <DateTime>().ToLocalTime(),
Due_Date = results["DUE_DATE"].To <DateTime>()
};
return(newEntry);
}
catch (Exception ex)
{
Log.Info($"Unable to Edit {entryToEdit} from LINK_DRIVER_COURSE Table --- {ex}");
Log.Error(ex);
throw;
}
}
//[HttpPost]
//public ActionResult AssignCourseToMultipleDrivers(List<DriverLinkCourseModel> driverList)
//{
// try
// {
// foreach (var driver in driverList)
// {
// driver.State = "Assigned";
// }
// var results = linkDriverCourseAdapter.AssignCourseToMultipleDrivers(driverList);
// return RedirectToAction("SelectAllAssignedCourses");
// }
// catch
// {
// return View();
// }
//}
// EDIT
public ActionResult EditAssignedCourseToDriver(DriverLinkCourseModel editEntry)
{
try
{
int results = linkDriverCourseAdapter.EditAssignedCourseToDriver(editEntry);
if (results != 1)
{
Log.Info($"Unable to Edit {editEntry.Course.Title} to {editEntry.Driver.DriverId} in LinkDriverCourseController -- results == {results}");
return(View("~/Views/Error/EnterAllInfoError.cshtml"));
}
return(RedirectToAction("SelectAllAssignedCourses"));
}
catch
{
Log.Info($"Unable to Edit course for driver in LinkDriverCourseController");
return(View("~/Views/Error/EnterAllInfoError.cshtml"));
}
}
public ActionResult AssignCourseToDriverGroup(DriverLinkCourseModel driverGroupAssignment)
{
try
{
int results = linkDriverCourseAdapter.AssignCourseToDriverGroup(driverGroupAssignment.SelectedCourseId, driverGroupAssignment.SelectedPriorityId,
driverGroupAssignment.Assigned_Datetime, driverGroupAssignment.Due_Date, driverGroupAssignment.SelectedGroupId);
if (results == 0)
{
Log.Info("Unable to assign course to driver group");
return(RedirectToAction("SelectAllAssignedCourses"));
}
return(RedirectToAction("SelectAllAssignedCourses"));
}
catch
{
Log.Info("Unable to assign course to driver group");
return(View());
}
}
public ActionResult AssignCourseToAllDrivers(DriverLinkCourseModel assignment)
{
try
{
int results = linkDriverCourseAdapter.AssignCourseToAllDrivers(assignment.SelectedCourseId, assignment.SelectedPriorityId,
assignment.Assigned_Datetime, assignment.Due_Date);
if (results == 0)
{
Log.Info($"Unable to Assign {assignment.Course.Title} to all drivers in LinkDriverCourseController -- results == {results}");
return(View("~/Views/Error/EnterAllInfoError.cshtml"));
}
return(RedirectToAction("SelectAllAssignedCourses"));
}
catch
{
Log.Info($"Unable to Assign course to all drivers in LinkDriverCourseController");
return(View("~/Views/Error/EnterAllInfoError.cshtml"));
}
}
public ActionResult AssignCourseToDriver(DriverLinkCourseModel assignment)
{
try
{
assignment.State = "Assigned";
int results = linkDriverCourseAdapter.AssignCourseToDriver(assignment);
if (results != 1)
{
Log.Info($"Unable to Assign {assignment.Course.Title} to {assignment.Driver.DriverId} -- results == {results}");
return(View("~/Views/Error/AssignCourseToDriverError.cshtml"));
}
return(RedirectToAction("SelectAllAssignedCourses"));
}
catch
{
Log.Info($"Unable to Assign course in LinkDriverCourseController");
return(View("~/Views/Error/AssignCourseToDriverError.cshtml"));
}
}
public int UpdateCoursesToPastDue(DriverLinkCourseModel courseToChange)
{
Log.MethodStart();
try
{
string sql = @"update LINK_DRIVER_COURSE set STATE = @STATE where ID = @ID";
List <Parameter> parameters = new List <Parameter>
{
new Parameter("@ID", courseToChange.Id),
new Parameter("@STATE", "Past Due")
};
return(database.ExecNonQuery(sql, CommandType.Text, parameters));
}
catch (Exception ex)
{
Log.Info($"Unable to Update {courseToChange.Course.Title} at {courseToChange.Id} state to Past Due in LINK_DRIVER_COURSE Table --- {ex}");
Log.Error(ex);
throw;
}
}
//public int UpdateCoursesToPastDue(List<DriverLinkCourseModel> courses)
//{
// try
// {
// StringBuilder sqlBuilder = new StringBuilder();
// var parameters = new List<Parameter>();
// for (int i = 0; i < courses.Count; i++)
// {
// sqlBuilder.Append($@"update LINK_DRIVER_COURSE set STATE = 'Past Due' where ID = @ID");
// parameters.Add(new Parameter($"@ID{i}", courses[i].Id));
// //parameters.Add(new Parameter($"@STATE{i}", "Past Due"));
// }
// var sql = sqlBuilder.ToString();
// var result = database.ExecNonQuery(sql, CommandType.Text, parameters.ToArray());
// return result;
// }
// catch (Exception ex)
// {
// Log.Error(ex);
// throw;
// }
//}
public int UpdateCoursesToComplete(DriverLinkCourseModel course)
{
Log.MethodStart();
try
{
string sql = @"update LINK_DRIVER_COURSE set STATE = @STATE, COMPLETED_DATETIME = @COMPLETED_DATETIME where ID = @ID";
List <Parameter> parameters = new List <Parameter>
{
new Parameter("@ID", course.Id),
new Parameter("@STATE", "Complete"),
new Parameter("@COMPLETED_DATETIME", DateTime.UtcNow.ToLocalTime())
};
return(database.ExecNonQuery(sql, CommandType.Text, parameters));
}
catch (Exception ex)
{
Log.Info($"Unable to Update {course.Course.Title} for {course.Driver.DriverId} to Completed state in LINK_DRIVER_COURSE Table --- {ex}");
Log.Error(ex);
throw;
}
}
public DriverLinkCourseModel ChangeStateToComplete(DriverLinkCourseModel course)
{
linkDriverCourseAdapter.UpdateCoursesToComplete(course);
return(course);
}
