public IActionResult PushAddEmployeeToDB(string name, string surname, string email, string phone, long positionId, bool addNewEmpleyeePermission, bool addNewTaskPermission, bool addNewEventPermission, bool previewEmployeesPermission)
{
Random random = new Random();
EmployeeModel employeeModel = new EmployeeModel(0, name, surname, email, phone, true, positionId);
bool randomLoginAndPassword = true;
string login = string.Empty;
string password = string.Empty;
User user = null;
do
{
login = name.Substring(0, 3).ToLower() + surname.Substring(0, 3).ToLower() + random.Next(0, 9999).ToString("D4");
password = Extensions.GeneratePasswordExtensions.GenerateRandomPassword();
List <object[]> usersList = BaseDAO.Select("Users", null, new Dictionary <string, object>()
{
{ "Login", login }
});
if (!usersList.Any())
{
EmployeeDAO.Insert(employeeModel);
employeeModel = EmployeeDAO.SelectFirst(EmployeeDAO.Columns.Fill(employeeModel, true));
BaseDAO.Insert("Users", new Dictionary <string, object>
{
{ "Login", login },
{ "Password", password },
{ "IdEmployee", employeeModel.Id } // Zła wartość
});
if (addNewEmpleyeePermission)
{
BaseDAO.Insert("EmployeePermissions", new Dictionary <string, object>()
{
{ "IdEmployee", employeeModel.Id },
{ "IdPermission", 1 }
});
}
if (addNewTaskPermission)
{
BaseDAO.Insert("EmployeePermissions", new Dictionary <string, object>()
{
{ "IdEmployee", employeeModel.Id },
{ "IdPermission", 2 }
});
}
if (addNewEventPermission)
{
BaseDAO.Insert("EmployeePermissions", new Dictionary <string, object>()
{
{ "IdEmployee", employeeModel.Id },
{ "IdPermission", 3 }
});
}
if (previewEmployeesPermission)
{
BaseDAO.Insert("EmployeePermissions", new Dictionary <string, object>()
{
{ "IdEmployee", employeeModel.Id },
{ "IdPermission", 4 }
});
}
user = new User(login, password);
randomLoginAndPassword = false;
}
}while (randomLoginAndPassword);
MailMessageSender.SendMessage(employeeModel.Email, employeeModel.Name + " " + employeeModel.SurName, "Dane logowania", user, MailTypes.addEmployee);
return(RedirectToAction("MainPage", "Home"));
}
public void clearAllForms()
{
EmployeeDAO.ClearFormsAuth();
}
public static List <EmployeeModel> GetAllEmployees()
{
return(EmployeeDAO.Select(null));
}
public void TestGetByLastnameShouldReturnEmployee()
{
EmployeeDAO dao = new EmployeeDAO();
Assert.IsInstanceOfType(dao.GetByLastname("Smartypants"), typeof(Employee));
}
public Employee FindEmployeebyID(int id)
{
return(EmployeeDAO.FindEmployeebyID(id));
}
public static void AddEmployee(EMPLOYEE employee)
{
EmployeeDAO.AddEmployee(employee);
}
public static void UpdateEmployee(EMPLOYEE employee)
{
EmployeeDAO.UpdateEmployee(employee);
}
public EmployeeVO GetEmployee(Guid employeeID){
EmployeeDAO dao = new EmployeeDAO();
return dao.GetEmployee(employeeID);
}
public List<EmployeeVO> GetAllEmployees(){
EmployeeDAO dao = new EmployeeDAO();
return dao.GetAllEmployees();
}
public ModifyCustomerDAO()
{
empDao = new EmployeeDAO();
editMessengerDao = new EditMessengerDAO();
}
public EmployeeVO CreateEmployee(EmployeeVO employee){
EmployeeDAO dao = new EmployeeDAO();
return dao.InsertEmployee(employee);
}
public ManagerSessionLogin()
{
this._accountDAO = (AccountDAO) new AccountDAOImpl();
this._employeeDAO = (EmployeeDAO) new EmployeeDAOImpl();
this._customerDAO = (CustomerDAO) new CustomerDAOImpl();
}
public static List <EMPLOYEE> GetEmployees(int userNo, string password)
{
return(EmployeeDAO.GetEmployees(userNo, password));
}
public Employee GetById(uint id)
{
return(EmployeeDAO.GetById(id));
}
public IEnumerable <Employee> GetList()
{
return(EmployeeDAO.GetList());
}
public EmployeeVO UpdateEmployee(EmployeeVO employee){
EmployeeDAO dao = new EmployeeDAO();
return dao.UpdateEmployee(employee);
}
// DELETE: api/Employee/5
public void Delete(int id)
{
EmployeeDAO employeeDAO = new EmployeeDAO();
employeeDAO.deleteEmployee(id);
}
public void DeleteEmployee(Guid employeeID){
EmployeeDAO dao = new EmployeeDAO();
dao.DeleteEmployee(employeeID);
}
public static List <EMPLOYEE> GetEmployees(int v, string text)
{
return(EmployeeDAO.GetEmployees(v, text));
}
public List<Employee> GetAllEmployees()
{
EmployeeDAO eDAO = new EmployeeDAO();
return eDAO.GetAllEmployees();
}
public static void DeleteEmployee(int employeeID)
{
EmployeeDAO.DeleteEmployee(employeeID);
}
public Employee GetEmployee(int employeeID)
{
EmployeeDAO eDAO = new EmployeeDAO();
return eDAO.GetEmployee(employeeID);
}
public void TestGetByIdShouldReturnEmployee()
{
EmployeeDAO dao = new EmployeeDAO();
Assert.IsInstanceOfType(dao.GetById(eid), typeof(Employee));
}
// GET: api/Employee
// GET: api/Employee
public List <Employee> Get()
{
EmployeeDAO employeeDAO = new EmployeeDAO();
return(employeeDAO.getListEmployee());
}
public MembershipCreateStatus AddEmployeeToForms(Employee emp)
{
MembershipCreateStatus result = EmployeeDAO.InsertEmployeeIntoFormsAuth(emp);
return(result);
}
// GET: api/Employee/5
public List <Employee> Get(string name)
{
EmployeeDAO employeeDAO = new EmployeeDAO();
return(employeeDAO.searchEmployee(name));
}
/// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary>
/// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param>
/// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
/// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
/// <param name="relations">The set of relations to walk to construct to total query.</param>
/// <param name="pageNumber">The page number to retrieve.</param>
/// <param name="pageSize">The page size of the page to retrieve.</param>
/// <returns>DataTable with the rows requested.</returns>
public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize)
{
EmployeeDAO dao = DAOFactory.CreateEmployeeDAO();
return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize));
}
public Employee getEmployeeByAccount(string username)
{
EmployeeDAO employeeDAO = new EmployeeDAO();
return(employeeDAO.getEmployeeByAccount(username));
}
public static List <EmployeeModel> GetAllEmployeesWithActualUser()
{
return(EmployeeDAO.SelectWithActualUser(null));
}
// POST: api/Employee
public void Post([FromBody] Employee employee)
{
EmployeeDAO employeeDAO = new EmployeeDAO();
employeeDAO.InsertEmployee(employee);
}
public EmployeeViewModel()
{
_dao = new EmployeeDAO();
}
public OrderDAO()
{
empDao = new EmployeeDAO();
iADao = new InformationAssistantDAO();
}
