public void updateStock(String user, Stock stock, String vendor, String exp_date, int size, String unit_price, String cost_price, int shop)
{
int stock_size = 0;
MySqlConnection mySqlConn = DBConnection.getConn();
MySqlCommand command = new MySqlCommand("select stock_shop_" + shop + " from product where product_code = '" + product_code + "'", mySqlConn);
try
{
mySqlConn.Open();
MySqlDataReader datReader = command.ExecuteReader();
while (datReader.Read())
{
stock_size = Convert.ToInt32(datReader.GetString("stock_shop_" + shop));
}
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
finally
{
mySqlConn.Close();
}
command = new MySqlCommand("update stock set vendor = '" + vendor + "', exp_date = '" + formattedDate(exp_date) + "', size = '" + size + "', unit_price = '" + unit_price + "', cost_price = '" + cost_price + "' where product_code = '" + product_code + "' and stock_id = '" + stock.getStockID() + "'", mySqlConn);
MySqlCommand command2 = new MySqlCommand("update product set stock_shop_" + shop + " = '" + (stock_size + size - stock.getSize()) + "' where product_code = '" + product_code + "'", mySqlConn);
try
{
mySqlConn.Open();
int numRowsUpdated = command.ExecuteNonQuery();
int numRowsUpdated2 = command2.ExecuteNonQuery();
MessageBox.Show("Data Updated");
InventoryManagement.StockReport stockReport = new InventoryManagement.StockReport();
stockReport.addToReport(user, product_code, stock.getStockID(), "updated", vendor, exp_date, size, shop, cost_price, unit_price);
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
finally
{
mySqlConn.Close();
DBConnection.returnConn(mySqlConn);
mySqlConn = null;
}
}
public void returnStock(String user, Stock stock, int remStock)
{
int stock_size = 0;
MySqlConnection mySqlConn = DBConnection.getConn();
MySqlCommand command = new MySqlCommand("select stock_shop_" + stock.getShop() + " from product where product_code = '" + product_code + "'", mySqlConn);
try
{
mySqlConn.Open();
MySqlDataReader datReader = command.ExecuteReader();
while (datReader.Read())
{
stock_size = Convert.ToInt32(datReader.GetString("stock_shop_" + stock.getShop()));
}
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
finally
{
mySqlConn.Close();
}
command = new MySqlCommand("update stock set status = 'returned', returned_date = '" + formattedDate(DateTime.Today.ToString("MM/dd/yyyy")) + "' where product_code = '" + product_code + "' and stock_id = '" + stock.getStockID() + "'", mySqlConn);
MySqlCommand command2 = new MySqlCommand("update product set stock_shop_" + stock.getShop() + " = '" + (stock_size - (Convert.ToInt32(stock.getSize()) - remStock)) + "' where product_code = '" + product_code + "'", mySqlConn);
try
{
mySqlConn.Open();
int numRowsUpdated = command.ExecuteNonQuery();
int numRowsUpdated2 = command2.ExecuteNonQuery();
MessageBox.Show("Data Updated");
InventoryManagement.StockReport stockReport = new InventoryManagement.StockReport();
stockReport.addToReport(user, product_code, stock.getStockID(), "returned", stock.getVendor(), stock.getExpDate(), remStock, stock.getShop(), stock.getCostPrice(), stock.getUnitPrice());
}
catch (Exception es)
{
MessageBox.Show(es.Message);
}
finally
{
mySqlConn.Close();
DBConnection.returnConn(mySqlConn);
mySqlConn = null;
}
}
