public SPRW_USER GetUser(string userEmail) { var user = new SPRW_USER(); try { using (var context = new sparrow_dbEntities()) { var selectedUser = context.SPRW_USER.FirstOrDefault(i => i.EMAIL.ToLower().Equals(userEmail.ToLower())); if (selectedUser != null) { user.ACT_IND = selectedUser.ACT_IND; user.CC = selectedUser.CC; user.EMAIL = selectedUser.EMAIL; user.FIRST_NAME = selectedUser.FIRST_NAME; user.LAST_MAINT_TIME = selectedUser.LAST_MAINT_TIME; user.LAST_MAINT_USER_ID = selectedUser.LAST_MAINT_USER_ID; user.LAST_NAME = selectedUser.LAST_NAME; user.PASSWORD = selectedUser.PASSWORD; user.SALT = selectedUser.SALT; } } } catch (Exception e) { throw e; } return(user); }
public int CreateUser(CreateUserModel model, int salt) { try { int id = -1; using (var context = new sparrow_dbEntities()) { var user = new SPRW_USER { FIRST_NAME = model.FirstName, LAST_NAME = model.LastName, EMAIL = model.Email, SALT = salt, CC = "", PASSWORD = model.Password, LAST_MAINT_TIME = DateTime.Now, LAST_MAINT_USER_ID = model.Email }; context.SPRW_USER.Add(user); context.SaveChanges(); id = user.USER_ID; } return(id); } catch (Exception e) { throw e; } }