public User(string user, string pswd)
{
_username = user;
_password = pswd;
db.DBError = "";
ExecutionError = "";
DataTable userTable = db.ReadTable("Users", String.Format("SELECT DISTINCT * FROM Users WHERE Username='******' AND Password='******'", _username, AppHandler.Sha1(_password)));
if (userTable.Rows.Count > 0)
{
_id = AppHandler.ToInt(userTable.Rows[0]["UserID"]);
_name = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Name"]);
_phone = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Phone"]);
_email = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Email"]);
_username = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Username"]);
_usertype = AppHandler.IgnoreDBNullString(userTable.Rows[0]["UserType"]);
_status = (short)AppHandler.ToInt(userTable.Rows[0]["Status"]);
_logs = AppHandler.ToInt(userTable.Rows[0]["Logs"]);
_date_added = AppHandler.ToDateTime(userTable.Rows[0]["DateAdded"].ToString());
_firm_id = AppHandler.ToInt(userTable.Rows[0]["FirmID"]);
_role_id = AppHandler.ToInt(userTable.Rows[0]["RoleID"]);
_exists = true;
}
else if (db.DBError.Length > 0)
{
ExecutionError = db.DBError;
}
}
public User(string user)
{
_username = user;
DataTable userTable = db.ReadTable("Users", String.Format("SELECT * FROM Users WHERE Username='******'", _username));
if (userTable.Rows.Count > 0)
{
_id = AppHandler.ToInt(userTable.Rows[0]["UserID"]);
_name = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Name"]);
_phone = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Phone"]);
_email = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Email"]);
_username = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Username"]);
_password = AppHandler.IgnoreDBNullString(userTable.Rows[0]["Password"]);
_usertype = AppHandler.IgnoreDBNullString(userTable.Rows[0]["UserType"]);
_status = (short)AppHandler.ToInt(userTable.Rows[0]["Status"]);
_logs = AppHandler.ToInt(userTable.Rows[0]["Logs"]);
_date_added = AppHandler.ToDateTime(userTable.Rows[0]["DateAdded"].ToString());
_firm_id = AppHandler.ToInt(userTable.Rows[0]["FirmID"]);
_role_id = AppHandler.ToInt(userTable.Rows[0]["RoleID"]);
_exists = true;
//if (System.IO.File.Exists("~/Admin/Passports/" + _username + ".jpg"))
// _image_url = "~/Admin/Passports/" + _username + ".jpg";
//else
// _image_url = "~/images/avater.png";
}
}