public void sView(CurrentProduct currentProduct) {
con = dbCon.geConnection();
try {
pst = con.prepareStatement("select * from Products where ProductId=?");
pst.setString(1, currentProduct.productId);
rs = pst.executeQuery();
while (rs.next()) {
currentProduct.id = rs.getString(1);
currentProduct.productId = rs.getString(2);
currentProduct.productName = rs.getString(3);
currentProduct.quantity = rs.getString(4);
currentProduct.description = rs.getString(5);
currentProduct.supplierId = rs.getString(6);
currentProduct.brandId = rs.getString(7);
currentProduct.catagoryId = rs.getString(8);
currentProduct.unitId = rs.getString(9);
currentProduct.pursesPrice = rs.getString(10);
currentProduct.sellPrice = rs.getString(11);
currentProduct.rmaId = rs.getString(12);
currentProduct.userId = rs.getString(13);
currentProduct.date = rs.getString(14);
currentProduct.supplierName =
sql.getName(currentProduct.supplierId, currentProduct.supplierName, "Supplyer");
currentProduct.brandName =
sql.getName(currentProduct.brandId, currentProduct.brandName, "Brands");
currentProduct.catagoryName =
sql.getName(currentProduct.catagoryId, currentProduct.catagoryName, "Catagory");
currentProduct.unitName =
sql.getName(currentProduct.unitId, currentProduct.unitName, "Unit");
currentProduct.rmaName = sql.getName(currentProduct.rmaId, currentProduct.rmaName, "RMA");
currentProduct.userName =
sql.getName(currentProduct.userId, currentProduct.userName, "User");
currentProduct.rmaDayesss = sql.getDayes(currentProduct.rmaDayesss, currentProduct.rmaId);
long dateRMA = Long.parseLong(currentProduct.rmaDayesss);
currentProduct.warrentyVoidDate = LocalDate.now().plusDays(dateRMA).toString();
}
pst.close();
con.close();
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
