public int Register(string Username, string Password, string Email, string Address, string Name, int Age, int Phonenumber, int CMT)
{
try
{
DatabaseAccess.OpenConnection();
query = @"insert into Customer(Customer_Username,Customer_password,Customer_email,Customer_address,Customer_Name,Customer_Age,Customer_Phone,Customer_CMT)
values ('" + Username + "','" + Password + "','" + Email + "','" + Address + "','" + Name + "'," + Age + "," + Phonenumber + "," + CMT + ");";
MySqlCommand command = new MySqlCommand(query, connection);
command.ExecuteNonQuery();
}
catch { }
finally
{
DatabaseAccess.CloseConnection();
}
return(10);
}
public Customer GetCustomer(string CustomerUsername)
{
DatabaseAccess.OpenConnection();
query = @"Select * from Customer where Customer_Username = '******';";
MySqlCommand command = new MySqlCommand(query, connection);
reader = command.ExecuteReader();
Customer customer = null;
if (reader.Read())
{
customer = GetCustomerInfo(reader);
}
reader.Close();
DatabaseAccess.CloseConnection();
return(customer);
}
public MobileDAL()
{
connection = DatabaseAccess.OpenConnection();
}
public CustomerDAL()
{
connection = DatabaseAccess.OpenConnection();
}
public OrderDAL()
{
connection = DatabaseAccess.OpenConnection();
}
