partial void Deleteitems_table(items_table instance);
partial void Insertitems_table(items_table instance);
partial void Updateitems_table(items_table instance);
public void AddNewItem(string itemId, string categoryName, double cost, string description)
{
var db = new dbDataContext();
lock (db)
{
var match = (from i in db.GetTable<items_table>()
where i.item_id == itemId
select i).SingleOrDefault();
if (match == null)
{
Table<items_table> itemsTable = db.GetTable<items_table>();
var item = new items_table
{
item_id = itemId,
item_num = db.GetTable<items_table>().Count(),
number_left = 300,
category_name = categoryName,
cost = cost,
item_description = description
};
itemsTable.InsertOnSubmit(item);
db.SubmitChanges();
}
else
{
MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(42));
}
}
}