public List <User> userVerify(string userName, string password) { User newUser = new User(); var userData = new UserData.TabUserDataTable(); var userTableAdapter = new TabUserTableAdapter(); List <User> userValue = new List <User>(); int rowCount = 0; if (userName != null && password != null) { rowCount = userTableAdapter.ValidateUsers(userData, userName, password); } if (rowCount > 0) { foreach (DataRow dr in userData.Rows) { newUser.UID = int.Parse(dr["UID"].ToString()); newUser.userEmail = dr["UserEmail"].ToString(); newUser.userLevel = int.Parse(dr["UserLevel"].ToString()); userValue.Add(newUser); } return(userValue); } return(null); }
public int UpdateUser(int UID, string userName, string userEmail, int userLevel, string password) { var userData = new UserData.TabUserDataTable(); var userTableAdapter = new TabUserTableAdapter(); if (UID > 0) { int countRow = userTableAdapter.UpdateUser(userName, password, userLevel, userEmail, UID); return(countRow); } return(0); }
public int InsertUser(string userName, string userEmail, int userLevel, string password) { var userData = new UserData.TabUserDataTable(); var userTableAdapter = new TabUserTableAdapter(); if (userName != null && password != null) { int countRow = userTableAdapter.InsertUser(userName, password, userLevel, userEmail); return(countRow); } else { return(0); } }
public bool userVerify(string userName, string password) { User newUser = new User(); var userData = new UserData.TabUserDataTable(); var userTableAdapter = new TabUserTableAdapter(); int rowCount = userTableAdapter.ValidateUsers(userData, userName, password); if (rowCount > 0) { foreach (DataRow dr in userData.Rows) { newUser.UID = int.Parse(dr["UID"].ToString()); newUser.userEmail = dr["UserEmail"].ToString(); newUser.userLevel = int.Parse(dr["UserLevel"].ToString()); } } return(newUser.UID > 0 ? true : false); }
List <User> IUserManager.getUsers() { List <User> users = new List <User>(); var userData = new UserData.TabUserDataTable(); var userDataAdapter = new TabUserTableAdapter(); userDataAdapter.GetUsersBy(userData); foreach (DataRow dr in userData.Rows) { User newUser = new User(); newUser.UID = int.Parse(dr["UID"].ToString()); newUser.userName = dr["UserName"].ToString(); newUser.password = dr["Password"].ToString(); newUser.userEmail = dr["UserEmail"].ToString(); newUser.userLevel = int.Parse(dr["UserLevel"].ToString()); users.Add(newUser); } return(users); }
public void DeleteUser(int UID) { var userData = new UserData.TabUserDataTable(); var userTableAdapter = new TabUserTableAdapter(); int countRow = userTableAdapter.DeleteUser(UID); }