///<summary>
///Retrieve user from file
///</summary>
///<param name="email">string</param>
///<param name="email">string</param>
///<returns>User class object</returns>
///<remarks>
///</remarks>
public User retreiveUser(string email, string password)
{
User rUser = null;
//find user from database
DataTableOperations source =
new DataTableOperations(Properties.Settings.Default.ConnectionString,
Properties.Settings.Default.LoginSQL, "Login");
DataTable t = new DataTable();
t = source.Datatable;
foreach (DataRow item in t.Rows)
{
if (item["email"].ToString().Equals(email))
{
if (item["password"].ToString().Equals(User.HashPass(password, email)))
{
rUser = new User(email, password);
}
}
else
{
Console.Write("Record not found");
}
}
return(rUser);
}
///<summary>
///Add user to Database
///</summary>
///<param name=""></param>
///<returns>Boolean value</returns>
///<remarks>
///
///</remarks>
public static bool SubmitUser()
{
bool saved = false;
string[] field = new string[] { "email", "password" };
string[] values = new string[] { user.Email, user.Password };
DataTableOperations target = new DataTableOperations(Properties.Settings.Default.ConnectionString);
target.InsertString("Login", field, values);
return(saved);
}
///<summary>
///Retrieve user from file
///</summary>
///<param name="email">string</param>
///<param name="email">string</param>
///<returns>User class object</returns>
///<remarks>
///</remarks>
public User retreiveUser(string email, string password)
{
User rUser = null;
//find user from database
DataTableOperations source =
new DataTableOperations(Properties.Settings.Default.ConnectionString,
Properties.Settings.Default.LoginSQL, "Login");
DataTable t = new DataTable();
t = source.Datatable;
foreach (DataRow item in t.Rows)
{
if (item["email"].ToString().Equals(email))
{
if (item["password"].ToString().Equals(User.HashPass(password,email)))
{
rUser = new User(email, password);
}
}
else
{
Console.Write("Record not found");
}
}
return rUser;
}
///<summary>
///Add user to Database
///</summary>
///<param name=""></param>
///<returns>Boolean value</returns>
///<remarks>
///
///</remarks>
public static bool SubmitUser()
{
bool saved = false;
string[] field = new string[] {"email","password"};
string[] values = new string[] {user.Email, user.Password};
DataTableOperations target = new DataTableOperations(Properties.Settings.Default.ConnectionString);
target.InsertString("Login", field, values);
return saved;
}