public void FuelPurchase() { decimal fr = FuelReserve(); decimal amountToPurchase = (FuelReserveUpperLimit - fr); var cdc = new CorporationDataContext(); BANK bank = new BANK(); if (bank.balance >= amountToPurchase * fuelPrice) { int lastItemID = 0; int nextItemID = 0; int itemsCount = 0; itemsCount = cdc.TankFuelPayments.Count(); if (itemsCount == 0) { nextItemID = 660001; } else { lastItemID = cdc.TankFuelPayments.OrderByDescending(s => s.FuelPaymentID).Select(s => s.FuelPaymentID).First(); nextItemID = lastItemID + 1; } try { cdc.TankFuelPayments.InsertOnSubmit( new TankFuelPayment { FuelPaymentID = nextItemID, FuelPaymentAmount = Convert.ToInt32(amountToPurchase), FuelPaymentValue = amountToPurchase * fuelPrice, Status = "requested", Date = DateTime.Now } ); cdc.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Exception: " + ex.Message); } } }
public void IssuePayment(int ordId) { var cdc = new CorporationDataContext(); BANK bank = new BANK(); decimal balance = bank.balance; int lastItemID; int nextItemID; int itemsCount = 0; itemsCount = cdc.Payments.Count(); if (itemsCount == 0) { nextItemID = 220001; } else { lastItemID = cdc.Payments.OrderByDescending(s => s.PaymentID).Select(s => s.PaymentID).First(); nextItemID = lastItemID + 1; } try { cdc.Payments.InsertOnSubmit( new Payment { PaymentID = nextItemID, MProdOrderID = ordId, Status = "requested", TankFuelOrderID = null } ); cdc.SubmitChanges(); } catch (Exception ex) { // MessageBox.Show("Exception: " + ex.Message); } }
public void MainMonitorDisplay() { BANK bank = new BANK(); FUELSTATION tfstation = new FUELSTATION(); CARRIER carrier = new CARRIER(); PLANT plant = new PLANT(); var cdc = new CorporationDataContext(); Action textDisplayAct = () => { label3.Text = plant.OpenProdOrderQty().ToString(); label7.Text = plant.InProdOrdQty().ToString(); label9.Text = plant.OnstockOrdQty().ToString(); label16.Text = bank.balance.ToString("N0"); label28.Text = bank.PlantInput.ToString("N0"); label29.Text = bank.FuelInput.ToString("N0"); label11.Text = bank.TransInput.ToString("N0"); label19.Text = tfstation.NomberWaitTankOrd().ToString(); label21.Text = tfstation.NomberProcessTankOrd().ToString(); label23.Text = tfstation.MomentalTankFuelAmount().ToString(); label25.Text = tfstation.FuelReserve().ToString(); label5.Text = tfstation.TankfuelordersCancelledQty().ToString(); label38.Text = carrier.OpenTransOrdersQty().ToString(); label34.Text = carrier.InProcessTransOrdersQty().ToString(); label36.Text = carrier.FreeTrucksCount().ToString(); }; this.BeginInvoke(textDisplayAct); }