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); }