private bool kiemtra(string p1, string p2)
{
QuanaoDataContext context = new QuanaoDataContext();
if (string.IsNullOrEmpty(this.textBox1.Text))
{
MessageBox.Show("Vui lòng nhập vào tài khoản");
return(false);
}
if (string.IsNullOrEmpty(this.textBox2.Text))
{
MessageBox.Show("Vui lòng nhập vào Mật khẩu");
return(false);
}
var q = from p in context.TAIKHOANs
where p.USERNAME == textBox1.Text &&
p.PASSWORD == textBox2.Text
select p;
if (q.Any())
{
return(true);
}
else
{
return(false);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
QuanaoDataContext db = new QuanaoDataContext();
var query = from nhomhang in db.NHOMHANGs
where nhomhang.MaNhomHang.Contains(txtTimKiem.Text) || nhomhang.TenNhomHang.Contains(txtTimKiem.Text)
select new
{
MaNhomHang = nhomhang.MaNhomHang,
TenNhomHang = nhomhang.TenNhomHang
};
dataNhomHang.DataSource = query.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
QuanaoDataContext db = new QuanaoDataContext();
var query = from ncc in db.NCCs
where ncc.MaNCC.Contains(txtSearch.Text) || ncc.TenNCC.Contains(txtSearch.Text)
select new
{
MaNCC = ncc.MaNCC,
TenNCC = ncc.TenNCC,
DC = ncc.DC,
SDT = ncc.SDT
};
dataNhaCC.DataSource = query.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
QuanaoDataContext db = new QuanaoDataContext();
var query = from product in db.SANPHAMs
where product.MaSP.Contains(txtTimKiem.Text) || product.TenSP.Contains(txtTimKiem.Text) || product.ChungLoai.Contains(txtTimKiem.Text)
select new
{
MaSP = product.MaSP,
TenSP = product.TenSP,
ChungLoai = product.ChungLoai,
DONGIA = product.DONGIA,
SOLUONG = product.SOLUONG
};
dataSanPham.DataSource = query.ToList();
}
private void btnSearch_Click(object sender, EventArgs e)
{
QuanaoDataContext db = new QuanaoDataContext();
var query = from customer in db.KHACHHANGs
where customer.MaKH.Contains(txtSearch.Text) || customer.TenKH.Contains(txtSearch.Text) || customer.GT.Contains(txtSearch.Text)
select new
{
MaKH = customer.MaKH,
TenKH = customer.TenKH,
NS = customer.NS,
GT = customer.GT,
Sdt = customer.Sdt,
Email = customer.Email
};
dataKhachhang.DataSource = query.ToList();
}
public DANGNHAP()
{
InitializeComponent();
db = new QuanaoDataContext();
}
public SanPham()
{
InitializeComponent();
db = new QuanaoDataContext();
}
public GIAODIEN()
{
InitializeComponent();
db = new QuanaoDataContext();
}
public NhomHang()
{
InitializeComponent();
db = new QuanaoDataContext();
}
