private void listView1_MouseClick(object sender, MouseEventArgs e)
{
DAO_SanPham sp = new DAO_SanPham();
var ten = listView1.SelectedItems[0].SubItems[1].Text;
var sl = listView1.SelectedItems[0].SubItems[3].Text;
var dv = listView1.SelectedItems[0].SubItems[4].Text;
var nt = listView1.SelectedItems[0].SubItems[5].Text;
var nsx = listView1.SelectedItems[0].SubItems[6].Text;
var hsd = listView1.SelectedItems[0].SubItems[7].Text;
var cbb = listView1.SelectedItems[0].SubItems[8].Text;
var dg = listView1.SelectedItems[0].SubItems[2].Text;
tbTen.Text = ten;
tbSoLuong.Text = sl;
tbDonVi.Text = dv;
dtpNgayThem.Text = nt;
dtpNgaySanXuat.Text = nsx;
dtpHanSuDung.Text = hsd;
cbbDanhMuc.Text = cbb;
tbDonGia.Text = dg;
id = Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text);
QuanLyKhoHnag_ChuoiCuaHangTienIch.Linq.QuanLyKhoHangDataContext db = new Linq.QuanLyKhoHangDataContext();
var res = db.SanPhams.SingleOrDefault(x => x.ID == id);
HinhAnh = res.HinhAnh;
string imageName = sp.GetImageName(Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text)).ToString();
pictureBox1.Image = Image.FromFile("H:\\project\\c#\\Wfrom\\QuanLyKhoHnag_ChuoiCuaHangTienIch\\QuanLyKhoHnag_ChuoiCuaHangTienIch\\Image\\" + imageName);
//string SDT = listView1.SelectedItems[0].SubItems[3].Text;
}
private void btXoa_Click(object sender, EventArgs e)
{
DAO_SanPham dao = new DAO_SanPham();
DTO_SanPham sp = new DTO_SanPham();
sp.ID = id;
if (sp.ID != 0)
{
dao.Delete(sp);
tbTen.Text = "";
tbSoLuong.Text = "";
tbDonVi.Text = "";
dtpHanSuDung.Text = DateTime.Now.ToString();
dtpNgaySanXuat.Text = DateTime.Now.ToString();
dtpNgayThem.Text = DateTime.Now.ToString();
HinhAnh = "";
tbDonGia.Text = "";
cbbDanhMuc.Text = "";
pictureBox1.Image = null;
FSanPham_Load(sender, e);
}
else
{
}
}
//
public static bool ChinhSuaSanPham(DTO_SanPham sp)
{
if (DAO_SanPham.KTSPTonTai(sp.MaSP))
{
return(DAO_SanPham.ChinhSuaSanPham(sp));
}
return(false);
}
//
public static bool ThemSanPham(DTO_SanPham sp)
{
if (!DAO_SanPham.KTSPTonTai(sp.MaSP))
{
return(DAO_SanPham.ThemSanPham(sp) == 1);
}
return(false);
}
//
public static DTO_SanPham LaySanPham(string maSP)
{
if (KTSPTonTai(maSP))
{
return(DAO_SanPham.LaySanPham(maSP));
}
return(null);
}
//
public static DTO_SanPham TimKiemSanPham(string tenSP)
{
if (KTSPTonTai(tenSP))
{
return(DAO_SanPham.TimKiemSP(tenSP));
}
return(null);
}
private void cbbDanhMuc_MouseClick(object sender, MouseEventArgs e)
{
if (cbbDanhMuc.Text == "")
{
DAO_SanPham sp = new DAO_SanPham();
cbbDanhMuc.DataSource = sp.Combobox();
cbbDanhMuc.DisplayMember = "TenDanhMuc";
cbbDanhMuc.ValueMember = "ID";
}
else
{
}
}
private void Init()
{
DAO_SanPham sp = new DAO_SanPham();
DAO_Main main = new DAO_Main();
lv.FullRowSelect = true;
lv.View = View.Details;
lv.GridLines = true;
lv.Columns.Add("ID");
lv.Columns.Add("Tên Sản Phẩm", 120);
lv.Columns.Add("Số Lượng", 100);
lv.Columns.Add("Đơn Vị", 90);
lv.Columns.Add("Ngày Thêm", 120);
lv.Columns.Add("NSX", 120);
lv.Columns.Add("HSD", 120);
lv.Columns.Add("Danh Mục", 125);
cbbDanhMuc.Text = "";
cbbSanPham.Text = "";
}
private void Init()
{
DAO_SanPham sp = new DAO_SanPham();
listView1.FullRowSelect = true;
listView1.View = View.Details;
listView1.GridLines = true;
listView1.Columns.Add("ID");
listView1.Columns.Add("Tên Sản Phẩm", 120);
listView1.Columns.Add("Đơn Giá", 80);
listView1.Columns.Add("Số Lượng");
listView1.Columns.Add("Đơn Vị");
listView1.Columns.Add("Ngày Thêm", 90);
listView1.Columns.Add("NSX", 90);
listView1.Columns.Add("HSD", 90);
listView1.Columns.Add("Danh Mục", 120);
cbbDanhMuc.DataSource = sp.Combobox();
cbbDanhMuc.DisplayMember = "TenDanhMuc";
cbbDanhMuc.ValueMember = "ID";
}
private void btSua_Click(object sender, EventArgs e)
{
DAO_SanPham dao = new DAO_SanPham();
if (HinhAnh == "")
{
MessageBox.Show("Please Select Image");
}
else
{
Exceptionn ex = new Exceptionn();
if (ex.KiemTraChuoi(new string[] { tbTen.Text, tbDonVi.Text }, new int[] { 100, 100 }) &&
ex.KiemTraSoLuong(tbSoLuong.Text, 999999999) && ex.KiemTraSoLuong(tbDonGia.Text, 10 ^ 37))
{
DTO_SanPham dto = new DTO_SanPham(tbTen.Text, Convert.ToInt32(tbSoLuong.Text), tbDonVi.Text,
Convert.ToDateTime(dtpNgayThem.Text), Convert.ToDateTime(dtpNgaySanXuat.Text),
Convert.ToDateTime(dtpHanSuDung.Text), HinhAnh, Convert.ToDouble(tbDonGia.Text), Convert.ToInt32(cbbDanhMuc.SelectedValue));
dto.ID = id;
dao.Update(dto);
}
}
FSanPham_Load(sender, e);
}
private void FSanPham_Load(object sender, EventArgs e)
{
listView1.Items.Clear();
DAO_SanPham sp = new DAO_SanPham();
List <DTO_SanPham> list = new List <DTO_SanPham>();
list = sp.List();
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Gia.ToString());
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
listView1.Items.Add(it);
}
}
//
public static List <DTO_SanPham> LoadDSLoaiSPLoai05()
{
return(DAO_SanPham.LoadDSLoaiSPLoai05());
}
//
public static bool XoaSanPham(string maSP)
{
return(DAO_SanPham.XoaSanPham(maSP));
}
public static bool KTSPTonTai(string maSP)
{
return(DAO_SanPham.KTSPTonTai(maSP));
}
public static List <DTO_SanPham> LayDSSanPham(string maLoaiSP)
{
return(DAO_SanPham.LayDSSanPham(maLoaiSP));
}
private void FMain_Load(object sender, EventArgs e)
{
DAO_SanPham sp = new DAO_SanPham();
DAO_Main main = new DAO_Main();
List <DTO_SanPham> list = new List <DTO_SanPham>();
if (cbbDanhMuc.Text == "" && cbbSanPham.Text == "")
{
lv.Items.Clear();
list = main.ListSP();
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
else if (cbbDanhMuc.Text != "" && cbbSanPham.Text == "")
{
lv.Items.Clear();
list = main.ListSP_DanhMuc(idDanhmuc);
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
else if (cbbDanhMuc.Text != "" && cbbSanPham.Text != "")
{
lv.Items.Clear();
list = main.ListSP_DanhMuc_SanPham(idSanPham);
foreach (var item in list)
{
ListViewItem it = new ListViewItem(item.ID.ToString());
it.SubItems.Add(item.Tensanpham);
it.SubItems.Add(item.Soluong.ToString());
it.SubItems.Add(item.Donvi.ToString());
it.SubItems.Add(item.Ngaythem.ToString());
it.SubItems.Add(item.Ngaysanxuat.ToString());
it.SubItems.Add(item.Hansudung.ToString());
object table = Data.Instance.ExecuteScalar("select TenDanhMuc from DanhMucSanPham where ID = @id ", new object[] { item.DanhmucID });
string danhmuc = table.ToString();
it.SubItems.Add(danhmuc);
lv.Items.Add(it);
}
}
}
public static List <DTO_SanPham> LoadDSSanPham()
{
return(DAO_SanPham.LoadDSSanPham());
}
public BUS_SanPham()
{
da = new DAO_SanPham();
}
