private void SaveExecute()
        {
            try
            {
                User.Gender         = Gender.ToString();
                User.MarriageStatus = Status;
                using (CompanyDBEntities db = new CompanyDBEntities())
                {
                    db.tblUsers.Add(User);
                    db.SaveChanges();

                    int id = db.tblUsers.Where(u => u.JMBG == User.JMBG).FirstOrDefault().UserID;

                    Admin.ExpirationDate = DateTime.Now.AddDays(7);
                    Admin.AdminType      = Type;
                    Admin.UserID         = id;

                    db.tblAdmins.Add(Admin);
                    db.SaveChanges();
                }

                MessageBox.Show("Administrator Created Successfully!");
                main.Close();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
            }
        }
        // Method that add Admin to database
        public void AddAdmin(vwAdmin admin)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser  newUser  = new tblUser();
                    tblAdmin newAdmin = new tblAdmin();
                    newUser.FirstName      = admin.FirstName;
                    newUser.LastName       = admin.LastName;
                    newUser.JMBG           = admin.JMBG;
                    newUser.Gender         = admin.Gender;
                    newUser.Residence      = admin.Residence;
                    newUser.MarriageStatus = admin.MarriageStatus;
                    newUser.Username       = admin.Username;
                    newUser.UserPassword   = SecurePasswordHasher.Hash(admin.UserPassword);

                    context.tblUsers.Add(newUser);
                    context.SaveChanges();
                    admin.UserID = newUser.UserID;

                    newAdmin.UserID         = admin.UserID;
                    newAdmin.ExpirationDate = DateTime.Now.AddDays(7);
                    newAdmin.AdminType      = admin.AdminType;

                    context.tblAdmins.Add(newAdmin);
                    context.SaveChanges();
                    admin.AdminID = newAdmin.AdminID;
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
            }
        }
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities db = new CompanyDBEntities())
                {
                    User.Gender         = Gender.ToString();
                    User.MarriageStatus = Status;
                    db.tblUsers.Add(User);
                    db.SaveChanges();

                    Worker.UserID          = User.UserID;
                    Worker.YearsOfService  = 0;
                    Worker.EducationDegree = Degree;

                    db.tblWorkers.Add(Worker);
                    db.SaveChanges();
                }

                MessageBox.Show("Worker Created Successfully!");
                main.Close();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
            }
        }
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities db = new CompanyDBEntities())
                {
                    User.Gender         = Gender.ToString();
                    User.MarriageStatus = Status;
                    db.tblUsers.Add(User);
                    db.SaveChanges();

                    Manager.UserID           = User.UserID;
                    Manager.ReservedPassword = Manager.ReservedPassword + "WPF";

                    db.tblManagers.Add(Manager);
                    db.SaveChanges();
                }

                MessageBox.Show("Manager Created Successfully!");
                main.Close();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
            }
        }
 // POST /api/customer
 public void Post(CustomerModel customer)
 {
     context.AddToCustomers(new Customer {
         Id = customer.Id, Name = customer.Name, Salary = customer.Salary
     });
     context.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
 }
        public ActionResult Create([Bind(Include = "EmpID,Ename,JOB,Salary,DeptID")] EMP eMP)
        {
            if (ModelState.IsValid)
            {
                db.EMPs.Add(eMP);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.DeptID = new SelectList(db.DEPTs, "DeptID", "Dname", eMP.DeptID);
            return(View(eMP));
        }
Beispiel #7
0
 protected void GVEmployee_RowInsert(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         if (e.CommandName.Equals("AddNew"))
         {
             if (sqlNative)
             {
                 using (SqlConnection sqlcon = new SqlConnection())
                 {
                     string     insrtquery = "Insert into Employees (nom_emp,prenom_emp,Salaire_emp,date_recrute_emp,tele_emp,id_dep) Values(@nom_emp,@prenom_emp,@Salaire_emp,@date_recrute_emp,@tele_emp,@id_dep)";
                     SqlCommand slqcmd     = new SqlCommand(insrtquery, sqlcon);
                     //Text.trim() : removes all leading and trailing whitespace from text value
                     slqcmd.Parameters.AddWithValue("@nom_emp", (GVEmployee.FooterRow.FindControl("txt_nom_emp_footer") as TextBox).Text.Trim());
                     slqcmd.Parameters.AddWithValue("@prenom_emp", (GVEmployee.FooterRow.FindControl("txt_prenom_emp_footer") as TextBox).Text.Trim());
                     slqcmd.Parameters.AddWithValue("@Salaire_emp", (GVEmployee.FooterRow.FindControl("txt_Salaire_emp_footer") as TextBox).Text.Trim());
                     slqcmd.Parameters.AddWithValue("@date_recrute_emp", (GVEmployee.FooterRow.FindControl("txt_date_recrute_emp_footer") as TextBox).Text.Trim());
                     slqcmd.Parameters.AddWithValue("@tele_emp", (GVEmployee.FooterRow.FindControl("txt_tele_emp_footer") as TextBox).Text.Trim());
                     DropDownList dddeprt = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer");
                     slqcmd.Parameters.AddWithValue("@id_dep", dddeprt.SelectedValue);
                     slqcmd.ExecuteNonQuery();
                     FillGridViewWithNativeSql();
                     lblSuccessMessage.Text = "New Record Added";
                     lblEroorMessage.Text   = "";
                 }
             }
             else
             {
                 DropDownList dddeprt = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer");
                 contxt.Employees.Add(new Employee
                 {
                     nom_emp          = (GVEmployee.FooterRow.FindControl("txt_nom_emp_footer") as TextBox).Text.Trim(),
                     prenom_emp       = (GVEmployee.FooterRow.FindControl("txt_prenom_emp_footer") as TextBox).Text.Trim(),
                     Salaire_emp      = Convert.ToDouble((GVEmployee.FooterRow.FindControl("txt_Salaire_emp_footer") as TextBox).Text.Trim()),
                     date_recrute_emp = Convert.ToDateTime((GVEmployee.FooterRow.FindControl("txt_date_recrute_emp_footer") as TextBox).Text.Trim()),
                     tele_emp         = Convert.ToDouble((GVEmployee.FooterRow.FindControl("txt_tele_emp_footer") as TextBox).Text.Trim()),
                     id_dep           = Convert.ToInt32(dddeprt.SelectedValue.Trim())
                 });
                 contxt.SaveChanges();
                 FillGridViewWithEntityFramework();
                 lblSuccessMessage.Text = "New Record Added";
                 lblEroorMessage.Text   = "";
             }
         }
     }
     catch (Exception ex)
     {
         lblSuccessMessage.Text = "";
         lblEroorMessage.Text   = ex.Message;
     }
 }
Beispiel #8
0
        public virtual IActionResult AddCar([FromBody] Car car)
        {
            (string, UserType)sender;
            try
            {
                sender = Security.SolveGUID(_context, Request.Headers["Guid"]);
            }
            catch (Exception e)
            {
                return(StatusCode(401, e.Message));
            }
            if (!String.IsNullOrEmpty(car.Username) && (!car.Username.Equals(sender.Item1) && sender.Item2 != UserType.WORKSHOP_EMPLOYEE))
            {
                return(StatusCode(403));
            }
            if (String.IsNullOrEmpty(car.Username))
            {
                car.Username = sender.Item1;
            }
            try
            {
                Validator.Validate(_context, car);
            }
            catch (ValidationException e)
            {
                return(StatusCode(400, e.Message));
            }
            car.Owner = _context.Users.FirstOrDefault(x => x.Username.Equals(car.Username));

            DiagnosticProfile diagnosticProfile = new DiagnosticProfile
            {
                LicensePlate = car.LicensePlate
            };

            car.DiagnosticProfile = diagnosticProfile;
            diagnosticProfile.Car = car;
            car.Insurances        = new List <Insurance>();

            _context.Add(car);
            _context.Add(diagnosticProfile);
            try
            {
                _context.SaveChanges();
            }
            catch (DbUpdateException e)
            {
                return(StatusCode(400, e.Message + " -> " + e.InnerException.Message));
            }
            return(new ObjectResult(car));
        }
Beispiel #9
0
        public virtual IActionResult AddUser([FromBody] User body)
        {
            body.Guid = Guid.NewGuid().ToString();
            _context.Users.Add(body);
            try
            {
                _context.SaveChanges();
            }
            catch (DbUpdateException)
            {
                return(StatusCode(400));
            }

            return(StatusCode(200, body));
        }
Beispiel #10
0
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities db = new CompanyDBEntities())
                {
                    tblUser user = db.tblUsers.Where(u => u.UserID == Admin.UserID).FirstOrDefault();
                    user.FirstName      = Admin.FirstName;
                    user.LastName       = Admin.LastName;
                    user.JMBG           = Admin.JMBG;
                    user.Gender         = Gender.ToString();
                    user.Residence      = Admin.Residence;
                    user.MarriageStatus = Status;
                    user.Username       = Admin.Username;
                    user.UserPassword   = Admin.UserPassword;

                    tblAdmin admin = db.tblAdmins.Where(a => a.AdminID == Admin.AdminID).FirstOrDefault();
                    admin.ExpirationDate = Admin.ExpirationDate;
                    admin.AdminType      = Type;

                    db.SaveChanges();
                }

                MessageBox.Show("Admin Updated Successfully!");
                main.Close();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
            }
        }
Beispiel #11
0
        public T Add(T model)
        {
            T newModel = dbSet.Add(model);

            context.SaveChanges();
            return(newModel);
        }
        /// <summary>
        /// method for deleting the project
        /// </summary>
        private void DeleteProjectExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    int id = project.ProjectID;

                    // checking the action
                    MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure you want to delete the project?", "Delete Confirmation", MessageBoxButton.YesNo);

                    if (messageBoxResult == MessageBoxResult.Yes)
                    {
                        tblProject projectToDelete = (from x in context.tblProjects where x.ProjectID == id select x).First();

                        // deleting the project
                        context.tblProjects.Remove(projectToDelete);
                        context.SaveChanges();

                        // updating the list
                        ProjectList = GetAllProjects().ToList();

                        MessageBox.Show("The project deleted successfully.");

                        // logging the action
                        FileActions.FileActions.Instance.Deleting(FileActions.FileActions.path, FileActions.FileActions.actions, "project", projectToDelete.ProjectName);
                    }
                }
            }
            catch (Exception)
            {
                MessageBox.Show("The project can not be deleted, please try again.");
            }
        }
Beispiel #13
0
        /// <summary>
        /// method for saving data to the database
        /// </summary>
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblPosition newPosition = new tblPosition();

                    newPosition.PositionName        = position.PositionName;
                    newPosition.PositionDescription = position.PositionDescription;
                    newPosition.PositionID          = position.PositionID;

                    // saving data
                    context.tblPositions.Add(newPosition);
                    context.SaveChanges();

                    MessageBox.Show("The position created successfully.");

                    // logging the action
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "position", newPosition.PositionName);
                }
                addPosition.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Wrong inputs. Please try again.");
            }
        }
        /// <summary>
        /// Creates or edits an sector
        /// </summary>
        /// <param name="sector">the sector that is being added</param>
        /// <returns>a new or edited sector</returns>
        public tblSector AddSector(tblSector sector)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    if (sector.SectorID == 0)
                    {
                        tblSector newSector = new tblSector
                        {
                            SectorName        = sector.SectorName,
                            SectorDescription = sector.SectorDescription
                        };

                        context.tblSectors.Add(newSector);
                        context.SaveChanges();
                        sector.SectorID = newSector.SectorID;

                        return(sector);
                    }
                    else
                    {
                        tblSector sectorToEdit = (from ss in context.tblSectors where ss.SectorID == sector.SectorID select ss).First();

                        sectorToEdit.SectorName = sector.SectorName;
                        sectorToEdit.SectorName = sector.SectorName;

                        sectorToEdit.SectorID = sector.SectorID;
                        context.SaveChanges();

                        return(sector);
                    }
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
                return(null);
            }
        }
        // Method that add Manager to database
        public void AddManager(vwManager manager)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser    newUser    = new tblUser();
                    tblManager newManager = new tblManager();
                    newUser.FirstName      = manager.FirstName;
                    newUser.LastName       = manager.LastName;
                    newUser.JMBG           = manager.JMBG;
                    newUser.Gender         = manager.Gender;
                    newUser.Residence      = manager.Residence;
                    newUser.MarriageStatus = manager.MarriageStatus;
                    newUser.Username       = manager.Username;
                    newUser.UserPassword   = SecurePasswordHasher.Hash(manager.UserPassword);

                    context.tblUsers.Add(newUser);
                    context.SaveChanges();
                    manager.UserID = newUser.UserID;

                    newManager.UserID                = manager.UserID;
                    newManager.Email                 = manager.Email;
                    newManager.ReservedPassword      = manager.ReservedPassword + "WPF";
                    newManager.LevelOfResponsibility = manager.LevelOfResponsibility;
                    newManager.SuccessfulProjects    = manager.SuccessfulProjects;
                    newManager.Salary                = "1200";
                    newManager.OfficeNumber          = manager.OfficeNumber;

                    context.tblManagers.Add(newManager);
                    context.SaveChanges();
                    manager.ManagerID = newManager.ManagerID;
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
            }
        }
Beispiel #16
0
        // Method that add Employee to database
        public void AddEmployee(vwWorker employee)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser   newUser     = new tblUser();
                    tblWorker newEmployee = new tblWorker();
                    newUser.FirstName      = employee.FirstName;
                    newUser.LastName       = employee.LastName;
                    newUser.JMBG           = employee.JMBG;
                    newUser.Gender         = employee.Gender;
                    newUser.Residence      = employee.Residence;
                    newUser.MarriageStatus = employee.MarriageStatus;
                    newUser.Username       = employee.Username;
                    newUser.UserPassword   = SecurePasswordHasher.Hash(employee.UserPassword);

                    context.tblUsers.Add(newUser);
                    context.SaveChanges();
                    employee.UserID = newUser.UserID;

                    newEmployee.UserID          = employee.UserID;
                    newEmployee.YearsOfService  = employee.YearsOfService;
                    newEmployee.EducationDegree = employee.EducationDegree;
                    newEmployee.SectorID        = 1;
                    newEmployee.PositionID      = employee.PositionID;
                    newEmployee.Salary          = "1200";

                    context.tblWorkers.Add(newEmployee);
                    context.SaveChanges();
                    employee.WorkerID = newEmployee.WorkerID;
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
            }
        }
        /// <summary>
        /// Creates or edits an employee
        /// </summary>
        /// <param name="employee">the employee that is being added</param>
        /// <returns>a new or edited employee</returns>
        public vwEmployee AddEmployee(vwEmployee employee)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    if (employee.UserID == 0)
                    {
                        tblUser newUser = new tblUser
                        {
                            FirstName      = employee.FirstName,
                            LastName       = employee.LastName,
                            JMBG           = employee.JMBG,
                            Gender         = employee.Gender,
                            Residence      = employee.Residence,
                            MarriageStatus = employee.MarriageStatus,
                            Username       = employee.Username,
                            UserPassword   = PasswordHasher.Hash(employee.UserPassword)
                        };

                        context.tblUsers.Add(newUser);
                        context.SaveChanges();
                        employee.UserID = newUser.UserID;

                        //TODO remove when method to create sectors is made
                        if (employee.SectorID == 0)
                        {
                            if (GetAllSectors().Count == 0)
                            {
                                tblSector sec = new tblSector
                                {
                                    SectorName        = "Default",
                                    SectorDescription = "Default"
                                };
                                AddSector(sec);
                                employee.SectorID = sec.SectorID;
                            }
                            else
                            {
                                employee.SectorID = GetAllSectors()[0].SectorID;
                            }
                        }

                        tblEmployee newEmployee = new tblEmployee
                        {
                            YearsOfService  = employee.YearsOfService,
                            Salary          = employee.Salary,
                            EducationDegree = employee.EducationDegree,
                            SectorID        = employee.SectorID,
                            ManagerID       = employee.ManagerID,
                            PositionID      = employee.PositionID,
                            UserID          = employee.UserID
                        };

                        context.tblEmployees.Add(newEmployee);
                        context.SaveChanges();
                        employee.EmployeeID = newEmployee.EmployeeID;

                        return(employee);
                    }
                    else
                    {
                        tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == employee.UserID select ss).First();

                        userToEdit.FirstName      = employee.FirstName;
                        userToEdit.LastName       = employee.LastName;
                        userToEdit.JMBG           = employee.JMBG;
                        userToEdit.Gender         = employee.Gender;
                        userToEdit.Residence      = employee.Residence;
                        userToEdit.MarriageStatus = employee.MarriageStatus;
                        userToEdit.Username       = employee.Username;

                        // Save only if password changed
                        if (userToEdit.UserPassword != employee.UserPassword)
                        {
                            userToEdit.UserPassword = PasswordHasher.Hash(employee.UserPassword);
                        }

                        userToEdit.UserID = employee.UserID;

                        tblUser userEdit = (from ss in context.tblUsers
                                            where ss.UserID == employee.UserID
                                            select ss).First();
                        context.SaveChanges();

                        tblEmployee employeeToEdit = (from ss in context.tblEmployees where ss.UserID == employee.UserID select ss).First();

                        employeeToEdit.YearsOfService  = employee.YearsOfService;
                        employeeToEdit.Salary          = employee.Salary;
                        employeeToEdit.EducationDegree = employee.EducationDegree;
                        employeeToEdit.SectorID        = employee.SectorID;
                        employeeToEdit.ManagerID       = employee.ManagerID;
                        employeeToEdit.PositionID      = employee.PositionID;
                        employeeToEdit.UserID          = employee.UserID;

                        employeeToEdit.EmployeeID = employee.EmployeeID;

                        tblEmployee employeeEdit = (from ss in context.tblEmployees
                                                    where ss.EmployeeID == employee.EmployeeID
                                                    select ss).First();
                        context.SaveChanges();
                        return(employee);
                    }
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
                return(null);
            }
        }
Beispiel #18
0
        /// <summary>
        /// method for saving data to the database
        /// </summary>
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser  newUser  = new tblUser();
                    tblAdmin newAdmin = new tblAdmin();

                    // inputs and validations
                    if (user.FirstName.All(Char.IsLetter))
                    {
                        newUser.FirstName = user.FirstName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong First Name input, please try again.");
                    }

                    if (user.LastName.All(Char.IsLetter))
                    {
                        newUser.LastName = user.LastName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Last Name input, please try again.");
                    }

                    newUser.JMBG = user.JMBG;

                    // JMBG validation
                    if (JmbgInputValidation(newUser.JMBG) == false)
                    {
                        MessageBox.Show("Wrong input, please check your JMBG (13 characters).");
                    }

                    string sex = user.Gender.ToUpper();

                    // gender validation
                    if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N"))
                    {
                        newUser.Gender = sex;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Gender input, please enter M, Z, X or N.");
                    }

                    user.UserID = newUser.UserID;

                    newUser.Residence = user.Residence;

                    string marriage = user.MarriageStatus.ToUpper();

                    if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED"))
                    {
                        newUser.MarriageStatus = marriage;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)");
                    }

                    newUser.Username     = user.Username;
                    newUser.UserPassword = user.UserPassword;

                    string adminType = admin.AdminType.ToUpper();

                    if ((adminType == "TEAM" || adminType == "SYSTEM" || adminType == "LOCAL"))
                    {
                        newAdmin.AdminType = adminType;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Admin type input. Please try again.\n (Team/System/Local)");
                    }

                    newAdmin.AdminID        = admin.AdminID;
                    newAdmin.ExpirationDate = DateTime.Now.AddDays(7);
                    newAdmin.UserID         = newUser.UserID;

                    // saving data to the database
                    context.tblUsers.Add(newUser);
                    context.tblAdmins.Add(newAdmin);
                    context.SaveChanges();

                    MessageBox.Show("The admin created successfully.");

                    // logging the action
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName);
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "admin", newUser.FirstName + " " + newUser.LastName);
                }
                masterView.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Wrong inputs, please check your inputs or try again.");
            }
        }
Beispiel #19
0
        /// <summary>
        /// method for saving the data to the database
        /// </summary>
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblProject newProject = new tblProject();

                    // inputs and validations
                    newProject.ProjectName        = project.ProjectName;
                    newProject.ProjectDescription = project.ProjectDescription;

                    if (project.ClientName.All(Char.IsLetter))
                    {
                        newProject.ClientName = project.ClientName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Client Name input, please try again.");
                    }

                    newProject.ContractDate = DateTime.Now;

                    if (project.ContractManager.All(Char.IsLetter))
                    {
                        newProject.ContractManager = project.ContractManager;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Contract Manager input, please try again.");
                    }

                    newProject.ProjectStartDate = DateTime.Now.AddDays(7);
                    newProject.ProjectDeadline  = DateTime.Now.AddDays(30);

                    newProject.HourlyRate = project.HourlyRate;

                    string a = project.Realisation;

                    if (a == "1" || a == "2" || a == "0")
                    {
                        newProject.Realisation = project.Realisation;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Realisation input, please try again. \n(0/1/2)");
                    }

                    // getting the ManagerID for the project
                    tblManager viaManager = (from x in context.tblManagers where x.ManagerID == manager.ManagerID select x).FirstOrDefault();
                    newProject.ManagerID = viaManager.ManagerID;
                    newProject.ProjectID = project.ProjectID;

                    // saving data
                    context.tblProjects.Add(newProject);
                    context.SaveChanges();

                    MessageBox.Show("The project created successfully.");

                    // logging action
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "project", newProject.ProjectName);

                    // updating the project list view
                    IsUpdateProject = true;
                }
                addProject.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Wrong inputs. Please try again.");
            }
        }
        /// <summary>
        /// method for saving data to the database
        /// </summary>
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser    newUser    = new tblUser();
                    tblManager newManager = new tblManager();

                    // inputs and validations
                    if (user.FirstName.All(Char.IsLetter))
                    {
                        newUser.FirstName = user.FirstName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong First Name input, please try again.");
                    }

                    if (user.LastName.All(Char.IsLetter))
                    {
                        newUser.LastName = user.LastName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Last Name input, please try again.");
                    }

                    newUser.JMBG = user.JMBG;

                    // JMBG validation
                    if (JmbgInputValidation(newUser.JMBG) == false)
                    {
                        MessageBox.Show("Wrong input, please check your JMBG (13 characters).");
                    }

                    string sex = user.Gender.ToUpper();

                    // gender validation
                    if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N"))
                    {
                        newUser.Gender = sex;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Gender input, please enter M, Z, X or N.");
                    }

                    user.UserID = newUser.UserID;

                    newUser.Residence = user.Residence;

                    string marriage = user.MarriageStatus.ToUpper();

                    if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED"))
                    {
                        newUser.MarriageStatus = marriage;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)");
                    }

                    newUser.Username     = user.Username;
                    newUser.UserPassword = user.UserPassword;

                    newManager.Email = manager.Email;
                    string reservedPassword = manager.ReservedPassword;

                    if (reservedPassword.Length >= 5)
                    {
                        newManager.ReservedPassword = reservedPassword + "WPF";
                    }
                    else
                    {
                        MessageBox.Show("Wrong Reserved Password input. Please try again.\n (Minimum 5 characters)");
                    }

                    newManager.SuccessfulProjects = manager.SuccessfulProjects;
                    newManager.OfficeNumber       = manager.OfficeNumber;
                    newManager.ManagerID          = manager.ManagerID;
                    newManager.UserID             = newUser.UserID;

                    // saving data
                    context.tblUsers.Add(newUser);
                    context.tblManagers.Add(newManager);
                    context.SaveChanges();

                    MessageBox.Show("The manager created successfully.");

                    // logging actions
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName);
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "manager", newUser.FirstName + " " + newUser.LastName);
                }
                createManagerView.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Wrong inputs, please check your inputs or try again.");
            }
        }
Beispiel #21
0
        public void Ajouter <T>(T entity) where T : class
        {
            context.Set <T>().Add(entity);

            context.SaveChanges();
        }
        /// <summary>
        /// Creates or edits a admin
        /// </summary>
        /// <param name="admin">the admin that is esing added</param>
        /// <returns>a new or edited admin</returns>
        public vwAdmin AddAdmin(vwAdmin admin)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    if (admin.UserID == 0)
                    {
                        tblUser newUser = new tblUser
                        {
                            FirstName      = admin.FirstName,
                            LastName       = admin.LastName,
                            JMBG           = admin.JMBG,
                            Gender         = admin.Gender,
                            Residence      = admin.Residence,
                            MarriageStatus = admin.MarriageStatus,
                            Username       = admin.Username,
                            UserPassword   = PasswordHasher.Hash(admin.UserPassword)
                        };

                        context.tblUsers.Add(newUser);
                        context.SaveChanges();
                        admin.UserID = newUser.UserID;

                        tblAdmin newAdmin = new tblAdmin
                        {
                            ExpirationDate = DateTime.Now.AddDays(7),
                            AdminType      = admin.AdminType,
                            UserID         = admin.UserID
                        };

                        context.tblAdmins.Add(newAdmin);
                        context.SaveChanges();
                        admin.AdminID = newAdmin.AdminID;

                        return(admin);
                    }
                    else
                    {
                        tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == admin.UserID select ss).First();

                        userToEdit.FirstName      = admin.FirstName;
                        userToEdit.LastName       = admin.LastName;
                        userToEdit.JMBG           = admin.JMBG;
                        userToEdit.Gender         = admin.Gender;
                        userToEdit.Residence      = admin.Residence;
                        userToEdit.MarriageStatus = admin.MarriageStatus;
                        userToEdit.Username       = admin.Username;

                        // Save only if password changed
                        if (userToEdit.UserPassword != admin.UserPassword)
                        {
                            userToEdit.UserPassword = PasswordHasher.Hash(admin.UserPassword);
                        }

                        userToEdit.UserID = admin.UserID;

                        tblUser userEdit = (from ss in context.tblUsers
                                            where ss.UserID == admin.UserID
                                            select ss).First();
                        context.SaveChanges();

                        tblAdmin adminToEdit = (from ss in context.tblAdmins where ss.UserID == admin.UserID select ss).First();

                        adminToEdit.ExpirationDate = admin.ExpirationDate;
                        adminToEdit.AdminType      = admin.AdminType;
                        adminToEdit.UserID         = admin.UserID;

                        adminToEdit.AdminID = admin.AdminID;

                        context.SaveChanges();
                        return(admin);
                    }
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
                return(null);
            }
        }
        /// <summary>
        /// Creates or edits a manager
        /// </summary>
        /// <param name="manager">the manager that is esing added</param>
        /// <returns>a new or edited manager</returns>
        public vwManager AddManager(vwManager manager)
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    if (manager.UserID == 0)
                    {
                        tblUser newUser = new tblUser
                        {
                            FirstName      = manager.FirstName,
                            LastName       = manager.LastName,
                            JMBG           = manager.JMBG,
                            Gender         = manager.Gender,
                            Residence      = manager.Residence,
                            MarriageStatus = manager.MarriageStatus,
                            Username       = manager.Username,
                            UserPassword   = PasswordHasher.Hash(manager.UserPassword)
                        };

                        context.tblUsers.Add(newUser);
                        context.SaveChanges();
                        manager.UserID = newUser.UserID;

                        tblManager newManager = new tblManager
                        {
                            Email                 = manager.Email,
                            ReservedPassword      = manager.ReservedPassword + "WPF",
                            LevelOfResponsibility = manager.LevelOfResponsibility,
                            SuccessfulProjects    = manager.SuccessfulProjects,
                            Salary                = manager.Salary,
                            OfficeNumber          = manager.OfficeNumber,
                            UserID                = manager.UserID
                        };

                        context.tblManagers.Add(newManager);
                        context.SaveChanges();
                        manager.ManagerID = newManager.ManagerID;

                        return(manager);
                    }
                    else
                    {
                        tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First();

                        userToEdit.FirstName      = manager.FirstName;
                        userToEdit.LastName       = manager.LastName;
                        userToEdit.JMBG           = manager.JMBG;
                        userToEdit.Gender         = manager.Gender;
                        userToEdit.Residence      = manager.Residence;
                        userToEdit.MarriageStatus = manager.MarriageStatus;
                        userToEdit.Username       = manager.Username;
                        userToEdit.UserID         = manager.UserID;

                        tblUser userEdit = (from ss in context.tblUsers
                                            where ss.UserID == manager.UserID
                                            select ss).First();
                        context.SaveChanges();

                        tblManager managerToEdit = (from ss in context.tblManagers where ss.UserID == manager.UserID select ss).First();

                        managerToEdit.Email                 = manager.Email;
                        managerToEdit.ReservedPassword      = manager.ReservedPassword;
                        managerToEdit.LevelOfResponsibility = manager.LevelOfResponsibility;
                        managerToEdit.SuccessfulProjects    = manager.SuccessfulProjects;
                        managerToEdit.Salary                = manager.Salary;
                        managerToEdit.OfficeNumber          = manager.OfficeNumber;
                        managerToEdit.UserID                = manager.UserID;

                        managerToEdit.ManagerID = manager.ManagerID;

                        tblManager managerEdit = (from ss in context.tblManagers
                                                  where ss.ManagerID == manager.ManagerID
                                                  select ss).First();
                        context.SaveChanges();
                        return(manager);
                    }
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Exception" + ex.Message.ToString());
                return(null);
            }
        }
Beispiel #24
0
        public virtual IActionResult AddVisit([FromBody] Body3 body)
        {
            (string, UserType)sender;
            try
            {
                sender = Security.SolveGUID(_context, Request.Headers["Guid"]);
            }
            catch (Exception e)
            {
                return(StatusCode(401, e.Message));
            }

            var car = _context.Cars.FirstOrDefault(x => x.LicensePlate.Equals(body.LicensePlate));

            if (car is null)
            {
                return(StatusCode(404));
            }

            var client = _context.Users.FirstOrDefault(x => x.Username == car.Username);

            if (client is null)
            {
                return(StatusCode(400));
            }

            var employees = _context.Users
                            .Include(x => x.AssignedVisits);
            var min = employees.Where(x => x.UserType == UserType.WORKSHOP_EMPLOYEE)
                      .Min(x => x.AssignedVisits.Count);
            var employee = employees.FirstOrDefault(x =>
                                                    x.AssignedVisits.Count == min && x.UserType == UserType.WORKSHOP_EMPLOYEE);

            if (employee is null)
            {
                return(StatusCode(400));
            }

            var visit = new Visit
            {
                Date             = body.Date,
                Car              = car,
                LicensePlate     = body.LicensePlate,
                RequiredActions  = body.RequiredActions,
                Type             = body.Type,
                Priority         = body.Priority,
                Status           = 0,
                CarOwnerUsername = client.Username,
            };

            var ev = new EmployeeVisit
            {
                VisitId  = _context.Visits.Max(x => x.VisitId) + 1,
                Username = employee.Username
            };

            _context.Visits.Add(visit);
            _context.EmployeesVisits.Add(ev);
            try
            {
                _context.SaveChanges();
            }
            catch (DbUpdateException)
            {
                return(StatusCode(400));
            }

            return(new ObjectResult(visit));
        }
Beispiel #25
0
 public void CompleteSync()
 {
     context.SaveChanges();
 }
        /// <summary>
        /// method for saving data to the database
        /// </summary>
        private void SaveExecute()
        {
            try
            {
                using (CompanyDBEntities context = new CompanyDBEntities())
                {
                    tblUser   newUser   = new tblUser();
                    tblWorker newWorker = new tblWorker();

                    // inputs and validations
                    if (user.FirstName.All(Char.IsLetter))
                    {
                        newUser.FirstName = user.FirstName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong First Name input, please try again.");
                    }

                    if (user.LastName.All(Char.IsLetter))
                    {
                        newUser.LastName = user.LastName;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Last Name input, please try again.");
                    }

                    newUser.JMBG = user.JMBG;

                    if (JmbgInputValidation(newUser.JMBG) == false)
                    {
                        MessageBox.Show("Wrong input, please check your JMBG (13 characters).");
                    }

                    string sex = user.Gender.ToUpper();

                    // gender validation
                    if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N"))
                    {
                        newUser.Gender = sex;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Gender input, please enter M, Z, X or N.");
                    }

                    user.UserID = newUser.UserID;

                    newUser.Residence = user.Residence;

                    string marriage = user.MarriageStatus.ToUpper();

                    if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED"))
                    {
                        newUser.MarriageStatus = marriage;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)");
                    }

                    newUser.Username     = user.Username;
                    newUser.UserPassword = user.UserPassword;

                    newWorker.YearsOfService = worker.YearsOfService;

                    string education = worker.EducationDegree;

                    if (education == "I" || education == "II" || education == "III" || education == "IV" || education == "V" || education == "VI" || education == "VII")
                    {
                        newWorker.EducationDegree = education;
                    }
                    else
                    {
                        MessageBox.Show("Wrong Education degree input. Please try again.\n (I - VII)");
                    }

                    newWorker.WorkerID   = worker.WorkerID;
                    newWorker.UserID     = newUser.UserID;
                    newWorker.SectorID   = Sector.SectorID;
                    newWorker.PositionID = Position.PositionID;

                    // saving the data
                    context.tblUsers.Add(newUser);
                    context.tblWorkers.Add(newWorker);
                    context.SaveChanges();

                    MessageBox.Show("The employee created successfully.");

                    // logging actions
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName);
                    FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "employee", newUser.FirstName + " " + newUser.LastName);
                }
                createEmployeeView.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Wrong inputs, please check your inputs or try again.");
            }
        }
Beispiel #27
0
 public ActionResult Create(EMP obj)
 {
     _dbContext.EMPs.Add(obj);
     _dbContext.SaveChanges();
     return(RedirectToAction("Index"));
 }