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));
}
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;
}
}
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));
}
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));
}
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);
}
}
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.");
}
}
/// <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());
}
}
// 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);
}
}
/// <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.");
}
}
/// <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.");
}
}
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);
}
}
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));
}
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.");
}
}
public ActionResult Create(EMP obj)
{
_dbContext.EMPs.Add(obj);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
