/**Method to insert TimeSheet data into the TimeSheet data table**/
public void InsertTimeSheet(TimeSheet sheet)
{
WeeklyReport weeklyReport = new WeeklyReport();
db.TimeSheets.Add(sheet);
db.SaveChanges();
weeklyReport.getWeeklyReport(sheet.Banner_ID, sheet.WeekEnding.Trim());
}
/**Queries the Weekly Report Table for all timesheets for a specific employee then creates
* a list of weekly timesheets with disticted weekend dates**/
public WeeklyReport getWeeklyReport(int Banner_ID, string wEnd)
{
var wReport = (from wr in db.WeeklyReports
where wr.Banner_ID == Banner_ID && wr.WeekEnding == wEnd.Trim()
select wr);
var count = wReport.Count();
Debug.WriteLine("(((((( THE COUNT IS: )))) " + count);
if (count == 0)
{
WeeklyReport report = new WeeklyReport
{
Id = this.GetMaxWeeklyReportId() + 1,
WeekEnding = wEnd.Trim(),
Banner_ID = Banner_ID,
LeaveHours = "",
AdditionalHours = "",
HoursWorked = "",
TotalHoursWorked = "",
Overtime = "",
FLSA_Overtime = "",
SupervisorName = "",
TimesheetStatus = "",
EmployeeName = "",
};
this.InsertWeeklyReport(report);
report.CalculateWeeklyReport(Banner_ID, wEnd.Trim());
report.UpdateWeeklyReport(report);
return(report);
}
else
{
WeeklyReport report = new WeeklyReport();
report = wReport.First();
Debug.WriteLine("Report_ID: " + report.Id + " WeekEnding: " + report.WeekEnding + " Banner_ID: " + report.Banner_ID + " leaveHours: " + report.LeaveHours + " AdditionalHours: " + report.AdditionalHours + " HoursWorked: " + report.HoursWorked + " TotalHours: " + report.TotalHoursWorked + " Overtime: " + report.Overtime + " FLSA: " + report.FLSA_Overtime + " Supervisor: " + report.SupervisorName + " Status: " + report.TimesheetStatus + " Employee: " + report.EmployeeName + " poiuy");
report.CalculateWeeklyReport(Banner_ID, wEnd.Trim());
report.UpdateWeeklyReport(report);
return(report);
}
}
/**Updates a specifc Weekly Report with all recieved information**/
public void UpdateWeeklyReport(WeeklyReport report)
{
WeeklyReport wReport = (from wr in db.WeeklyReports
where wr.Id == report.Id
select wr).Single();
Debug.WriteLine("Report_ID: " + report.Id + " WeekEnding: " + report.WeekEnding + " Banner_ID: " + report.Banner_ID + " leaveHours: " + report.LeaveHours + " AdditionalHours: " + report.AdditionalHours + " HoursWorked: " + report.HoursWorked + " TotalHours: " + report.TotalHoursWorked + " Overtime: " + report.Overtime + " FLSA: " + report.FLSA_Overtime + " Supervisor: " + report.SupervisorName + " Status: " + report.TimesheetStatus + " Employee: " + report.EmployeeName + " QWERTY");
wReport.Id = report.Id;
wReport.WeekEnding = report.WeekEnding.Trim();
wReport.Banner_ID = report.Banner_ID;
wReport.LeaveHours = report.LeaveHours;
wReport.AdditionalHours = report.AdditionalHours;
wReport.HoursWorked = report.HoursWorked;
wReport.TotalHoursWorked = report.TotalHoursWorked;
wReport.Overtime = report.Overtime;
wReport.FLSA_Overtime = report.FLSA_Overtime;
wReport.SupervisorName = report.SupervisorName;
wReport.TimesheetStatus = report.TimesheetStatus;
wReport.EmployeeName = report.EmployeeName;
db.SaveChanges();
}
/**Method to update TimeSheet data in the TimeSheet data table**/
public void UpdateTimeSheet(TimeSheet sheet)
{
WeeklyReport weeklyReport = new WeeklyReport();
Debug.WriteLine("in database save 1");
Debug.WriteLine("******************************************************************************************************** " + sheet.LeaveId);
Debug.WriteLine("With sheet id: " + sheet.Id + "]");
string timeIn = "";
string outForLunch = "";
string inFromLunch = "";
string timeOut = "";
if (!String.IsNullOrEmpty(sheet.TimeIn.Trim()))
{
timeIn = sheet.TimeIn;
}
else
{
timeIn = "";
}
if (!String.IsNullOrEmpty(sheet.OutForLunch.Trim()))
{
outForLunch = sheet.OutForLunch;
}
else
{
outForLunch = "";
}
if (!String.IsNullOrEmpty(sheet.InFromLunch.Trim()))
{
inFromLunch = sheet.InFromLunch;
}
else
{
inFromLunch = "";
}
if (!String.IsNullOrEmpty(sheet.TimeOut.Trim()))
{
timeOut = sheet.TimeOut;
}
else
{
timeOut = "";
}
TimeSheet tsheet = (from tsheets in db.TimeSheets
where tsheets.Id == sheet.Id
select tsheets).Single();
Debug.WriteLine("The sheet is: " + sheet.Note + "]");
tsheet.Id = sheet.Id;
tsheet.WeekEnding = sheet.WeekEnding;
tsheet.Date = sheet.Date;
tsheet.TimeIn = timeIn;
tsheet.OutForLunch = outForLunch;
tsheet.InFromLunch = inFromLunch;
tsheet.TimeOut = timeOut;
tsheet.LeaveId = sheet.LeaveId;
tsheet.LeaveHours = sheet.LeaveHours;
tsheet.AdditionalHours = sheet.AdditionalHours;
tsheet.TotalHoursWorked = tsheet.CalculateTotalHoursWorked(sheet);
tsheet.Submitted = sheet.Submitted;
tsheet.AuthorizedBySupervisor = sheet.AuthorizedBySupervisor;
tsheet.Banner_ID = sheet.Banner_ID;
tsheet.Note = sheet.Note;
Debug.WriteLine("The tsheet is :" + sheet.LeaveId + "55555555555555]");
db.SaveChanges();
weeklyReport.getWeeklyReport(sheet.Banner_ID, sheet.WeekEnding.Trim());
}
/**Inserts a created weekly report into the weekly report table**/
public void InsertWeeklyReport(WeeklyReport report)
{
db.WeeklyReports.Add(report);
db.SaveChanges();
}