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