public void ThemHD(int _mahd, string _tenkhachhang, string _diachi, string _sodienthoai, string _email)
{
EndUser.Open();
string now = DateTime.Now.ToString("MM/dd/yyyy");
string qry = "insert into hoadon values('" + _mahd + "','" + _tenkhachhang + "','" + _diachi + "','" + _sodienthoai + "','" + _email + "','" + now + "','" + now + "','False')";
SqlCommand cmd = new SqlCommand(qry, EndUser.cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
EndUser.Close();
}
public DataTable getall_sp_chude(int _chude)
{
EndUser.Open();
string qry = "SELECT top 20 SanPham.[MaSP], [TenSP], [GiaMua], [GiaBan], [LoaiSP], [ThongTin], [ChuDe], [GioiTinh], [hot], [HinhAnh], [NgayNhapHang],[SoLuong],[Size] FROM [SanPham] inner join SanPham_Size on SanPham.MaSP = SanPham_Size.MaSP inner join Size on SanPham_Size.MaSize = Size.MaSize WHERE ChuDe =" + _chude;
SqlCommand cmd = new SqlCommand(qry, EndUser.cnn);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
cmd.Dispose();
reader.Dispose();
EndUser.Close();
return(dt);
}
