public Employee getEmployeeByEmail(string email) { using (MySqlConnection connection = getConnection()) { string query = "select * from employee where email=@email"; Employee emp = connection.QuerySingleOrDefault <Cashier>(query, new { email = email }); if (emp != null) { string query2 = "select branch_id from employee where email=@email"; int id = connection.Query <int>(query2, new { email = email }).SingleOrDefault(); Branch branch = new BranchDAO().getBranchById(id); emp.branch = branch; return(emp); } return(null); } }
public Customer getCustomerByEmail(string email) { using (MySqlConnection connection = getConnection()) { string query = "select * from customer where email=@email"; Customer customer = connection.QuerySingleOrDefault <Customer>(query, new { email = email }); if (customer != null) { string query2 = "select branch_id from customer where email=@email"; int id = connection.Query <int>(query2, new { email = email }).SingleOrDefault(); Branch branch = new BranchDAO().getBranchById(id); customer.branch = branch; return(customer); } return(null); } }