public Employee login(string username, string password)
{
log.InfoFormat("Entering findOne with value {0}", username);
IDbConnection con = DBUtils.getConnection(props);
using (var comm = con.CreateCommand())
{
comm.CommandText = "select id,username, password from employees where username=@username and password=@password";
var paramUsername = comm.CreateParameter();
paramUsername.ParameterName = "@username";
paramUsername.Value = username;
comm.Parameters.Add(paramUsername);
var paramPassword = comm.CreateParameter();
paramPassword.ParameterName = "@password";
paramPassword.Value = password;
comm.Parameters.Add(paramPassword);
using (var dataR = comm.ExecuteReader())
{
if (dataR.Read())
{
int idE = dataR.GetInt32(0);
String usernameFound = dataR.GetString(1);
String passwordFound = dataR.GetString(2);
Employee employee = new Employee(idE, usernameFound, passwordFound);
log.InfoFormat("Exiting findOne with value {0}", employee);
Console.Write("login successful for " + usernameFound + "\n");
return(employee);
}
}
}
log.InfoFormat("Exiting findOne with value {0}", null);
return(null);
}
public IEnumerable <Organizator> findAll()
{
IDbConnection con = DBUtils.getConnection();
IList <Organizator> tasksR = new List <Organizator>();
using (var comm = con.CreateCommand())
{
comm.CommandText = "select idOrganizator,username, password from Organizator";
using (var dataR = comm.ExecuteReader())
{
while (dataR.Read())
{
int idOrganizator = dataR.GetInt32(0);
String username = dataR.GetString(1);
String password = dataR.GetString(2);
Organizator Organizator = new Organizator(idOrganizator, username, password);
tasksR.Add(Organizator);
}
}
}
return(tasksR);
}
