public bool createUser(int UserID, int UserType, string password, string name, string email, DateTime Expires_At, int SysAdmin_ID)
{
if (sysAdminExist(email))
return false;
string Salt = CreateSalt(10);
string hshdpwd = CreatePasswordHash(password, Salt);
try
{
USER create = new USER();
create.USER_ID = UserID;
create.USER_TYPE = UserType;
create.PASSWORD = hshdpwd;
create.SALT = Salt;
create.USERNAME = email;
create.NAME = name;
create.EXPIRES_AT = Expires_At;
create.CREATED_AT = DateTime.Now;
create.MODIFIED_AT = DateTime.Now;
create.SYSADMIN_ID = SysAdmin_ID;
create.RESET_PASSWORD_KEY = "Created";
dbpollContext.AddToUSERS(create);
dbpollContext.SaveChanges();
}
catch (Exception e)
{
throw (e);
}
return true;
}
public int verify_as_sys_admin(string username, string password)
{
CultureInfo ci = Thread.CurrentThread.CurrentCulture;
ci = new CultureInfo("en-AU");
Thread.CurrentThread.CurrentCulture = ci;
string Salt = "";
string hshdpwd = "";
userModel user = null;
try
{
var userList = from u in dbpollContext.SYSADMINS
where (u.USERNAME == username)
select new userModel
{
UserID = u.SYSADMINS_ID,
Salt = u.SALT,
password = u.PASSWORD
};
user = userList.ToList()[0];
}
catch (Exception e)
{
return 0;
}
Salt = user.Salt;
hshdpwd = CreatePasswordHash(password, Salt);
//compared hashed password from input, against password from db
if (hshdpwd.Equals(user.password))
return user.UserID;
else
return 0;
//var query = from u in dbpollContext.SYSADMINS
// where (u.USERNAME == username && u.PASSWORD == password)
// select u;
//if (query.ToArray().Length == 1)
//{
// return query.ToArray()[0].SYSADMINS_ID;
//}
//else
//{
// return 0;
//}
}
/// <summary>
/// Takes a username and checks the user exists in the system and returns
/// the user's userid code.
/// </summary>
/// <param name="username">username of user to verify</param>
/// <returns>USERID that corresponds to user
/// or returns 0 if they do not exist</returns>
public int verify(string username)
{
CultureInfo ci = Thread.CurrentThread.CurrentCulture;
ci = new CultureInfo("en-AU");
Thread.CurrentThread.CurrentCulture = ci;
userModel user = null;
try
{
var query = from u in dbpollContext.USERS
where (u.USERNAME == username)
select new userModel
{
UserID = u.USER_ID,
Expires_At = (DateTime)u.EXPIRES_AT
};
user = query.ToList()[0];
return user.UserID;
}
catch (Exception e)
{
return 0;
}
}
/// <summary>
/// Takes a username and password, checks the user exists in the system and returns
/// the user's userid code.
/// </summary>
/// <param name="username">username of user to verify</param>
/// <param name="password">password of user to verify</param>
/// <returns>USERID that corresponds to user
/// or returns 0 if they do not exist</returns>
public int verify(string username, string password)
{
CultureInfo ci = Thread.CurrentThread.CurrentCulture;
ci = new CultureInfo("en-AU");
Thread.CurrentThread.CurrentCulture = ci;
string Salt = "";
string hshdpwd = "";
userModel user = null;
try
{
var userList = from u in dbpollContext.USERS
where (u.USERNAME == username)
where u.USER_TYPE != -1
select new userModel
{
UserID = u.USER_ID,
Salt = u.SALT,
password = u.PASSWORD,
Reset_Password_Key = u.RESET_PASSWORD_KEY
};
user = userList.ToList()[0];
}
catch (Exception e)
{
return 0;
}
Salt = user.Salt;
hshdpwd = CreatePasswordHash(password, Salt);
//compared hashed password from input, against password from db
if (hshdpwd.Equals(user.password))
return user.UserID;
else
return 0;
}
/// <summary>
/// Deprecated Method for adding a new object to the USERS EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToUSERS(USER uSER)
{
base.AddObject("USERS", uSER);
}
/// <summary>
/// Create a new USER object.
/// </summary>
/// <param name="uSER_ID">Initial value of the USER_ID property.</param>
/// <param name="uSER_TYPE">Initial value of the USER_TYPE property.</param>
/// <param name="cREATED_AT">Initial value of the CREATED_AT property.</param>
public static USER CreateUSER(global::System.Int32 uSER_ID, global::System.Int32 uSER_TYPE, global::System.DateTime cREATED_AT)
{
USER uSER = new USER();
uSER.USER_ID = uSER_ID;
uSER.USER_TYPE = uSER_TYPE;
uSER.CREATED_AT = cREATED_AT;
return uSER;
}
