public void insert(Class_Khach khach)
{
string sql = "INSERT INTO KhachHang(MaKhachHang,TenKhachHang, DiaChi,DienThoai) VALUES(";
sql += khach.MaKhach1 + ",N'" + khach.TenKhach1 + "',N'" + khach.DiaChi1 + "',N'" + khach.DienThoai1 + "')";
query.insert(sql);
}
public new List <Class_Khach> Select()
{
string sql = "Select * from Khach";
List <Class_Khach> list = new List <Class_Khach>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaKhach = reader.GetString(0);
String TenKhach = reader.GetString(1);
String DiaChi = reader.GetString(2);
String DienThoai = reader.GetString(3);
Class_Khach khach1 = new Class_Khach(MaKhach, TenKhach, DiaChi, DienThoai);
list.Add(khach1);
}
}
}
con.Close();
return(list);
}
public new List <Class_Khach> Select()
{
string sql = "Select * from Khach";
List <Class_Khach> list = new List <Class_Khach>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaKhach = reader.GetString(0);
String TenKhach = reader.GetString(1);
String DiaChi = reader.GetString(2);
String DienThoai = reader.GetString(3);
Class_Khach khach1 = new Class_Khach(MaKhach, TenKhach, DiaChi, DienThoai);
list.Add(khach1);
}
}
}
query.DongketnoiSQL();
return(list);
}
public void update(Class_Khach khach)
{
string sql = "UPDATE Khach WHERE SET MaKhachHang=" + khach.MaKhach1 + ",TenKhacHang=N'" + khach.TenKhach1 + "', DiaChi=N'" + khach.DiaChi1 + "', DienThoai='" + khach.DienThoai1 + "')";
query.insert(sql);
}
public void delete(Class_Khach khach)
{
string sql = "DELETE FROM Khach WHERE MaKhachHang = " + khach.MaKhach1;
query.insert(sql);
}
