public BindingList<ProjectCategoryModel> LoadProjectCategories(SmartCRMEntitiesModel db)
{
var pocoCategories = db.ConstProjectCategories;
var categories = new BindingList<ProjectCategoryModel>();
MapHelper.Map(pocoCategories, categories);
return categories;
}
//TODO
public CheckResult ValidateEmployee(SmartCRMEntitiesModel context, EmployeeModel model)
{
CheckResult result = CheckResult.Default;
if (string.IsNullOrWhiteSpace(model.FirstName))
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<EmployeeModel>(x => x.FirstName), "Enter First Name!"));
}
if (string.IsNullOrWhiteSpace(model.LastName))
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<EmployeeModel>(x => x.LastName), "Enter Last Name!"));
}
//if (model.Username.Length < MinimumUsernameLength)
//{
// result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Username), "Minimum required length of the Username is 3 symbols!"));
//}
//if (model.Password.Length < MinimumPasswordLength)
//{
// result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Password), "Minimum required length of the Password is 6 symbols!"));
//}
return result;
}
public BindingList<ProjectModel> LoadProjects(SmartCRMEntitiesModel db)
{
List<Project> pocoProjects = db.Projects.ToList();
var projects = new BindingList<ProjectModel>();
foreach (var poco in pocoProjects)
{
ProjectModel model = ProjectModel.Create();
MapHelper.Map(poco, model);
foreach (var emp in poco.Employees)
{
EmployeeModel empModel = EmployeeModel.Create();
//MapHelper.Map(emp, empModel);
//empModel.AcceptChanges();
empModel.FirstName = emp.FirstName;
empModel.SecondName = emp.SecondName;
empModel.LastName = emp.LastName;
model.Employees.Add(empModel);
}
model.AcceptChanges();
projects.Add(model);
}
return projects;
}
private void InsertAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
{
User pocoUser = new User();
MapHelper.Map(userModel, pocoUser);
Employee pocoEmployee = new Employee();
MapHelper.Map(employeeModel, pocoEmployee);
pocoUser.Employee = pocoEmployee;
db.Add(pocoUser);
}
private void InsertEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
{
Employee pocoEmployee = new Employee();
MapHelper.Map(employeeModel, pocoEmployee);
db.Add(pocoEmployee);
db.FlushChanges();
employeeModel.Id = pocoEmployee.Id;
}
private void UpdateEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
{
var pocoEmployee = db.Employees.FirstOrDefault(x => x.Id.Equals(employeeModel.Id));
if (pocoEmployee == null)
{
throw new NullReferenceException("Missing employee!");
}
MapHelper.Map(employeeModel, pocoEmployee);
}
private static void CheckIfExistUser(UserModel model, SmartCRMEntitiesModel db, CheckResult result)
{
UserRepository repository = new UserRepository();
var user = repository.GetUserByModel(db, model);
if (user == null)
{
result.Details.Add(
new CheckResultDetail(CheckResultDetail.ErrorType.Error, "NoUser", "The username or password is incorect!"));
}
}
public CheckResult ValidateIfUserExistInDatabase(SmartCRMEntitiesModel context, UserModel model)
{
CheckResult result = CheckResult.Default;
var userInDb = context.Users.FirstOrDefault(user => user.Username == model.Username && user.UserId != model.UserId);
if (userInDb != null)
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Username), "This username already exist! Please select another one."));
}
return result;
}
private void UpdateAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
{
var pocoUser = db.Users.FirstOrDefault(x => x.UserId.Equals(userModel.UserId));
if (pocoUser == null)
{
throw new NullReferenceException("Missing user!");
}
MapHelper.Map(userModel, pocoUser);
MapHelper.Map(employeeModel, pocoUser.Employee);
}
public void SaveAccount(SmartCRMEntitiesModel db, UserModel userModel, EmployeeModel employeeModel)
{
if (userModel.IsNew)
{
this.InsertAccount(db, userModel, employeeModel);
}
else
{
this.UpdateAccount(db, userModel, employeeModel);
}
}
public void SaveEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
{
if (employeeModel.Id == 0)
{
this.InsertEmployee(db, employeeModel);
}
else
{
this.UpdateEmployee(db, employeeModel);
}
}
public EmployeeModel GetEmployeeById(SmartCRMEntitiesModel db, uint employeeId)
{
Employee employee = db.Employees.FirstOrDefault(x => x.Id == employeeId);
if (employee == null)
{
return null;
}
EmployeeModel model = EmployeeModel.Create();
MapHelper.Map(employee, model);
return model;
}
public UserModel GetUserByModel(SmartCRMEntitiesModel db, UserModel model)
{
User user = db.Users.FirstOrDefault(x => x.Username == model.Username && x.Password == model.Password && x.IsEnabled);
if (user != null)
{
UserModel userModel = UserModel.Create();
MapHelper.Map(user, userModel);
return userModel;
}
return null;
}
public CheckResult ValidateCreateEditUser(UserModel model, SmartCRMEntitiesModel context)
{
CheckResult result = CheckResult.Default;
if (model.Username.Length < 3)
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, "Username", "The username must be at least 3 symbols!"));
}
CheckIfExistUser(model, context, result);
return result;
}
public BindingList<UserModel> LoadAllUsers(SmartCRMEntitiesModel db, bool isActive)
{
List<User> pocoUsers;
if (isActive)
{
pocoUsers = db.Users.Where(x => x.IsEnabled).ToList();
}
else
{
pocoUsers = db.Users.ToList();
}
var modelUsers = new BindingList<UserModel>();
foreach (var poco in pocoUsers)
{
UserModel model = UserModel.Create();
MapHelper.Map(poco, model);
model.AcceptChanges();
modelUsers.Add(model);
}
return modelUsers;
}
public CheckResult ValidateLogin(UserModel model, SmartCRMEntitiesModel context)
{
CheckResult result = CheckResult.Default;
if (string.IsNullOrWhiteSpace(model.Username))
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Username), "Enter username!"));
}
if (string.IsNullOrWhiteSpace(model.Password))
{
result.Details.Add(new CheckResultDetail(CheckResultDetail.ErrorType.Error, StaticReflection.GetMemberName<UserModel>(x => x.Password), "Enter password!"));
}
if (!result.Success)
{
return result;
}
CheckIfExistUser(model, context, result);
return result;
}
public BindingList<EmployeeModel> LoadAllEmployees(SmartCRMEntitiesModel db, bool isActive)
{
List<Employee> pocoEmployees;
if (isActive)
{
pocoEmployees = db.Employees.Where(x => !x.IsDeleted).ToList();
}
else
{
pocoEmployees = db.Employees.ToList();
}
var modelEmployees = new BindingList<EmployeeModel>();
foreach (var poco in pocoEmployees)
{
EmployeeModel model = EmployeeModel.Create();
MapHelper.Map(poco, model);
model.AcceptChanges();
modelEmployees.Add(model);
}
return modelEmployees;
}
public void DeleteUser(SmartCRMEntitiesModel db, UserModel userModel)
{
User pocoUser = db.Users.FirstOrDefault(x => x.UserId == userModel.UserId);
if (pocoUser == null)
{
throw new NullReferenceException("Missing user in database!");
}
db.Delete(pocoUser);
}
public void DeleteEmployee(SmartCRMEntitiesModel db, EmployeeModel employeeModel)
{
Employee pocoEmployee = db.Employees.FirstOrDefault(x => x.Id == employeeModel.Id);
if (pocoEmployee == null)
{
throw new NullReferenceException("Missing employee in database!");
}
db.Delete(pocoEmployee);
}
public void SaveUser(SmartCRMEntitiesModel db, UserModel userModel)
{
if (userModel.UserId == 0)
{
this.InsertUser(db, userModel);
}
else
{
this.UpdateUser(db, userModel);
}
}
private void InsertUser(SmartCRMEntitiesModel db, UserModel userModel)
{
User pocoUser = new User();
Mapper.Map(userModel, pocoUser);
db.Add(pocoUser);
}
public UserModel GetUserByEmployeeId(SmartCRMEntitiesModel db, uint employeeId)
{
User pocoUser = db.Users.FirstOrDefault(x => x.EmployeeId == employeeId);
if (pocoUser == null)
{
return null;
}
UserModel model = UserModel.Create();
Mapper.Map(pocoUser, model);
return model;
}