public static int CapNhatLoaiMonAn(LoaiMonAn_DTO loaiMonAn)
{
Provider provider = new Provider();
string sql = string.Format("update LoaiMonAn set TenLoai=N'{0}' where MaLoai='{1}'", loaiMonAn.Tenloai, loaiMonAn.Maloai);
SqlCommand cm = provider.CreateCommandStringSql(sql);
return(provider.ExecuteInsertUpdateDelete(cm));
}
public static int ThemLoaiMonAn(LoaiMonAn_DTO loaiMonAn)
{
Provider provider = new Provider();
string sql = string.Format("insert into LoaiMonAn values('{0}',N'{1}') ", loaiMonAn.Maloai, loaiMonAn.Tenloai);
// sql += " waitfor delay '0:0:20' Rollback Commit tran";
SqlCommand cm = provider.CreateCommandStringSql(sql);
return(provider.ExecuteInsertUpdateDelete(cm));
}
private void CapNhatLoaiMonAn()
{
int flag = 0;
int[] index = gridView_LoaiMonAn.GetSelectedRows();
if (index.Length > 0)
{
string tenloai = gridView_LoaiMonAn.GetRowCellValue(index[0], "TenLoai").ToString();
string maloai = gridView_LoaiMonAn.GetRowCellValue(index[0], "MaLoai").ToString();
if (maloai != null)
{
DTO.LoaiMonAn_DTO loaiMonAn = new LoaiMonAn_DTO();
loaiMonAn.Maloai = maloai;
loaiMonAn.Tenloai = tenloai;
flag = LoaiMonAn_BUS.CapNhatLoaiMonAn(loaiMonAn);
}
}
if (flag != 0)
{
DevExpress.XtraEditors.XtraMessageBox.Show("Cập nhật thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static int ThemLoaiMonAn_XD(LoaiMonAn_DTO loaiMonAn)
{
return(LoaiMonAn_DAO.ThemLoaiMonAn_XungDot(loaiMonAn));
}
public static int ThemLoaiMonAn(LoaiMonAn_DTO loaiMonAn)
{
return(LoaiMonAn_DAO.ThemLoaiMonAn(loaiMonAn));
}
public static int CapNhatLoaiMonAn(LoaiMonAn_DTO loaiMonAn)
{
return(LoaiMonAn_DAO.CapNhatLoaiMonAn(loaiMonAn));
}
