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