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