public tblReport AddReport(vwReport report)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblReport newReport = new tblReport();
newReport.EmployeeID = report.EmployeeID;
newReport.DateOfReport = DateTime.Today;
newReport.Position = report.Position;
newReport.Project = report.Project;
context.tblReports.Add(newReport);
context.SaveChanges();
report.ReportID = newReport.ReportID;
return(newReport);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public EmployeeViewModel(View.Employee open, vwReport report)
{
emp = open;
newReport = report;
logOutVisibility = Visibility.Collapsed;
//backgroundWorker.DoWork += DoWorkEdit;
}
public AddReportViewModel(AddReportView addReportView, vwEmployee employee)
{
this.addReportView = addReportView;
this.employee = employee;
report = new vwReport();
report.EmployeeID = employee.EmployeeID;
}
public EmployeeViewModel(View.Employee open, int id)
{
emp = open;
newReport = new vwReport();
newReport.employeeId = id;
//backgroundWorker.DoWork += DoWorkAdd;
}
public EmployeeViewModel(EmployeeView viewOpen, int id)
{
employeeView = viewOpen;
service = new Service();
Report = new vwReport();
Report.EmployeeId = id;
}
public EditReportViewModel(EditReport etitReportViewOpen, vwReport reportToEdit, tblEmployee employeeLogIn)
{
view = etitReportViewOpen;
employeeService = new EmployeeService();
managerService = new MenagerService();
reportService = new ReportService();
Report = reportToEdit;
LogedEmployee = employeeLogIn;
}
public AddReportViewModel(AddReport addEmployeeViewOpen, tblEmployee logedEmpl)
{
view = addEmployeeViewOpen;
employeeService = new EmployeeService();
managerService = new MenagerService();
reportService = new ReportService();
Report = new vwReport();
Report.EmployeeID = logedEmpl.EmployeeID;
employeeLogedIn = logedEmpl;
}
public EditReportViewModel(EditReportView editReportView, vwReport reportToEdit)
{
this.editReportView = editReportView;
this.report = reportToEdit;
//gets reports initial values before editing
CheckIsReportChanged = new vwReport
{
Date = reportToEdit.Date,
Project = reportToEdit.Project,
Hours = reportToEdit.Hours
};
}
/// <summary>
/// Method to get report by Id of employee
/// </summary>
/// <param name="employeeId"></param>
/// <returns>single report of employee</returns>
public vwReport GetReportByEmployeeId(int employeeId)
{
try
{
using (EmployeeManagementEntities context = new EmployeeManagementEntities())
{
vwReport report = (from x in context.vwReports where x.EmployeeId == employeeId select x).FirstOrDefault();
return(report);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public tblReport EditReport(vwReport report)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblReport reportToEdit = (from u in context.tblReports
where u.ReportID == report.ReportID select u).First();
reportToEdit.Position = report.Position;
reportToEdit.Project = report.Project;
reportToEdit.NumberOfHours = report.NumberOfHours;
context.SaveChanges();
return(reportToEdit);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public EditReportView(vwReport reportToDelete)
{
InitializeComponent();
this.DataContext = new EditReportViewModel(this, reportToDelete);
}
/// <summary>
/// Method for adding or editing reports into database by Employee
/// </summary>
/// <param name="report"></param>
/// <returns></returns>
public string AddReport(vwReport report)
{
try
{
using (EmployeeManagementEntities context = new EmployeeManagementEntities())
{
if (report.ReportId == 0)
{
int noOfreports = (from x in context.tblReports where x.EmployeeId == report.EmployeeId && x.ReportDate == report.ReportDate select x).Count();
if (noOfreports < 2)
{
int hours = 0;
if (noOfreports == 1)
{
hours = (from x in context.tblReports where x.EmployeeId == report.EmployeeId && x.ReportDate == report.ReportDate select x.WorkHours).FirstOrDefault();
}
if (hours + report.WorkHours <= 12)
{
tblReport newReport = new tblReport();
newReport.EmployeeId = report.EmployeeId;
newReport.ReportDate = report.ReportDate;
newReport.Project = report.Project;
newReport.WorkHours = report.WorkHours;
context.tblReports.Add(newReport);
context.SaveChanges();
return(null);
}
}
}
else
{
tblReport reportToEdit = (from x in context.tblReports where x.ReportId == report.ReportId select x).FirstOrDefault();
reportToEdit.ReportDate = report.ReportDate;
reportToEdit.Project = report.Project;
reportToEdit.WorkHours = report.WorkHours;
int rep = (from x in context.tblReports where x.EmployeeId == report.EmployeeId && x.ReportDate == report.ReportDate && x.ReportId != report.ReportId select x.WorkHours).FirstOrDefault();
if (rep == 0 && reportToEdit.WorkHours <= 12)
{
context.SaveChanges();
return(null);
}
else if (rep + reportToEdit.WorkHours <= 12)
{
context.SaveChanges();
}
else
{
return("Cannot have more than 12 work hours.");
}
}
}
return("Cannot have more than 12 work hours.");
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public EditReport(vwReport report, tblEmployee employee)
{
InitializeComponent();
DataContext = new EditReportViewModel(this, report, employee);
}
public EmployeeViewModel(EmployeeView viewOpen, vwReport report)
{
employeeView = viewOpen;
Report = report;
}
public EmployeeView(vwReport report)
{
InitializeComponent();
this.DataContext = new EmployeeViewModel(this, report);
}
