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