public void DeleteItem(int ID)
{
Temp_VendorBilling tb = entities.Temp_VendorBilling.Find(ID);
entities.Entry(tb).State = EntityState.Deleted;
entities.SaveChanges();
}
public void UpdateBillingTable(int ItemId, int Qty, int VendorId)
{
int OutletId = getOutletId();
Temp_VendorBilling tb = new Temp_VendorBilling();
bool status = entities.Temp_VendorBilling.Where(a => a.OutletId == OutletId && a.VendorId == VendorId && a.ItemId == ItemId).Any();
if (status)
{
tb = entities.Temp_VendorBilling.Where(a => a.ItemId == ItemId && a.OutletId == OutletId && a.VendorId == VendorId).FirstOrDefault();
tb.Qty = tb.Qty + Qty;
tb.IskotCleared = false;
entities.SaveChanges();
}
else
{
var vendor = entities.VendorPrices.Where(a => a.VendorId == VendorId && a.tblMenuOutlet.ItemId == ItemId).FirstOrDefault();
tb.ItemId = ItemId;
tb.OutletId = OutletId;
tb.VendorId = VendorId;
tb.VendorPriceId = vendor.VendorPriceId;
tb.Qty = Qty;
tb.QtyAfterClearKot = 0;
tb.IskotCleared = false;
tb.IsPrinted = false;
tb.Isdispatched = false;
tb.Vat = vendor.tblMenuOutlet.tblBasePriceItem.Vat;
entities.Temp_VendorBilling.Add(tb);
entities.SaveChanges();
}
}
