public void DeleteUnit() { EAV.Store.Clients.IUnitStoreClient client = factory.Create <EAV.Store.Clients.IUnitStoreClient>(); EAVStoreClient.Unit dbUnitIn = CreateUnit("SYM", Guid.NewGuid().ToString()); client.DeleteUnit(dbUnitIn.Unit_ID); EAVStoreClient.Unit dbUnitOut = this.DbContext.Units.SingleOrDefault(it => it.Unit_ID == dbUnitIn.Unit_ID); Assert.IsNull(dbUnitOut, "Failed to delete Unit ID {0} from the database.", dbUnitIn.Unit_ID); }
public void UpdateUnit(EAV.Store.IStoreUnit aUnit) { using (EAVStoreClient.MicroEAVContext ctx = new MicroEAVContext()) { EAVStoreClient.Unit dbUnit = ctx.Units.SingleOrDefault(it => it.Unit_ID == aUnit.UnitID); if (dbUnit != null) { if (dbUnit.Singular_Name != aUnit.SingularName) { dbUnit.Singular_Name = aUnit.SingularName; } if (dbUnit.Singular_Abbreviation != aUnit.SingularAbbreviation) { dbUnit.Singular_Abbreviation = aUnit.SingularAbbreviation; } if (dbUnit.Plural_Name != aUnit.PluralName) { dbUnit.Plural_Name = aUnit.PluralName; } if (dbUnit.Plural_Abbreviation != aUnit.PluralAbbreviation) { dbUnit.Plural_Abbreviation = aUnit.PluralAbbreviation; } if (dbUnit.Symbol != aUnit.Symbol) { dbUnit.Symbol = aUnit.Symbol; } if (dbUnit.Display_Text != aUnit.DisplayText) { dbUnit.Display_Text = aUnit.DisplayText; } if (dbUnit.Curated != aUnit.Curated) { dbUnit.Curated = aUnit.Curated; } ctx.SaveChanges(); } else { throw (new Exception(String.Format("Unable to retrieve Unit ID {0}.", aUnit.UnitID))); } } }
private static EAVStoreClient.Value CreateValue(int attributeID, int instanceID, string value, EAVStoreClient.Unit unit = null) { EAVStoreClient.Value dbValue; using (EAVStoreClient.MicroEAVContext ctx = new EAVStoreClient.MicroEAVContext()) { dbValue = ctx.Values.Add(new EAVStoreClient.Value() { Attribute_ID = attributeID, Instance_ID = instanceID, Unit = unit, Raw_Value = value, }); ctx.SaveChanges(); } return(dbValue); }