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