public bool updatedata(En_SanPham en)
{
string query = string.Format("UPDATE SanPham SET TenSP=@TenSP, DonViTinh=@DonViTinh, DonGiaMua=@DonGiaMua, SoTon=@SoTon WHERE MaSP=@MaSP");
SqlParameter[] sqlPara = new SqlParameter[5];
sqlPara[0] = new SqlParameter("@TenSP", en.TenSP);
sqlPara[1] = new SqlParameter("@DonViTinh", en.DonVi);
sqlPara[2] = new SqlParameter("@DonGiaMua", en.DonGia);
sqlPara[3] = new SqlParameter("@SoTon", en.SoTon);
sqlPara[4] = new SqlParameter("@MaSP", en.MaSP);
return(cnn.executeUpdateQuery(query, sqlPara));
}
public int updatedata(En_LoaiSanPham en)
{
string query = string.Format("UPDATE LoaiSanPham SET TenLoai=@TenLoai, MoTa=@MoTa WHERE MaLoai=@MaLoai");
SqlParameter[] sqlPara = new SqlParameter[3];
sqlPara[0] = new SqlParameter("@TenLoai", en.TenLoai);
sqlPara[1] = new SqlParameter("@MoTa", en.MoTa);
sqlPara[2] = new SqlParameter("@MaLoai", en.MaLoai);
int rows = 0;
try
{
cnn.executeUpdateQuery(query, sqlPara);
rows += 1;
}
catch (Exception ex)
{
throw ex;
}
return(rows);
}