public override int deleteUser(BaseUserModel baseUser)
{
PromoUserModel user = (PromoUserModel)baseUser;
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("id", "=", user.id).Delete();
return(affectedRows);
}
public virtual async Task <ProfileModel> GetProfile(BaseUserModel User)
{
ApplicationUser user = null;
if (!string.IsNullOrWhiteSpace(User.Email))
{
user = await _userManager.FindByEmailAsync(User.Email);
}
else if (!string.IsNullOrWhiteSpace(User.Id))
{
user = await _userManager.FindByIdAsync(User.Id);
}
if (user == null)
{
return(new ProfileModel
{
Succeeded = false,
StatusMessage = "Failed to retrieve user"
});
}
return(new ProfileModel
{
Id = user.Id,
Username = user.UserName,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
Succeeded = true,
StatusMessage = ""
});
}
public override int deleteUser(BaseUserModel baseUser)
{
SystemUserModel user = (SystemUserModel)baseUser;
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("email", "=", user.email).Delete();
return(affectedRows);
}
public User BaseModelToDbUser(BaseUserModel model)
{
User user = model.Map <User>();
user.CountryId = model.Country.Id;
return(user);
}
public BaseUserModel ToBaseUserModel(User user)
{
BaseUserModel model = user.Map <BaseUserModel>();
//model.Country = _countryRepository.Get(user.CountryId).Name;
model.Role = _roleRepository.Get(user.RoleId).Name;
return(model);
}
public static BaseUserModel ToBaseUser(this User user)
{
BaseUserModel _result = new BaseUserModel();
_result.Id = user.Id;
_result.UserName = user.UserName;
_result.Password = user.Password;
_result.Active = user.Active;
_result.RoleId = user.RoleId;
_result.Narration = user.Narration;
_result.CreatedDate = user.CreatedDate;
_result.ModifiedDate = user.ModifiedDate;
return(_result);
}
public override int updateUser(BaseUserModel baseUser)
{
PromoUserModel user = (PromoUserModel)baseUser;
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("id", "=", user.id).Update(new
{
firstName = user.firstName,
lastName = user.lastName,
cellPhoneNumber = user.cellPhoneNumber,
typeOfPromo = user.typeOfPromo,
entryDate = user.entryDate
});
return(affectedRows);
}
public override int insertUser(BaseUserModel baseUser)
{
PromoUserModel user = (PromoUserModel)baseUser;
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Insert(new
{
user.firstName,
user.lastName,
user.cellPhoneNumber,
user.typeOfPromo,
user.entryDate
});
return(affectedRows);
}
//This method receive a function (update, delete or insert) and user that will be modify
public int doDataBaseOperation(Func <BaseUserModel, int> dataBaseOperation, BaseUserModel user)
{
int affectedRows = 0;
try
{
affectedRows = dataBaseOperation(user);
}
catch (Exception error)
{
throw error;
}
return(affectedRows);
}
public override int insertUser(BaseUserModel baseUser)
{
SystemUserModel user = (SystemUserModel)baseUser;
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Insert(new
{
user.firstName,
user.lastName,
user.cellPhoneNumber,
user.entryDate,
user.email,
password = Encryptor.GetSHA256(user.password),
user.role
});
return(affectedRows);
}
public IActionResult Register(BaseUserModel model)
{
IActionResult actionResult = this.Problem();
if (ModelState.IsValid)
{
try
{
model = _UserService.Create(model.Map <User>()).Map <BaseUserModel>();
actionResult = this.Ok(model);
}
catch (Exception)
{
}
}
return(actionResult);
}
public static User ToUser(this BaseUserModel user)
{
User _result = new User();
if (user.Id.HasValue)
{
_result.Id = user.Id.GetValueOrDefault();
}
_result.UserName = user.UserName;
_result.Password = user.Password;
_result.Active = user.Active;
_result.RoleId = user.RoleId;
_result.Narration = user.Narration;
_result.CreatedDate = user.CreatedDate;
_result.ModifiedDate = user.ModifiedDate;
return(_result);
}
public override int updateUser(BaseUserModel baseUser)
{
SystemUserModel user = (SystemUserModel)baseUser;
user.password = Encryptor.GetSHA256(user.password);
int affectedRows = factory.Query(ASSOCIATED_TABLE_NAME).Where("email", "=", user.email).Update(new
{
firstName = user.firstName,
lastName = user.lastName,
cellPhoneNumber = user.cellPhoneNumber,
entryDate = user.entryDate,
password = user.password,
role = user.role
});
return(affectedRows);
}
public IActionResult Login([FromBody] LoginModel model)
{
IActionResult result = this.Unauthorized();
if (model != null)
{
User user = _UserService.Login(model.Email, model.Password);
if (user == null)
{
return(result);
}
BaseUserModel logged = _UserService.Get(user.Id).Map <BaseUserModel>();
logged.Token = this.CreateToken(user);
result = this.Ok(logged);
}
return(result);
}
/// <summary>
/// create new user
/// </summary>
/// <param name="userModel"></param>
/// <returns></returns>
public UserDTO Add(UserCreateDTO userModel)
{
BaseUserModel user = new BaseUserModel()
{
Id = Guid.NewGuid(),
FirstName = userModel.FirstName,
LastName = userModel.LastName,
City = userModel.City,
Address = userModel.Address,
Email = userModel.Email,
PasswordHash = userModel.PasswordHash
};
Context.Users.Add(user);
Context.SaveChanges();
return(Mapper.Map <UserDTO>(user));
}
public IActionResult Register([FromBody] BaseUserModel model)
{
IActionResult result = this.Problem();
if (ModelState.IsValid)
{
try
{
User toInsert = model.Map <User>();
toInsert.CountryId = model.Country.Id;
BaseUserModel body = _userService.Create(toInsert)
.Map <BaseUserModel>();
result = this.Ok(body);
}
catch (Exception ex)
{
result = this.ValidationProblem();
}
}
return(result);
}
public string GenerateToken(BaseUserModel user)
{
SecurityKey key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(authConfig.AccessTokenSecrtet));
SigningCredentials credentials = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
List <Claim> claims = new List <Claim>()
{
new Claim("id", user.Id.ToString()),
new Claim(ClaimTypes.Email, user.Email)
};
JwtSecurityToken token = new JwtSecurityToken(
authConfig.Issuer,
authConfig.Audience,
claims,
DateTime.UtcNow,
DateTime.UtcNow.AddMinutes(authConfig.AccessTokenExpirationMinutes),
credentials
);
return(new JwtSecurityTokenHandler().WriteToken(token));
}
public abstract int insertUser(BaseUserModel user);
public abstract int updateUser(BaseUserModel user);
private BaseUserModel CreateNewUser()
{
var result = new BaseUserModel();
return(result);
}
private void SendRegistrationEmail(BaseUserModel model, string restrictionKey)
{
SendRegistrationEmail(model.EmailAddress, model.FirstName, model.LastName, restrictionKey);
}
private void ButtonAdd_Click(object sender, EventArgs e)
{
StudentUserModel student = new StudentUserModel();
student.FirstName = textBoxStudentFirstName.Text.Trim();
student.LastName = textBoxStudentLastName.Text.Trim();
student.AcademicId = textBoxStudentId.Text;
try
{
student.IsValid();
UserController controller = new UserController();
try
{
BaseUserModel createdStudent = controller.Create(student);
SectionStudentController controller1 = new SectionStudentController();
controller1.Create(section.Id, createdStudent.Id);
ClassController ccontroller = new ClassController();
List <ClassModel> classList = ccontroller.GetBySectionId(section.Id);
AttendanceController acontroller = new AttendanceController();
foreach (ClassModel Class in classList)
{
AttendanceModel attendance = new AttendanceModel();
attendance.StudentId = createdStudent.Id;
attendance.ClassId = Class.Id;
try
{
acontroller.Create(attendance);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
MessageBox.Show(student.FullName + " added in " + section.SectionName);
var students = new FormStudentList(faculty, section);
students.FormClosed += new FormClosedEventHandler(dash_FormClosed);
students.Show();
this.Hide();
}
catch (NullReferenceException ex)
{
MessageBox.Show(ex.Message);
}
}
catch (SQLiteException ex)
{
try
{
UserController controller = new UserController();
var gotStudent = controller.GetByAcademicId(student.AcademicId);
string message = "Student already exists in our database. Are you sure you want to add " + gotStudent.FullName + "(" + gotStudent.AcademicId + ")?";
DialogResult dialogResult = MessageBox.Show(message, "Confirm", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
SectionStudentController controller1 = new SectionStudentController();
controller1.Create(section.Id, gotStudent.Id);
MessageBox.Show(gotStudent.FullName + " added in " + section.SectionName);
var students = new FormStudentList(faculty, section);
students.FormClosed += new FormClosedEventHandler(dash_FormClosed);
students.Show();
this.Hide();
}
catch (SQLiteException exc)
{
if (exc.ErrorCode == 19)
{
MessageBox.Show("Error: Student already exists in this section");
}
}
catch (Exception exv)
{
MessageBox.Show(exv.Message);
}
}
else if (dialogResult == DialogResult.No)
{
this.Hide();
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public abstract int deleteUser(BaseUserModel user);
