public bool themMonAn(MonAn monAn)
{
var cm = CreateCommand();
cm.CommandText = @"insert into MonAn (tenMA,danhMuc,donGia,donViTinh,ghiChu) values (@a,@b,@c,@d,@e)";
cm.Parameters.Add(new SqlParameter("@a", monAn.TenMonAn));
cm.Parameters.Add(new SqlParameter("@b", monAn.DanhMuc));
cm.Parameters.Add(new SqlParameter("@c", monAn.DonGia));
cm.Parameters.Add(new SqlParameter("@d", monAn.DonViTinh));
cm.Parameters.Add(new SqlParameter("@e", monAn.GhiChu));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public bool capNhatMonAn(MonAn monAn, int maMA)
{
var cm = CreateCommand();
cm.CommandText = @"update MonAn set tenMA=@a,danhMuc=@b,donGia=@c,donViTinh=@d,ghiChu=@e where maMA=@ma";
cm.Parameters.Add(new SqlParameter("@a", monAn.TenMonAn));
cm.Parameters.Add(new SqlParameter("@b", monAn.DanhMuc));
cm.Parameters.Add(new SqlParameter("@c", monAn.DonGia));
cm.Parameters.Add(new SqlParameter("@d", monAn.DonViTinh));
cm.Parameters.Add(new SqlParameter("@e", monAn.GhiChu));
cm.Parameters.Add(new SqlParameter("@ma", maMA));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
