public void updateAccount(tblUser _user) { Session["User"] = _user; loginUser.Text = _user.DisplayName; userStateTitle.Text = "Thông tin tài khoản"; loginPanel.Visible = false; userPanel.Visible = true; }
/// <summary> /// Cập nhật user /// </summary> /// <param name="_username"></param> /// <param name="update"></param> /// <returns></returns> public static Boolean updateUser(string _username, tblUser update) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { var user = DB.tblUsers.Single(u => u.Username == _username); user.Password = update.Password; user.DisplayName = update.DisplayName; user.Email = update.Email; user.Type = update.Type; user.Role = update.Role; user.Permission = update.Permission; user.State = update.State; user.RegisterDate = update.RegisterDate; user.NumberOfArticles = update.NumberOfArticles; user.Note = update.Note; DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Đăng ký user mới /// </summary> /// <param name="_username"></param> /// <param name="_displayName"></param> /// <param name="_email"></param> /// <param name="_sex"></param> /// <param name="_password"></param> /// <returns></returns> public static Boolean register(string _username, string _displayName, string _email, Boolean _sex, string _password) { LTDHDataContext DB = new LTDHDataContext(@strPathDB); try { using (TransactionScope ts = new TransactionScope()) { tblUser user = new tblUser(); user.Username = _username; user.DisplayName = _displayName; user.Sex = _sex; user.Email = _email; user.Password = encryptPassword(_password); user.Note = "Password: "******"Normal"; user.RegisterDate = DateTime.Today; user.NumberOfArticles = 0; user.State = 0; DB.tblUsers.InsertOnSubmit(user); DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
/// <summary> /// Thêm một user mới /// </summary> /// <param name="record"></param> /// <returns></returns> public static Boolean insertUser(tblUser record) { LTDHDataContext DB = new LTDHDataContext(strPathDB); try { using (TransactionScope ts = new TransactionScope()) { DB.tblUsers.InsertOnSubmit(record); DB.SubmitChanges(); ts.Complete(); } } catch (Exception e) { return false; } return true; }
partial void DeletetblUser(tblUser instance);
partial void UpdatetblUser(tblUser instance);
partial void InserttblUser(tblUser instance);