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);
}
