public bool LoginUser(UserLogin login)
{
bool status;
string query = @"EXEC usp_LoginProcess '@1', '@2'";;
SqlConnection connection = new SqlConnection(conn_string);
login.Password = CryptoRepository.Encrypt(login.Password);
query = query.Replace("@1", login.Username)
.Replace("@2", login.Password);
try
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection)
{
CommandType = CommandType.StoredProcedure
};
command.ExecuteNonQuery();
command.Dispose();
connection.Close();
status = true;
}
catch (Exception)
{
status = false;
}
return(status);
}
public bool AddUser(User user)
{
bool status;
string query = @"EXEC usp_RegisterProcess '@1', '@2', @3;";
SqlConnection connection = new SqlConnection(conn_string);
user.Password = CryptoRepository.Encrypt(user.Password);
query = query.Replace("@1", user.Username)
.Replace("@2", user.Password)
.Replace("@3", (user.Age).ToString());
try
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection)
{
CommandType = CommandType.StoredProcedure
};
command.ExecuteNonQuery();
command.Dispose();
connection.Close();
status = true;
}
catch (Exception)
{
status = false;
}
return(status);
}