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