public bool deleteRestaurantItemInDB(IRestaurantItem item)
{
try
{
ds = new DataSet();
string sql = "SELECT * From restaurantitems";
da = new SqlDataAdapter(sql, con);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "ItemsData");
DataRow findRow = ds.Tables["ItemsData"].Rows.Find(item.ItemID);
if (findRow != null)
{
findRow.Delete(); //mark row as deleted
}
da.Update(ds, "ItemsData"); //remove row from database table
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
if (getConnection().ToString() == "Open")
closeConnection();
Application.Exit();
}
return true;
}
private void CurrentSaleItemR(IRestaurantItem product)
{
string currentItemName = product.Name;
string currentItemPrice = string.Format("{0:c}", product.Price);
string currentItemNamePadded = currentItemName.PadRight(20);
textBoxSaleItem.Text = currentItemNamePadded + currentItemPrice;
}
public void addNewRestaurantItemToDB(IRestaurantItem item)
{
try
{
DataSet ds = new DataSet();
string sql = "SELECT * From restaurantitems";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
SqlCommandBuilder cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "ItemsData");
totalRestaurantItems = ds.Tables["ItemsData"].Rows.Count;
DataRow dRow = ds.Tables["ItemsData"].NewRow();
dRow[0] = Convert.ToInt16(item.ItemID);
dRow[1] = item.Name.ToString();
dRow[2] = item.Category.ToString();
dRow[3] = item.Description.ToString();
dRow[4] = Convert.ToDouble(item.Price);
ds.Tables["ItemsData"].Rows.Add(dRow);
da.Update(ds, "ItemsData");
}
catch (System.Exception excep)
{
if (con.State.ToString() == "Open")
con.Close();
Application.Exit();
//Environment.Exit(0); //Force the application to close
}
}
public bool modifyRestaurantItemInDB(IRestaurantItem item)
{
try
{
ds = new DataSet();
string sql = "SELECT * From restaurantitems";
da = new SqlDataAdapter(sql, con);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "ItemsData");
DataRow findRow = ds.Tables["ItemsData"].Rows.Find(item.ItemID);
if (findRow != null)
{
//findRow[0] = user.userID.ToString();
findRow[2] = item.Category;
findRow[3] = item.Description;
findRow[4] = Convert.ToDouble(item.Price);
}
da.Update(ds, "ItemsData"); //remove row from database table
}
catch (System.Exception excep)
{
MessageBox.Show(excep.Message);
if (getConnection().ToString() == "Open")
closeConnection();
Application.Exit();
}
return true;
}
public static void SetRestaurantItem(IRestaurantItem rItem)
{
item = rItem;
}
public bool modifyRestaurantItem(IRestaurantItem item)
{
DataLayer.modifyRestaurantItemInDB(item);
return true;
}
public bool deleteRestaurantItem(IRestaurantItem item)
{
DataLayer.deleteRestaurantItemInDB(item);
RestaurantItemsList.Remove(item); //remove object from collection
return true;
}
