/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool CheckUserPass(string username, string password)
{
Users user = new Users();
user.USERNAME = username;
user.PASSWORD = password;
return user.CheckUserPass();
}
/// <summary>
///
/// </summary>
/// <param name="firstname"></param>
/// <param name="lastname"></param>
/// <param name="username"></param>
/// <param name="title"></param>
/// <param name="email"></param>
/// <param name="phone"></param>
/// <param name="city"></param>
/// <param name="province"></param>
/// <param name="country"></param>
/// <returns>
/// 0 : add user fail
/// 1 : add user successful
/// 2 : this email is registered
/// 3 : this user is registered
/// </returns>
public static int AddUser(string firstname, string lastname, string username, string password, string title,
string email, string phone, string city, string province, string country)
{
Users user = new Users();
user.FIRSTNAME = firstname;
user.LASTNAME = lastname;
user.USERNAME = username;
user.PASSWORD = password;
user.TITLE = title;
user.EMAIL = email;
user.PHONE = phone;
user.CITY = city;
user.PROVINCE = province;
user.COUNTRY = country;
//check username is existed
if (user.IsExistEmail()) return 2;
//check email is existed
if (user.IsExistUsername()) return 3;
//inseert new user
if(user.Insert()) return 1;
return 0;
}
public DataTable Select()
{
DataTable dt;
try
{
objclsUSERS = new Users();
objclsUSERS.ID = ID;
dt = objclsUSERS.Select();
return dt;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool Update()
{
try
{
objclsUSERS = new Users();
objclsUSERS.ID = ID;
objclsUSERS.FIRSTNAME = FIRSTNAME;
objclsUSERS.LASTNAME = LASTNAME;
objclsUSERS.USERNAME = USERNAME;
objclsUSERS.PASSWORD = PASSWORD;
objclsUSERS.TITLE = TITLE;
objclsUSERS.EMAIL = EMAIL;
objclsUSERS.PHONE = PHONE;
objclsUSERS.CITY = CITY;
objclsUSERS.PROVINCE = PROVINCE;
objclsUSERS.POSTCODE = POSTCODE;
objclsUSERS.COUNTRY = COUNTRY;
objclsUSERS.MODIFIEDDATE = MODIFIEDDATE;
if(objclsUSERS.Update())
{
return true;
}
return false;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool Delete()
{
try
{
objclsUSERS = new Users();
objclsUSERS.ID = ID;
if(objclsUSERS.Delete())
{
return true;
}
return false;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}