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