public bool Login(string username, string password)
{
bool isValidated = false;
NpgsqlCommand sql = new NpgsqlCommand();
sql.CommandText = "SELECT * FROM " + tablename + " WHERE Username = @Username AND Password = @Password";
//sql.Parameters.AddWithValue("@Tablename", tablename);
sql.Parameters.AddWithValue("@Username", username);
sql.Parameters.AddWithValue("@Password", password);
using (PgDb db = new PgDb())
{
try
{
sql.Connection = db.connection;
using (NpgsqlDataReader reader = sql.ExecuteReader())
{
if (reader.HasRows)
{
isValidated = true;
}
}
}
catch (Exception e)
{
}
}
return(isValidated);
}
public UserModel GetModelByUsername(string username)
{
UserModel model = new UserModel();
string query = "select " + defaultFields + " from " + tablename + " WHERE Username = @Username";
using (PgDb db = new PgDb())
{
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Username", username);
cmd.Connection = db.connection;
using (NpgsqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
model = Fill(reader);
}
}
}
return(model);
}
