public bool InsertOrUpdate(MiniUnit MURecord) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { if (MURecord.MiniUnitId == 0) { db.MiniUnit.Add(MURecord); } else { db.MiniUnit.AddOrUpdate(MURecord); } db.SaveChanges(); } catch (Exception ex) { string message = ex.Message; isSaved = false; } } return(isSaved); }
public bool Delete(int MiniUnitId) { bool isDeleted = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { mu = db.MiniUnit.Find(MiniUnitId); db.MiniUnit.Remove(mu); db.SaveChanges(); } catch (Exception e) { string message = e.Message; isDeleted = false; } } return(isDeleted); }
public bool UpdateBalanceAllowedStorage(int MiniUnitId, bool BalanceToStorageAllowed) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { mu = db.MiniUnit.Find(MiniUnitId); mu.BalanceToStorageAllowed = BalanceToStorageAllowed; db.MiniUnit.AddOrUpdate(mu); db.SaveChanges(); } catch (Exception ex) { string message = ex.Message; isSaved = false; } } return(isSaved); }
private void tbCreateUnits_Click(object sender, EventArgs e) { if (MandatoryFieldsOk()) { var unitService = new UnitSourceService(); int insertedUSId; var muService = new MiniUnitService(); string unitBilled; if (cboCargoType.Text.Equals("BULK")) { unitBilled = Conversions.ToString(cboWeightUnit.SelectedItem); } else { unitBilled = "PC"; } // My.MyProject.Forms.FrmParentScreen.showLOadForm(); foreach (var unit in UnitList) { UnitSource ExistingUnit; MiniUnit mu; if (unit.UnitId != 0) { ExistingUnit = AllUnits.Where(u => u.UnitSourceId == unit.UnitId).ToList()[0]; // ExistingUnit.UnitStatusId = cboStatus.SelectedValue ExistingUnit.UnitType = Conversions.ToString(cboType.SelectedItem); ExistingUnit.CargoTypeId = Conversions.ToInteger(cboCargoType.SelectedValue); ExistingUnit.LastUpdate = DateAndTime.Now; ExistingUnit.TotalBilled = (double?)unit.TotalBilled; ExistingUnit.OriginalUnitNumber = unit.OriginalUnitNumber; bool isSaved = unitService.AddOrUpdate(ExistingUnit); insertedUSId = unit.UnitId; var muList = new List <MiniUnit>(); muList = MiniUnitService.GetAllByUSId(unit.UnitId); foreach (var currentMu in muList) { mu = currentMu; if (muList.Count == 1) { mu.TotalBilled = unit.TotalBilled; } mu.BilledByUnitUnitType = unitBilled; mu.UnBilledByUnitUnitType = unitBilled; mu.CustomerId = Conversions.ToInteger(cboCustomer.SelectedValue); mu.GradeId = Conversions.ToInteger(cboGrade.SelectedValue); mu.CommodityId = Conversions.ToInteger(cboCommodity.SelectedValue); muService.InsertOrUpdate(mu); } } else { var us = new UnitSource(); us.UnitNumber = unit.UnitNumber; us.OriginalUnitNumber = unit.OriginalUnitNumber; us.UnitStatusId = unit.UnitStatusId; us.UnitType = Conversions.ToString(cboType.SelectedItem); us.CargoTypeId = Conversions.ToInteger(cboCargoType.SelectedValue); us.OriginLocation = ""; us.UnitLine = ""; us.ETALocation = ""; us.Sequence = ""; us.Track = ""; us.LastLocation = ""; us.DemurageDays = 0; us.InTransitDays = 0; us.TotalBilled = (double?)unit.TotalBilled; us.LastUpdate = DateAndTime.Now; us.ActiveUpdates = true; us.Active = true; us.RecordKey = 0; us.CargoDescription = ""; us.ShipperId = 0; us.ETADate = default; us.BillDate = default; us.CallDate = default; us.AvailableDate = default; us.ArrivalDate = default; us.ReleaseDate = default; unitService.AddOrUpdate(us); insertedUSId = unitService.GetLastUnitSourceId(); mu = new MiniUnit(); mu.MiniUnitOrder = 1; mu.UnitSourceId = insertedUSId; mu.TotalBilled = unit.TotalBilled; mu.UnBilled = 0; mu.BilledByUnit = 0; mu.BilledByUnitUnitType = unitBilled; mu.UnBilledByUnit = 0; mu.UnBilledByUnitUnitType = unitBilled; mu.MULocation = ""; mu.Comments = ""; mu.CustomerId = Conversions.ToInteger(cboCustomer.SelectedValue); mu.GradeId = Conversions.ToInteger(cboGrade.SelectedValue); mu.CommodityId = Conversions.ToInteger(cboCommodity.SelectedValue); mu.BalanceToStorageAllowed = true; mu.isMultiMU = false; muService.InsertOrUpdate(mu); } } // My.MyProject.Forms.FrmParentScreen.HideLoadForm(); var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Success!", "Units added with success. Do you want continue creating/updating units?", My.Resources.Resources.icon_available, this); if (!(result == DialogResult.Yes)) { Close(); } else { UnitList.Clear(); AllUnits = UnitSourceService.GetByActiveStatus(Conversions.ToBoolean(1)); tbUnits.Text = ""; } } }
public bool InsertOrUpdate(MiniUnit MURecord) { return(repository.InsertOrUpdate(MURecord)); }