public UserModel UpdateUser(UserModel user)
{
using (var context = new connected_usersContext())
{
Customers exist = context.Customers.Where(x => x.Name == user.UserName &&
x.Dob.Day.ToString("D2") + "/" + x.Dob.Month.ToString("D2") + "/" + x.Dob.Year == user.DOB).FirstOrDefault();
if (exist == null || exist.CustomerId <= -1)
{
return(null);
}
var verify = context.Users.Find(exist.CustomerId);
if (verify != null || verify.UserId > -1)
{
verify.RoleId = context.Roles.Where(x => x.RoleName == user.Role).Select(y => y.RoleId).FirstOrDefault();
context.SaveChanges();
}
else
{
return(null);
}
return(user);
}
}
public dynamic Login(string username, string password, DateTime dt)
{
using (var context = new connected_usersContext())
{
Customers cust = context.Customers.Where(x => x.Name.ToLower() == username.ToLower() && x.Dob == dt).FirstOrDefault();
if (cust != null)
{
Users user = context.Users.Where(x => x.UserId == cust.CustomerId &&
x.Password == password).FirstOrDefault();
if (user != null)
{
Roles roles = context.Roles.Where(x => x.RoleId == user.RoleId).FirstOrDefault();
if (roles != null)
{
dynamic obj = new ExpandoObject();
obj.Name = cust.Name;
obj.Role = roles.RoleName;
obj.Id = cust.CustomerId;
obj.RoleId = roles.RoleId;
return(obj);
}
}
}
return(null);
}
}
public bool AddUser(UserModel user, string createdPersonUserId)
{
using (var context = new connected_usersContext())
{
try
{
int custID = context.Customers.Where(x => x.Name == user.UserName &&
x.Dob.Day.ToString("D2") + "/" + x.Dob.Month.ToString("D2") + "/" + x.Dob.Year == user.DOB).Select(x => x.CustomerId).FirstOrDefault();
context.Users.Add(new Users()
{
UserId = custID,
Password = "******",
RoleId = user.RoleId,
CreatedBy = Convert.ToInt32(createdPersonUserId),
CreatedTime = DateTime.Now,
});
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public List <UserModel> SearchUsers(UserModel search)
{
using (var context = new connected_usersContext())
{
List <UserModel> users = context.Customers.Where(x => x.Name.Equals(search.UserName)).Select(m => new UserModel()
{
UserName = m.Name,
DOB = Convert.ToString(m.Dob),
UserId = m.CustomerId,
}).ToList();
return(users);
}
}
public List <UserModel> GetUsers()
{
using (var context = new connected_usersContext())
{
List <UserModel> users = context.Users
.Join(context.Customers, u => u.UserId, c => c.CustomerId, (u, c) => new { u, c })
.Join(context.Roles, n => n.u.RoleId, ro => ro.RoleId, (n, ro) => new { n, ro })
.Select(m => new UserModel()
{
UserName = m.n.c.Name,
DOB = Convert.ToString(m.n.c.Dob),
UserId = m.n.c.CustomerId,
CreatedBy = Convert.ToString(m.n.c.CreatedBy),
Role = m.n.u.Role.RoleName,
RoleId = m.n.u.Role.RoleId,
}).ToList();
// List<string> CreatedByIds = users.Select(o => o.CreatedBy).ToList();
var createdByNameList = context.Customers
.Select(m => new
{
CreatedByString = m.Name,
CreatedById = m.CustomerId,
}).Distinct();
foreach (UserModel umodel in users)
{
umodel.CreatedBy = createdByNameList.Where(x => x.CreatedById.ToString() == umodel.CreatedBy).Select(y => y.CreatedByString).FirstOrDefault();
}
//IQueryable<UserModel> usersUpdated = users
// .Join(createdByNameList, u => u.CreatedBy, c => c.CreatedById.ToString(), (u, c) => new { u, c })
// .Select(m => new UserModel()
// {
// UserName = m.u.UserName,
// DOB = m.u.DOB,
// UserId = m.u.UserId,
// CreatedBy = m.c.CreatedByString,
// Role = m.u.Role,
// });
return(users);
}
}
public bool VerifyIfCustomerExist(UserModel user)
{
using (var context = new connected_usersContext())
{
Customers exist = context.Customers.Where(x => x.Name == user.UserName &&
x.Dob.Day.ToString("D2") + "/" + x.Dob.Month.ToString("D2") + "/" + x.Dob.Year == user.DOB).FirstOrDefault();
if (exist == null || exist.CustomerId <= -1)
{
return(false);
}
return(true);
}
}
public bool DeleteUsers(Users user)
{
using (var context = new connected_usersContext())
{
var entity = context.Users.Find(user.UserId);
if (entity == null)
{
return(false);
}
context.Users.Remove(entity);
context.SaveChanges();
return(true);
}
}
public bool VerifyIfUserAlreadyAssignedRole(UserModel user)
{
using (var context = new connected_usersContext())
{
bool userAlreadyExist = false;
var exist = context.Customers.Where(x => x.Name == user.UserName &&
x.Dob.Day.ToString("D2") + "/" + x.Dob.Month.ToString("D2") + "/" + x.Dob.Year == user.DOB).FirstOrDefault();;
if (exist != null && exist.CustomerId > -1)
{
Users userExist = context.Users.Find(exist.CustomerId);
if (userExist != null)
{
userAlreadyExist = true;
}
}
return(userAlreadyExist);
}
}
public bool UpdatePassword(UpdatePasswordModel user, bool isReset)
{
using (var context = new connected_usersContext())
{
var entity = context.Users.Find(user.UserId);
if (entity == null)
{
return(false);
}
if (entity.UserId == user.UserId)
{
if (isReset)
{
entity.Password = "******";
}
else if (entity.Password == user.oldPassword &&
user.newPassword == user.confirmPassword)
{
entity.Password = user.newPassword;
}
else
{
return(false);
}
context.SaveChanges();
}
else
{
return(false);
}
//context.Customers.Update(cust);
//context.SaveChanges();
return(true);
}
}
