public qtUser GetUserLogin(string UserLogin, string Password)
{
qtUserService _user = new qtUserService();
var check = _user.FindList().Where(x => x.UserLogin == UserLogin && x.Password == Password).FirstOrDefault();
return(check);
}
public IPagedList <qtUnitManager> DanhSachNguoiDung(int page, int pageSize)
{
qtUserService _user = new qtUserService();
qtUnitService _unit = new qtUnitService();
qtUnitManagerService _mangager = new qtUnitManagerService();
var danhsach = (from mangager in _mangager.FindList()
join user in _user.FindList() on mangager.UserId equals user.UserId
select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault());
return(danhsach.ToPagedList(page, pageSize));
}
public bool CheckUserLogin(string UserLogin, string Password)
{
qtUserService _user = new qtUserService();
var check = _user.FindList().Where(x => x.UserLogin == UserLogin && x.Password == Password).Count();
if (check > 0)
{
return(true);
}
return(false);
}
public int SoluongNguoiDung(int?unitId)
{
qtUserService _user = new qtUserService();
qtUnitService _unit = new qtUnitService();
qtUnitManagerService _mangager = new qtUnitManagerService();
var danhsach = (from mangager in _mangager.FindList()
join user in _user.FindList() on mangager.UserId equals user.UserId
where user.UnitId == unitId
select mangager).AsQueryable().GroupBy(m => m.UserId).Select(m => m.FirstOrDefault());
return(danhsach.Count());
}
public qtUser GetUser(string UserLogin, string Password)
{
qtUserService _user = new qtUserService();
qtUser user = null;
var check = _user.FindList().Where(x => x.UserLogin == UserLogin && x.Password == Password);
if (check.Count() > 0)
{
user = check.FirstOrDefault();
}
return(user);
}
public IEnumerable <qtUser> DanhSachUser(string TenNguoiDung, int?UnitId, int?DepartmentId)
{
qtUserService _user = new qtUserService();
IEnumerable <qtUser> dsUser = _user.FindList()
.Where(x => (string.IsNullOrWhiteSpace(TenNguoiDung) ||
TypeHelper.CompareString(x.UserName, TenNguoiDung))
);
if (UnitId.HasValue)
{
dsUser = dsUser.Where(x => x.UnitId == UnitId);
}
if (DepartmentId.HasValue)
{
dsUser = dsUser.Where(x => x.DepartmentId == DepartmentId);
}
return(dsUser);
}
