// Could just have a set of static helper methods rather than a singleton!
public List <Customer> getCustomers()
{
List <Customer> customers = new List <Customer>();
DbConection con = DbFactory.instance();
if (con.OpenConnection())
{
DbDataReader dr = con.Select("SELECT CUST_ID, cust_name, cust_address, cust_city FROM customers;");
//Read the data and store them in the list
while (dr.Read())
{
Customer customer = new Customer();
customer.ID = dr.GetInt32(0);
customer.Name = dr.GetString(1);
customer.Address = dr.GetString(2);
customer.City = dr.GetString(3);
// etc.....
customers.Add(customer);
}
//close Data Reader
dr.Close();
con.CloseConnection();
}
return(customers);
}
public int[] farmLogin(String txtUsername, String txtPassword)
{
int [] retv = new int[2];
if (con.OpenConnection())
{
String sql = "SELECT employeeId, accessPrivilage FROM Employees WHERE userName = '******' AND password = '******'";
DbDataReader reader = con.Select(sql);
Employee info = new Employee();
//Read the data
while (reader.Read())
{
info.Id = reader.GetInt32(0);
info.Privilage = reader.GetString(1);
}
if (info.Privilage == "Yes")
{
retv[0] = 0;
retv[1] = info.Id;
}
else if (info.Privilage == "No")
{
retv[0] = 1;
retv[1] = info.Id;
}
else
{
retv[0] = 2;
retv[1] = info.Id;
}
//close Data Reader
reader.Close();
con.CloseConnection();
}
return(retv);
}
