public bool updateData_stockEntry(ClsStockData stockData) { bool isOK = false; string querry = string.Empty; try { querry += @"UPDATE tbl_stockentry SET "; querry += "itemCode = '" + stockData._itemCode + "', "; querry += "updateDate = '" + stockData._updateDate + "', "; querry += "quantity = '" + stockData._quantity + "', "; querry += "buyingUnitPrice = '" + stockData._buyUnitPrice + "', "; querry += "sellingUnitPrice = '" + stockData._sellUnitPrice + "', "; querry += "stockEntryDate = '" + stockData._stockEntryDate + "', "; querry += "expirationDate = '" + stockData._expireDate + "', "; querry += "totalValue = '" + stockData._totalValue + "', "; querry += "priceAfterDiscount = '" + stockData._priceAfterDiscount + "', "; querry += "remainQuantity = '" + stockData._remainQuantity + "', "; querry += "misPlacedQty = '" + stockData._misPlacedQty + "', "; querry += "comment = '" + stockData._comment + "', "; querry += "dealerId = '" + stockData._dealerId + "' "; querry += "WHERE stockEntryId = '" + stockData._stockEntryId + "';"; isOK = CONN.update(querry); } catch (Exception ex) { throw ex; } return(isOK); }
public ClsStockData getSingleStockDetail(long stockEntryId) { ClsStockData stockData = new ClsStockData(); DataTable dt = new DataTable(); try { string querry = @"SELECT * FROM vw_stockentry WHERE stockEntryId = '" + stockEntryId + "';"; dt = CONN.getDataTable(querry); if (dt.Rows.Count >= 1) { stockData._stockEntryId = Convert.ToInt64(dt.Rows[0]["stockEntryId"].ToString()); stockData._itemCode = dt.Rows[0]["itemCode"].ToString(); stockData._itemId = Convert.ToInt32(dt.Rows[0]["itemId"].ToString()); stockData._updateDate = Convert.ToDateTime(dt.Rows[0]["updateDate"]); stockData._quantity = Convert.ToDouble(dt.Rows[0]["quantity"]); stockData._buyUnitPrice = Convert.ToDouble(dt.Rows[0]["buyingUnitPrice"]); stockData._sellUnitPrice = Convert.ToDouble(dt.Rows[0]["sellingUnitPrice"]); stockData._stockEntryDate = Convert.ToDateTime(dt.Rows[0]["stockEntryDate"]); stockData._createDate = Convert.ToDateTime(dt.Rows[0]["createDate"]); stockData._expireDate = Convert.ToDateTime(dt.Rows[0]["expirationDate"]); stockData._totalValue = Convert.ToDouble(dt.Rows[0]["totalValue"]); stockData._itemName = dt.Rows[0]["itemName"].ToString(); stockData._remainQuantity = Convert.ToDouble(dt.Rows[0]["remainQuantity"]); stockData._priceAfterDiscount = Convert.ToDouble(dt.Rows[0]["priceAfterDiscount"]); stockData._comment = dt.Rows[0]["comment"].ToString(); stockData._misPlacedQty = Convert.ToDouble(dt.Rows[0]["misPlacedQty"]); stockData._dealerId = Convert.ToInt32(dt.Rows[0]["dealerId"]); stockData._dealerName = dt.Rows[0]["dealerName"].ToString(); stockData._stockUnitId = Convert.ToInt32(dt.Rows[0]["stockUnitId"].ToString()); stockData._stockUnitSymbol = dt.Rows[0]["symbol"].ToString(); } } catch (Exception ex) { throw ex; } return(stockData); }
public bool insertData_stockEntry(ClsStockData stockData) { bool isError = false; string querry = string.Empty; try { querry += @"INSERT INTO tbl_stockentry (stockEntryId, itemCode, itemId, updateDate, quantity, buyingUnitPrice, sellingUnitPrice, stockEntryDate, createDate, expirationDate, totalValue, remainQuantity, priceAfterDiscount, comment, dealerId, stockUnitId) VALUES ("; querry += "'" + stockData._stockEntryId + "',"; querry += "'" + stockData._itemCode + "',"; querry += "'" + stockData._itemId + "',"; querry += "'" + stockData._updateDate + "',"; querry += "'" + stockData._quantity + "',"; querry += "'" + stockData._buyUnitPrice + "',"; querry += "'" + stockData._sellUnitPrice + "',"; querry += "'" + stockData._stockEntryDate + "',"; querry += "'" + stockData._createDate + "',"; querry += "'" + stockData._expireDate + "',"; querry += "'" + stockData._totalValue + "',"; querry += "'" + stockData._remainQuantity + "',"; querry += "'" + stockData._priceAfterDiscount + "',"; querry += "'" + stockData._comment + "',"; querry += "'" + stockData._dealerId + "',"; querry += "'" + stockData._stockUnitId + "'"; querry += ");"; isError = CONN.update(querry); } catch (Exception ex) { throw ex; } return(isError); }