Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }