public JsonResult SaveRegistration(FullUserDetail user) { Models.Misc.ValidationResult result = new Models.Misc.ValidationResult(); var foo = new EmailAddressAttribute(); if (!new EmailAddressAttribute().IsValid(user.Email)) { result.HasValidationFailed = true; result.ValidationMsg = "Invalid Email Format."; return(Json(result)); } else if (bl.ValidateUsername(user.Username)) { result.HasValidationFailed = true; result.ValidationMsg = "Please Choose A Different Username."; return(Json(result)); } else { user.Password = EncryptionHelper.Encrypt(user.Password); var userId = bl.SaveRegistration(user); UserInfo newUser = new UserInfo() { UserId = userId, FirstName = user.FirstName }; Session["UserInfo"] = newUser; } return(Json(result)); }
internal FullUserDetail GetUserDetails(int userId) { FullUserDetail detail = new FullUserDetail(); SqlCommand command; SqlDataReader dataReader; string sql = $@" select * from AppUser AU inner join UserDetail UD on UD.AppUserId = AU.AppUserId where AU.AppUserId = {userId} "; command = new SqlCommand(sql, conn); dataReader = command.ExecuteReader(); while (dataReader.Read()) { detail.FirstName = dataReader.GetValue(dataReader.GetOrdinal("FirstName")).ToString(); detail.LastName = dataReader.GetValue(dataReader.GetOrdinal("LastName")).ToString(); detail.Email = dataReader.GetValue(dataReader.GetOrdinal("Email")).ToString(); detail.Username = dataReader.GetValue(dataReader.GetOrdinal("Username")).ToString(); detail.AppUserId = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("AppUserId")).ToString()); detail.UserDetailId = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("UserDetailId")).ToString()); detail.Title = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("Title")).ToString()); detail.Company = dataReader.GetValue(dataReader.GetOrdinal("Company")).ToString(); detail.YrsOfXP = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("XP")).ToString()); detail.Role = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("Role")).ToString()); detail.OrgLevel = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("LevelWithinOrg")).ToString()); } dataReader.Close(); command.Dispose(); return(detail); }
internal void UpdateInfo(int userId, FullUserDetail updatedInfo) { SqlCommand command; string sql = $@"Update UserDetail Set FirstName = '{updatedInfo.FirstName}', LastName = '{updatedInfo.LastName}', Email = '{updatedInfo.Email}', Title = {updatedInfo.Title}, Company ='{updatedInfo.Company}' , XP = {updatedInfo.YrsOfXP}, role = {updatedInfo.Role}, LevelWithinOrg = {updatedInfo.OrgLevel} Where AppUserId = {userId}; "; if (!string.IsNullOrEmpty(updatedInfo.Password)) { sql += $@"Update AppUser Set Password = '******' where AppUserId = {userId};"; } command = new SqlCommand(sql, conn); command.ExecuteScalar(); command.Dispose(); }
internal List <FullUserDetail> GetUsersList(IEnumerable <int> userIds = null) { List <FullUserDetail> AllUsersdetail = new List <FullUserDetail>(); SqlCommand command; SqlDataReader dataReader; string sql = $@" select * from AppUser AU inner join UserDetail UD on UD.AppUserId = AU.AppUserId "; if (userIds != null) { sql += $"Where AU.AppUserId in({string.Join(",", userIds)})"; } command = new SqlCommand(sql, conn); dataReader = command.ExecuteReader(); while (dataReader.Read()) { FullUserDetail detail = new FullUserDetail { FirstName = dataReader.GetValue(dataReader.GetOrdinal("FirstName")).ToString(), LastName = dataReader.GetValue(dataReader.GetOrdinal("LastName")).ToString(), Email = dataReader.GetValue(dataReader.GetOrdinal("Email")).ToString(), Username = dataReader.GetValue(dataReader.GetOrdinal("Username")).ToString(), AppUserId = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("AppUserId")).ToString()), UserDetailId = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("UserDetailId")).ToString()), Title = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("Title")).ToString()), Company = dataReader.GetValue(dataReader.GetOrdinal("Company")).ToString(), YrsOfXP = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("XP")).ToString()), Role = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("Role")).ToString()), OrgLevel = Convert.ToInt32(dataReader.GetValue(dataReader.GetOrdinal("LevelWithinOrg")).ToString()), CreatedOn = Convert.ToDateTime(dataReader.GetValue(dataReader.GetOrdinal("CreatedOn")).ToString()), LastLogin = Convert.ToDateTime(dataReader.GetValue(dataReader.GetOrdinal("LastLogin")).ToString()) }; AllUsersdetail.Add(detail); } dataReader.Close(); command.Dispose(); return(AllUsersdetail); }
internal int SaveRegistration(FullUserDetail user) { SqlDataAdapter adapter = new SqlDataAdapter(); string sql = $@"DECLARE @AppUserId int insert into appuser values('{user.Username}', '{user.Password}', 0) SET @AppUserId = SCOPE_IDENTITY() Insert into UserDetail Values (@AppUserId, '{user.FirstName}', '{user.LastName}','{user.Email}', {user.Title}, '{user.Company}', {user.YrsOfXP}, {user.Role}, {user.OrgLevel}, GetDate(), GetDate()) select @AppUserId "; adapter.InsertCommand = new SqlCommand(sql, conn); var newId = (int)adapter.InsertCommand.ExecuteScalar(); adapter.Dispose(); return(newId); }
internal int SaveRegistration(FullUserDetail user) { return(dal.SaveRegistration(user)); }
public void UpdateInfo(FullUserDetail UpdatedInfo) { var userInfo = Session["UserInfo"] as UserInfo; codeAtWorkAccountBL.UpdateInfo(userInfo.UserId, UpdatedInfo); }
internal void UpdateInfo(int userId, FullUserDetail updatedInfo) { dal.UpdateInfo(userId, updatedInfo); }