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_XungDot(LoaiMonAn_DTO loaiMonAn)
{
Provider provider = new Provider();
string sql = string.Format("begin tran 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);
}
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);
}
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);
}
