public bool EditUser(NguoiSuDung oldMem, ref string mes)
{
try
{
dtb_member user = db.dtb_members.Where(s => (s.username == oldMem.UserName)).Single();
if (user == null)
{
mes = "Không có người sử dụng";
return(false);
}
user.fullname = oldMem.FullName;
user.password = oldMem.Password;
user.position = oldMem.ChucVu;
user.birthday = oldMem.NgaySinh;
user.email = oldMem.Email;
user.sex = oldMem.GioiTinh;
user.phone = oldMem.SoDienThoai;
user.address = oldMem.DiaChi;
user.is_admin = oldMem.IsAdmin;
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
mes = ex.Message;
return(false);
}
}
public bool DeleteUser(NguoiSuDung oldMem, ref string mes)
{
try
{
dtb_member m = db.dtb_members.Where(s => (s.username == oldMem.UserName)).Single();
if (m == null)
{
return(false);
}
db.dtb_members.DeleteOnSubmit(m);
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
mes = ex.Message;
return(false);
}
}
public NguoiSuDung GetUserInfor(string userName)
{
NguoiSuDung nsd = new NguoiSuDung();
dtb_member mem = db.dtb_members.Where(s => (s.username == userName)).Single();
if (mem == null)
{
return(null);
}
nsd.IsAdmin = Convert.ToBoolean(mem.is_admin);
nsd.UserName = userName;
nsd.ViTri = mem.position;
nsd.FullName = mem.fullname;
nsd.NgaySinh = Convert.ToDateTime(mem.birthday);
nsd.Email = mem.email;
nsd.GioiTinh = mem.sex;
nsd.SoDienThoai = mem.phone;
nsd.DiaChi = mem.address;
nsd.ChucVu = mem.position;
return(nsd);
}
public bool AddNewUser(NguoiSuDung newMem, ref string mes)
{
try
{
List <dtb_member> listMembers = (from s in db.dtb_members select s).ToList();
foreach (var mem in listMembers)
{
if (mem.username == newMem.UserName)
{
mes = "Trùng tên đăng nhập";
return(false);
}
}
dtb_member user = new dtb_member();
user.fullname = newMem.FullName;
user.username = newMem.UserName;
user.password = newMem.Password;
user.position = newMem.ChucVu;
user.birthday = newMem.NgaySinh;
user.email = newMem.Email;
user.sex = newMem.GioiTinh;
user.phone = newMem.SoDienThoai;
user.address = newMem.DiaChi;
user.is_admin = newMem.IsAdmin;
db.dtb_members.InsertOnSubmit(user);
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
