private static MasterDataSet.UnitsOfMeasureConversionRow GetUnitsOfMeasureConversionRow(Guid from, Guid to, Guid organizationId) { using (UnitsOfMeasureConversionTableAdapter adapter = new UnitsOfMeasureConversionTableAdapter()) { MasterDataSet.UnitsOfMeasureConversionDataTable table = adapter.GetUnitOfMeasureConversionByOrganizationId(from, to, organizationId); return((table.Count > 0) ? table[0] : null); } }
private static void UpdateMeasureUnitsConversion(Guid measureUnitFrom, Guid measureUnitTo, Guid organizationId, double factor, bool deleted) { if (double.IsNaN(factor) || factor <= 0.0) { throw new ArithmeticException(Resources.MeasureUnitsProvider_ErrorMessage_FactorCannotBeZero); } if (measureUnitFrom.Equals(Guid.Empty) || measureUnitTo.Equals(Guid.Empty) || measureUnitFrom.Equals(measureUnitTo)) { throw new ArgumentException(Resources.MeasureUnitsProvider_ErrorMessage_IncorrectIdentifier); } MasterDataSet.UnitsOfMeasureConversionRow row = GetUnitsOfMeasureConversionRow(measureUnitFrom, measureUnitTo, organizationId); if (row == null) { MasterDataSet.UnitsOfMeasureConversionDataTable table = new MasterDataSet.UnitsOfMeasureConversionDataTable(); row = table.NewUnitsOfMeasureConversionRow(); row.UnitOfMeasureFrom = measureUnitFrom; row.UnitOfMeasureTo = measureUnitTo; row.OrganizationId = organizationId; row.Factor = factor; table.AddUnitsOfMeasureConversionRow(row); } else { if (deleted) { row.Delete(); } else { row.Factor = factor; } } using (UnitsOfMeasureConversionTableAdapter adapter = new UnitsOfMeasureConversionTableAdapter()) { adapter.Update(row); } }