public void SaveSecondWeighingData(Freight frg, ModelTMSContainer ControlObjectContext) { FreightWeighing fgw = frg.FreightWeighing.First <FreightWeighing>(); FreightWeighingMaterial fwm = fgw.FreightWeighingMaterial.First <FreightWeighingMaterial>(); fgw.WeighingDateTime2 = CalendarWithTimeControl2.SelectedDateTime; fgw.Key2 = TextBoxKey2.Text; try { fgw.Weight2 = Convert.ToDouble("0" + TextBoxWeight2.Text); } catch { }; fwm.TarraWeight = fgw.Weight2; fwm.NetWeight = fwm.GrossWeight - fwm.TarraWeight; frg.TotalNetWeight = fwm.NetWeight; frg.Description = TextBoxDescription.Text; frg.Comments = TextBoxComments.Text; frg.FreightStatus = "Done"; frg.RecalcTotalWeightFromWeighing(); if (CheckBoxWeighingActionSort.Checked) { frg.FreightStatus = "In sorting"; } if (CheckBoxWeighingActionInvoice.Checked) { frg.FreightStatus = "To be invoiced"; } }
protected bool ProcessFirstWeighing() { ModelTMSContainer ControlObjectContext = new ModelTMSContainer(Session["CustomerConnectString"].ToString(), Session); bool Success = false; // start transaction using (TransactionScope TS = new TransactionScope()) { try { // process freight // setup base objects Freight frg = new Freight(); FreightWeighing frgw = new FreightWeighing(); FreightWeighingMaterial frgm = new FreightWeighingMaterial(); frg.FreightWeighing.Add(frgw); frgw.FreightWeighingMaterial.Add(frgm); ControlObjectContext.AddToFreightSet(frg); // save the first weighing data in the freight SaveFirstWeighingData(frg, ControlObjectContext); // assign the weighing number frg.AssignFreightNumber(ControlObjectContext); LabelFreightNr.Text = frg.OurReference.ToString(); CurrentWeighingId = frg.Id; frg.Description = "Weegbon " + frg.OurReference + " / " + Common.CurrentClientDateTime(Session).ToString(); frg.FreightType = "Weighing"; // and save to persistent storage ControlObjectContext.SaveChanges(System.Data.Objects.SaveOptions.DetectChangesBeforeSave); // commit the transaciton TS.Complete(); Success = true; } catch (Exception ex) // commit or procedure failed somewhere { // rollback transaction TS.Dispose(); // inform user Common.InformUserOnTransactionFail(ex, Page); // reset the weighing id when not saved CurrentWeighingId = Guid.Empty; } } if (Success) { // when success advance panel CurrentPageNr++; } return(Success); }
public void SaveFirstWeighingData(Freight frg, ModelTMSContainer ControlObjectContext) { FreightWeighing fgw = frg.FreightWeighing.First <FreightWeighing>(); FreightWeighingMaterial fwm = fgw.FreightWeighingMaterial.First <FreightWeighingMaterial>(); frg.FreightDirection = "To warehouse"; if (RadioButtonListBuyOrSell.SelectedIndex == 1) { frg.FreightDirection = "To customer"; } frg.SourceOrDestinationLocation = ControlObjectContext.GetObjectByKey(new EntityKey("ModelTMSContainer.LocationSet", "Id", Guid.Parse(ComboBoxWeighingLocation.SelectedValue))) as Location; frg.FreightDateTime = CalendarWithTimeControlDateTime1.SelectedDateTime; frg.FreightStatus = "2nd weighing"; fgw.Key1 = TextBoxKey1.Text; try { fgw.Weight1 = Convert.ToDouble(TextBoxGrossWeight.Text); } catch { }; fgw.IsDriverInTruck = CheckBoxIsDriverInTruck.Checked; fgw.WeighingDateTime1 = frg.FreightDateTime; fgw.Description = TextBoxPMV.Text; frg.OurTruck = null; if (ComboBoxOurPlate.SelectedValue != "") { frg.OurTruck = ControlObjectContext.GetObjectByKey(new EntityKey("ModelTMSContainer.TruckSet", "Id", Guid.Parse(ComboBoxOurPlate.SelectedValue))) as Truck; } frg.YourTruckPlate = TextBoxCustomerPlate.Text; frg.YourDriverName = TextBoxCustomerID.Text; frg.FromRelation = ControlObjectContext.GetObjectByKey(new EntityKey("ModelTMSContainer.RelationSet", "Id", Guid.Parse(ComboBoxCustomer.SelectedValue))) as Relation; LabelCustomerGuid.Text = frg.FromRelation.Id.ToString(); fwm.GrossWeight = fgw.Weight1; fwm.Material = ControlObjectContext.GetObjectByKey(new EntityKey("ModelTMSContainer.MaterialSet", "Id", Guid.Parse(ComboBoxProduct.SelectedValue))) as Material; fwm.Description = fwm.Material.Description; }
public void LoadFirstWeighingData(Freight frg) { DataBind(); FreightWeighing fgw = frg.FreightWeighing.First <FreightWeighing>(); FreightWeighingMaterial fwm = fgw.FreightWeighingMaterial.First <FreightWeighingMaterial>(); TextBoxOrderNumber.Text = frg.OurReference.ToString(); TextBoxDescription.Text = frg.Description; if (frg.FreightDirection == "To warehouse") { RadioButtonListBuyOrSell.SelectedIndex = 0; } else { RadioButtonListBuyOrSell.SelectedIndex = 1; } SetCustomerType(); ComboBoxWeighingLocation.DataBind(); ListItem li = ComboBoxWeighingLocation.Items.FindByValue(frg.SourceOrDestinationLocation.Id.ToString()); if (li != null) { li.Selected = true; } CalendarWithTimeControlDateTime1.SelectedDateTime = frg.FreightDateTime; TextBoxKey1.Text = fgw.Key1; TextBoxGrossWeight.Text = fgw.Weight1.ToString(); CheckBoxIsDriverInTruck.Checked = fgw.IsDriverInTruck; TextBoxPMV.Text = fgw.Description; ComboBoxOurPlate.DataBind(); if (frg.OurTruck != null) { li = ComboBoxOurPlate.Items.FindByValue(frg.OurTruck.Id.ToString()); if (li != null) { li.Selected = true; ComboBoxOurPlate.SelectedIndex = ComboBoxOurPlate.Items.IndexOf(li); } } TextBoxCustomerPlate.Text = frg.YourTruckPlate; TextBoxCustomerID.Text = frg.YourDriverName; ComboBoxCustomer.DataBind(); li = ComboBoxCustomer.Items.FindByValue(frg.FromRelation.Id.ToString()); if (li != null) { li.Selected = true; } LabelCustomerGuid.Text = frg.FromRelation.Id.ToString(); ComboBoxProduct.DataBind(); li = ComboBoxProduct.Items.FindByValue(fwm.Material.Id.ToString()); if (li != null) { li.Selected = true; } CurrentWeighingId = frg.Id; // make sure the cash ledger of the current location is set SetCorrectLocationCashLedger(); }