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