public User loginDA(User user)
{
PasswordProtection pp = new PasswordProtection();
var hashedPassowrd = pp.GenerateSHA256(user.password);
Dictionary <string, SqlParameter> queryParameters = new Dictionary <string, SqlParameter>();
queryParameters["userName"] = new SqlParameter("userName", user.userName);
queryParameters["password"] = new SqlParameter("password", hashedPassowrd);
try
{
SqlDataReader reader = SqlDatabaseUtility.ExecuteQuery("[dbo].[Login]", queryParameters);
while (reader.Read() == true)
{
if (reader.GetInt32(reader.GetOrdinal("id")) > 0)
{
user.id = reader.GetInt32(reader.GetOrdinal("id"));
user.userName = reader.GetString(reader.GetOrdinal("userName"));
user.role = reader.GetInt32(reader.GetOrdinal("role"));
}
else
{
user.userName = null;
user.role = 0;
}
}
}
catch (Exception e)
{
Console.WriteLine("OOPs, something went wrong.\n" + e);
}
return(user);
}
public string UpdatePasswordDA(User user)
{
string msg = "";
PasswordProtection pp = new PasswordProtection();
var hashedPassowrd = pp.GenerateSHA256(user.password);
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["id"] = new SqlParameter("id", user.id);
cmdParameters["password"] = new SqlParameter("password", hashedPassowrd);
int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[UpdateUsers]", cmdParameters);
if (rc == -1)
{
msg = "Password updated successfully...!";
}
else
{
msg = "OOPs, something went wrong...!";
}
return(msg);
}
public string CreateUsersDA(User user)
{
string msg = "";
PasswordProtection pp = new PasswordProtection();
var hashedPassowrd = pp.GenerateSHA256(user.password);
Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>();
cmdParameters["userName"] = new SqlParameter("userName", user.userName);
cmdParameters["password"] = new SqlParameter("password", hashedPassowrd);
cmdParameters["role"] = new SqlParameter("role", user.role);
int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[InsertUser]", cmdParameters);
if (rc == -1)
{
msg = "user create successfully...!";
}
else
{
msg = "OOPs, something went wrong...!";
}
return(msg);
}
