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