partial void Deletesold_bar_history_table(sold_bar_history_table instance);
partial void Updatesold_bar_history_table(sold_bar_history_table instance);
partial void Insertsold_bar_history_table(sold_bar_history_table instance);
private void detach_sold_bar_history_tables(sold_bar_history_table entity)
{
this.SendPropertyChanging();
entity.items_table = null;
}
private void detach_sold_bar_history_tables(sold_bar_history_table entity)
{
this.SendPropertyChanging();
entity.global_session_t = null;
}
public void SellItem(string itemId, int number, DateTime timeOfSelling, double sum)
{
var db = new dbDataContext();
lock (db)
{
int dailyId = GetLastOpenedGlobalSessionDailyId();
Table<sold_bar_history_table> soldBarTable = db.GetTable<sold_bar_history_table>();
var soldItem = new sold_bar_history_table
{
daily_id = dailyId,
amount_sold = number,
item_id = itemId,
sale_time = timeOfSelling,
comments = " "
};
soldBarTable.InsertOnSubmit(soldItem);
db.SubmitChanges();
AddMoneyToCash(sum, dailyId);
AddItemToRevision(itemId, number*(-1));
}
}
