public bool addToExsistingResturantOrder(IStockOrderItems item)
{
try
{
DataSet ds;
SqlDataAdapter da;
SqlCommandBuilder cb;
ds = new DataSet();
string sql = "SELECT * From stockorderitems";
da = new SqlDataAdapter(sql, con);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "StockOrderData");
totalRestaurantItems = ds.Tables["StockOrderData"].Rows.Count;
DataRow dRow = ds.Tables["StockOrderData"].NewRow();
dRow[0] = item.StockOrderId.OrderId;
dRow[1] = item.StockItemId.StockItemId;
dRow[2] = item.QuantityOnOrder;
ds.Tables["StockOrderData"].Rows.Add(dRow);
da.Update(ds, "StockOrderData");
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
if (getConnection().ToString() == "Open")
closeConnection();
Application.Exit();
}
return true;
}
public bool updateExsistingResturantOrder(IStockOrderItems item)
{
try
{
DataSet ds;
SqlDataAdapter da;
SqlCommandBuilder cb;
ds = new DataSet();
string sql = "SELECT * From stockorderitems";
da = new SqlDataAdapter(sql, con);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "StockOrderData");
object[] compK = new object[2] { item.StockOrderId.OrderId, item.StockItemId.StockItemId };
DataRow findRow = ds.Tables["StockOrderData"].Rows.Find(compK);
if (findRow != null)
{
findRow[2] = item.QuantityOnOrder;
}
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
if (getConnection().ToString() == "Open")
closeConnection();
Application.Exit();
}
return true;
}
