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";
}
}
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 static string NextSession(string session)
{
string[] newSession = session.Split('/');
newSession[0] = (AppHandler.ToInt(newSession[0]) + 1).ToString();
newSession[1] = (AppHandler.ToInt(newSession[1]) + 1).ToString();
return(newSession[0] + "/" + newSession[1]);
}
public static DateTime GetRetirementDate(DateTime birthdate, DateTime firstAppDate)
{
int yr = birthdate.Year;
int age = AppHandler.GetAge(birthdate);
int rYear = (60 - age) + DateTime.Now.Year;
DateTime dt = new DateTime(firstAppDate.Year + 35, firstAppDate.Month, firstAppDate.Day);
if (dt.Year - birthdate.Year <= 60)
{
return(dt);
}
return(new DateTime(rYear, birthdate.Month, birthdate.Day));
}
public static string ToMySqlTime(DateTime dt)
{
string ampm = dt.ToLongTimeString().Contains("PM") ? "PM" : "AM";
string[] strTime = dt.ToLongTimeString().Split(' ')[0].Split(':');
int hr = AppHandler.ToInt(strTime[0]);
if (hr < 10 && ampm == "AM")
{
return("0" + Implode(strTime, ":"));
}
else if (hr < 10 && ampm == "PM")
{
return((12 + hr) + ":" + strTime[1] + ":" + strTime[2]);
}
else if (hr == 12 && ampm == "PM")
{
return("00:" + strTime[1] + ":" + strTime[2]);
}
return(Implode(strTime, ":"));
}
//Methods
public bool Add()
{
string strQuery = String.Format("INSERT INTO [Users]([Name],[Phone],[Email],[Username],[Password],[UserType],[Status],[Logs],[DateAdded]) " +
"VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', 0, 0, '{6}')", _name, _phone, _email, _username, AppHandler.Sha1(_password), _usertype, _date_added);
try
{
return(db.ExecuteQuery(strQuery));
}
catch (Exception ex)
{
ExecutionError = ex.Message;
}
return(false);
}
public bool DoLogin()
{
bool loggedIn = false;
try
{
DataTable userTable = db.ReadTable("Users", String.Format("SELECT Name FROM Users WHERE Username='******' AND Password='******'", _username, AppHandler.Sha1(_password)));
loggedIn = userTable.Rows.Count > 0;
}
catch (Exception ex)
{
ExecutionError = ex.Message;
}
return(loggedIn);
}
public bool ChangePassword(string pswd)
{
return(db.ExecuteQuery("UPDATE Users SET Password='******' WHERE Username='******'"));
}