public IEnumerable <SupervisorViewModel> getsupervisorNameForJob(int supervisorID)
{
IEnumerable <SupervisorViewModel> result = null;
var supervisor = new SqlParameter("@supervisor", supervisorID);
try
{
result = RawSqlQuery <SupervisorViewModel> .StudentTimesheetQuery("student_timesheets_select_supervisor_name @supervisor", supervisor);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <StudentTimesheetsViewModel> deleteShiftForUser(int rowID, int studentID)
{
IEnumerable <StudentTimesheetsViewModel> result = null;
var row_id = new SqlParameter("@row_num", rowID);
var ID_NUM = new SqlParameter("@ID_NUM", studentID);
try
{
result = RawSqlQuery <StudentTimesheetsViewModel> .StudentTimesheetQuery("student_timesheets_delete_shift @row_num, @ID_NUM", row_id, ID_NUM);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <StudentTimesheetsViewModel> getSavedShiftsForUser(int ID_NUM)
{
IEnumerable <StudentTimesheetsViewModel> result = null;
var id_num = new SqlParameter("@ID_NUM", ID_NUM);
string query = "SELECT ID, ID_NUM, EML, EML_DESCRIPTION, SHIFT_START_DATETIME, SHIFT_END_DATETIME, HOURLY_RATE, HOURS_WORKED, SUPERVISOR, COMP_SUPERVISOR, STATUS, SUBMITTED_TO, SHIFT_NOTES, COMMENTS, PAY_WEEK_DATE, PAY_PERIOD_DATE, PAY_PERIOD_ID, LAST_CHANGED_BY, DATETIME_ENTERED from student_timesheets where ID_NUM = @ID_NUM AND STATUS != 'Paid' order by EML, SHIFT_START_DATETIME, STATUS";
try
{
result = RawSqlQuery <StudentTimesheetsViewModel> .StudentTimesheetQuery(query, id_num);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <OverlappingShiftIdViewModel> editShiftOverlapCheck(int studentID, DateTime shiftStart, DateTime shiftEnd, int rowID)
{
IEnumerable <OverlappingShiftIdViewModel> result = null;
var id_num = new SqlParameter("@ID_NUM", studentID);
var start_datetime = new SqlParameter("@start_datetime", shiftStart);
var end_datetime = new SqlParameter("@end_datetime", shiftEnd);
var shift_being_edited = new SqlParameter("@shift_being_edited", rowID);
try
{
result = RawSqlQuery <OverlappingShiftIdViewModel> .StudentTimesheetQuery("student_timesheets_edit_shift_already_worked_these_hours @ID_NUM, @start_datetime, @end_datetime, @shift_being_edited", id_num, start_datetime, end_datetime, shift_being_edited);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <ActiveJobViewModel> getActiveJobs(DateTime shiftStart, DateTime shiftEnd, int studentID)
{
IEnumerable <ActiveJobViewModel> result = null;
var start_datetime = new SqlParameter("@start_datetime", shiftStart);
var end_datetime = new SqlParameter("@end_datetime", shiftEnd);
var id_num = new SqlParameter("@ID_NUM", studentID);
try
{
result = RawSqlQuery <ActiveJobViewModel> .StudentTimesheetQuery("student_timesheets_select_emls_for_ajax_selectbox @start_datetime, @end_datetime, @ID_NUM", start_datetime, end_datetime, id_num);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <StudentTimesheetsViewModel> editShift(int rowID, DateTime shiftStart, DateTime shiftEnd, string hoursWorked, string username)
{
IEnumerable <StudentTimesheetsViewModel> result = null;
var id = new SqlParameter("@ID", rowID);
var newStart = new SqlParameter("@newStart", shiftStart);
var newEnd = new SqlParameter("@newEnd", shiftEnd);
var newHours = new SqlParameter("@newHours", hoursWorked);
var lastChangedBy = new SqlParameter("@lastChangedBy", username);
try
{
result = RawSqlQuery <StudentTimesheetsViewModel> .StudentTimesheetQuery("UPDATE student_timesheets SET STATUS = 'Saved', SHIFT_START_DATETIME = @newStart, SHIFT_END_DATETIME = @newEnd, HOURS_WORKED = @newHours, LAST_CHANGED_BY = @lastChangedBy, COMMENTS = null WHERE ID = @ID;", newStart, newEnd, newHours, id, lastChangedBy);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <StudentTimesheetsViewModel> submitShiftForUser(int studentID, int jobID, DateTime shiftEnd, int submittedTo, string lastChangedBy)
{
IEnumerable <StudentTimesheetsViewModel> result = null;
var ID_NUM = new SqlParameter("@ID_NUM", studentID);
var eml = new SqlParameter("@eml", jobID);
var shiftEndDateTime = new SqlParameter("@shift_end_datetime", shiftEnd);
var submitted_to = new SqlParameter("@submitted_to", submittedTo);
var changedBy = new SqlParameter("@last_changed_by", lastChangedBy);
try
{
result = RawSqlQuery <StudentTimesheetsViewModel> .StudentTimesheetQuery("student_timesheets_submit_job_shift @ID_NUM, @eml, @shift_end_datetime, @submitted_to, @last_changed_by", ID_NUM, eml, shiftEndDateTime, submitted_to, changedBy);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
public IEnumerable <StudentTimesheetsViewModel> saveShiftForUser(int studentID, int jobID, DateTime shiftStart, DateTime shiftEnd, string hoursWorked, string shiftNotes, string lastChangedBy)
{
IEnumerable <StudentTimesheetsViewModel> result = null;
var id_num = new SqlParameter("@ID_NUM", studentID);
var eml = new SqlParameter("@eml", jobID);
var shiftStartDateTime = new SqlParameter("@shift_start_datetime", shiftStart);
var shiftEndDateTime = new SqlParameter("@shift_end_datetime", shiftEnd);
var hours_worked = new SqlParameter("@hours_worked", hoursWorked);
var notes = new SqlParameter("@shift_notes", shiftNotes);
var changedBy = new SqlParameter("@last_changed_by", lastChangedBy);
try
{
result = RawSqlQuery <StudentTimesheetsViewModel> .StudentTimesheetQuery("student_timesheets_insert_shift @ID_NUM, @eml, @shift_start_datetime, @shift_end_datetime, @hours_worked, @shift_notes, @last_changed_by", id_num, eml, shiftStartDateTime, shiftEndDateTime, hours_worked, notes, changedBy);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(result);
}
