public DataTable Delete(DTO_DanhMucSanPham ncc) { DataTable table = new DataTable(); if (CheckWithID(ncc.ID)) { table = Data.Instance.ExecuteQuery("proc_Delete_DanhMucSanPham @id ", new object[] { ncc.ID }); } else { } return(table); }
public DataTable Insert(DTO_DanhMucSanPham ncc) { DataTable table = new DataTable(); if (Check(ncc.Tendanhmuc)) { } else { table = Data.Instance.ExecuteQuery("proc_Insert_DanhMucSanPham @ten ", new object[] { ncc.Tendanhmuc }); } return(table); }
public List <DTO_DanhMucSanPham> Load() { DataTable table = new DataTable(); table = Data.Instance.ExecuteQuery("select * from DanhMucSanPham"); List <DTO_DanhMucSanPham> list = new List <DTO_DanhMucSanPham>(); foreach (DataRow item in table.Rows) { DTO_DanhMucSanPham dto = new DTO_DanhMucSanPham(item); list.Add(dto); } return(list); }
private void btThem_Click(object sender, EventArgs e) { DTO_DanhMucSanPham sp = new DTO_DanhMucSanPham(tbTen.Text); DAO_DanhMucSanPham dao = new DAO_DanhMucSanPham(); if (ex.KiemTraChuoi(sp.Tendanhmuc, 100)) { dao.Insert(sp); } else { MessageBox.Show("Name very long"); } FDanhMucSanPham_Load(sender, e); }
private void btXoa_Click(object sender, EventArgs e) { DTO_DanhMucSanPham sp = new DTO_DanhMucSanPham(); sp.ID = id; DAO_DanhMucSanPham dao = new DAO_DanhMucSanPham(); if (id != 0) { dao.Delete(sp); } else { } FDanhMucSanPham_Load(sender, e); }
public DataTable Update(DTO_DanhMucSanPham ncc) { DataTable table = new DataTable(); if (CheckWithID(ncc.ID)) { if (Check(ncc.Tendanhmuc)) { } else { table = Data.Instance.ExecuteQuery("proc_Update_DanhMucSanPham @id , @ten ", new object[] { ncc.ID, ncc.Tendanhmuc }); } } else { } return(table); }
private void btSua_Click(object sender, EventArgs e) { DTO_DanhMucSanPham sp = new DTO_DanhMucSanPham(tbTen.Text); sp.ID = id; DAO_DanhMucSanPham dao = new DAO_DanhMucSanPham(); if (id != 0) { if (ex.KiemTraChuoi(sp.Tendanhmuc, 100)) { dao.Update(sp); } else { MessageBox.Show("Name very long"); } } else { } FDanhMucSanPham_Load(sender, e); }