public int CreateUser(UserModel um) { int result = DaoUtilities.NO_CHANGES; USER1 u = db.USER1.Create(); u.USER_ID = um.UserId; u.USER_PASSWORD = hashSHA512(um.Password); u.USER_FIRSTNAME = um.FirstName; u.USER_LASTNAME = um.LastName; u.USER_ADR1 = um.Adress1; u.USER_ADR2 = um.Adress2; u.USER_PC = um.PC; u.USER_TOWN = um.Town; u.USER_PHONE = um.Phone; u.USER_MAIL = um.Mail; db.USER1.Add(u); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } return result; }
public int RemoveUserOfEvent(string EventId, UserModel um) { int result = DaoUtilities.NO_CHANGES; EVENT ev = db.EVENT.Find(EventId); if (ev != null) { USER1 u = db.USER1.Find(um.UserId); if (u != null) { u.EVENT.Remove(ev); ev.USER1.Remove(u); ev.EVENT_MAXNBR = ev.EVENT_MAXNBR + 1; try { int saveResult = db.SaveChanges(); if (saveResult >= 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } } } return result; }
public bool IsMember(UserModel um) { if (db.MEMBER.Find(um.UserId) != null) return true; return false; }
public bool IsManager(UserModel um) { if (db.MANAGER.Find(um.UserId) != null) return true; return false; }
public bool IsContributor(UserModel um) { if (db.CONTRIBUTOR.Find(um.UserId) != null) return true; return false; }
public bool IsAdmin(UserModel um) { if (db.ADMIN.Find(um.UserId) != null) return true; return false; }
/// <summary> /// Convert a user from the database to a UserModel /// </summary> /// <param name="u"></param> /// <returns></returns> public UserModel ConvertUserToUserModel(USER1 u) { UserModel um = new UserModel(); if (u != null) { um.UserId = u.USER_ID; um.Password = u.USER_PASSWORD; um.FirstName = u.USER_FIRSTNAME; um.LastName = u.USER_LASTNAME; um.Adress1 = u.USER_ADR1; um.Adress2 = u.USER_ADR2; um.PC = u.USER_PC; um.Town = u.USER_TOWN; um.Phone = u.USER_PHONE; um.Mail = u.USER_MAIL; var userServices = new UserServices(); um.UserRoles = new RolesModel(); um.UserRoles.IsAdmin = userServices.IsAdmin(um); um.UserRoles.IsContributor = userServices.IsContributor(um); um.UserRoles.IsManager = userServices.IsManager(um); um.UserRoles.IsMember = userServices.IsMember(um); } else um = null; return um; }
public IHttpActionResult Register(UserModel model) { if (!ModelState.IsValid) { return BadRequest(ModelState); } var result = userServices.CreateUser(model); if (result == DaoUtilities.SAVE_SUCCESSFUL) { return Ok(); } if(result == DaoUtilities.UPDATE_EXCEPTION) { var ex = new Exception("User already exists"); return InternalServerError(ex); } return InternalServerError(); }