コード例 #1
0
        public static string AddReport(tblReport report)
        {
            try
            {
                using (DataRecordsEntities1 context = new DataRecordsEntities1())
                {
                    int result = (from x in context.tblReports where x.employeeId == report.employeeId && x.reportDate == report.reportDate select x).Count();
                    if (result < 2)
                    {
                        int hours = 0;
                        if(result == 1)
                        {
                            hours = (from x in context.tblReports where x.employeeId == report.employeeId && x.reportDate == report.reportDate select x.workingHours).FirstOrDefault();
                        }

                        if(hours + report.workingHours <= 12)
                        {
                            context.tblReports.Add(report);
                            context.SaveChanges();
                        }
                        return null;
                    }
                    else
                    {
                        return "too many working hours";
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
                return "invalid report";
            }
        }
コード例 #2
0
        /// <summary>
        /// Add new employee or manager to db.
        /// </summary>
        /// <param name="employee">Add this employee to db</param>
        /// <param name="manager">true if this employee is also and manager</param>
        public static tblEmployee AddNewEmployeeOrManager(tblEmployee employee, bool manager)
        {
            try
            {
                using (DataRecordsEntities1 context = new DataRecordsEntities1())
                {
                    if (employee.employeeId == 0)
                    {
                        //add into tblEmployee
                        tblEmployee newEmployee = new tblEmployee();
                        newEmployee.firstname     = employee.firstname;
                        newEmployee.lastname      = employee.lastname;
                        newEmployee.dateOfBirth   = employee.dateOfBirth;
                        newEmployee.jmbg          = employee.jmbg;
                        newEmployee.accountNumber = employee.accountNumber;
                        newEmployee.mail          = employee.mail;
                        newEmployee.salary        = employee.salary;
                        newEmployee.position      = employee.position;
                        newEmployee.username      = employee.username;
                        newEmployee.password      = employee.password;
                        context.tblEmployees.Add(newEmployee);
                        context.SaveChanges();
                        employee.employeeId = newEmployee.employeeId;

                        if (manager)
                        {
                            //add into tblManager
                            tblManager newManager = new tblManager();
                            newManager.employeeId = employee.employeeId;
                            newManager.sector     = employee.sector;
                            newManager.access     = employee.access;
                            context.tblManagers.Add(newManager);
                            context.SaveChanges();
                        }
                        return(employee);
                    }
                    else
                    {
                        tblEmployee employeeToEdit = (from x in context.tblEmployees where x.employeeId == employee.employeeId select x).FirstOrDefault();
                        employeeToEdit.firstname     = employee.firstname;
                        employeeToEdit.lastname      = employee.lastname;
                        employeeToEdit.dateOfBirth   = employee.dateOfBirth;
                        employeeToEdit.jmbg          = employee.jmbg;
                        employeeToEdit.accountNumber = employee.accountNumber;
                        employeeToEdit.mail          = employee.mail;
                        employeeToEdit.salary        = employee.salary;
                        employeeToEdit.position      = employee.position;
                        employeeToEdit.username      = employee.username;
                        employeeToEdit.password      = employee.password;
                        context.SaveChanges();
                        return(employee);
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
                return(null);
            }
        }
コード例 #3
0
        public static string AddReport(vwReport report)
        {
            try
            {
                using (DataRecordsEntities1 context = new DataRecordsEntities1())
                {
                    if (report.reportId == 0)
                    {
                        int result = (from x in context.tblReports where x.employeeId == report.employeeId && x.reportDate == report.reportDate select x).Count();
                        if (result < 2)
                        {
                            int hours = 0;
                            if (result == 1)
                            {
                                hours = (from x in context.tblReports where x.employeeId == report.employeeId && x.reportDate == report.reportDate select x.workingHours).FirstOrDefault();
                            }

                            if (hours + report.workingHours <= 12)
                            {
                                tblReport newReport = new tblReport();
                                newReport.employeeId   = report.employeeId;
                                newReport.reportDate   = report.reportDate;
                                newReport.project      = report.project;
                                newReport.workingHours = report.workingHours;
                                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.workingHours = report.workingHours;
                        int r = (from x in context.tblReports where x.employeeId == report.employeeId && x.reportDate == report.reportDate && x.reportId != report.reportId select x.workingHours).FirstOrDefault();
                        if (r == 0 && reportToEdit.workingHours <= 12)
                        {
                            context.SaveChanges();
                            return(null);
                        }
                        else if (r + reportToEdit.workingHours <= 12)
                        {
                            context.SaveChanges();
                        }
                        else
                        {
                            return("Too many working hours");
                        }
                    }
                }
                return("Too many working hours");
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
                return("Invalid report");
            }
        }
コード例 #4
0
 public static tblEmployee GetEmployeeByUsernameAndPsw(string username, string password)
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             tblEmployee result = (from x in context.tblEmployees where x.username == username && x.password == password select x).FirstOrDefault();
             return result;
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
         return null;
     }
 }
コード例 #5
0
 public static void DeleteReport(vwReport report)
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             tblReport reportToDelete = (from u in context.tblReports where u.reportId == report.reportId select u).First();
             context.tblReports.Remove(reportToDelete);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
     }
 }
コード例 #6
0
 public static tblManager GetManagerById(int id)
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             tblManager result = (from x in context.tblManagers where x.employeeId == id select x).FirstOrDefault();
             return(result);
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
         return(null);
     }
 }
コード例 #7
0
 public static List<tblEmployee> GetAllEmployees()
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             List<tblEmployee> list = new List<tblEmployee>();
             list = (from x in context.tblEmployees select x).ToList();
             return list;
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
         return null;
     }
 }
コード例 #8
0
 public static List <vwReport> GetAllReports()
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             List <vwReport> list = new List <vwReport>();
             list = (from x in context.vwReports select x).ToList();
             return(list);
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
         return(null);
     }
 }
コード例 #9
0
 public static bool isManager(tblEmployee e)
 {
     try
     {
         using (DataRecordsEntities1 context = new DataRecordsEntities1())
         {
             tblManager result = (from x in context.tblManagers where x.employeeId == e.employeeId select x).FirstOrDefault();
             if (result != null)
             {
                 return true;
             }
             else
             {
                 return false;
             }
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
         return false;
     }
 }
コード例 #10
0
        public static void DeleteEmployee(tblEmployee emp)
        {
            try
            {
                using (DataRecordsEntities1 context = new DataRecordsEntities1())
                {
                    if (isManager(emp))
                    {
                        tblManager managerToDelete = (from u in context.tblManagers where u.employeeId == emp.employeeId select u).First();
                        context.tblManagers.Remove(managerToDelete);
                        context.SaveChanges();
                    }

                    tblEmployee userToDelete = (from u in context.tblEmployees where u.employeeId == emp.employeeId select u).First();
                    context.tblEmployees.Remove(userToDelete);
                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
            }
        }