public ExcelModel(
     string nameOfMaterial,
     string firstSystemName,
     string secondSystemName,
     string firstSystemOxide,
     string secondSystemOxide,
     List<int> temperatures,
     List<BaseCompositionModel> oxides,
     List<SystemsByTemperaturesModel> temperaturesModels,
     List<SystemsByTemperaturesModel> resultTemperaturesModels,
     float firstSystemModule,
     float secondSystemModule,
     List<OxidesByTemperatureModel> oxidesResultModel,
     PhasesSystem firstSystem,
     PhasesSystem secondSystem,
     float sumR2O)
 {
     this.NameOfMaterial = nameOfMaterial;
     this.FirstSystemName = firstSystemName;
     this.SecondSystemName = secondSystemName;
     this.FirstSystemOxide = firstSystemOxide;
     this.SecondSystemOxide = secondSystemOxide;
     this.Oxides = oxides;
     this.Temperatures = temperatures;
     this.TemperaturesModels = temperaturesModels;
     this.ResultTemperaturesModels = resultTemperaturesModels;
     this.FirstSystemModule = firstSystemModule;
     this.SecondSystemModule = secondSystemModule;
     this.OxidesResultModel = oxidesResultModel;
     this.FirstSystem = firstSystem;
     this.SecondSystem = secondSystem;
     this.SumR2O = sumR2O;
     this.SetMeltsOxides();
 }
        public PhaseSystemModel(PhasesSystem system)
        {
            this.Formula = system.Formula;
            this.Phases = new List<PhaseModel>();
            foreach (var phase in system.Phases)
            {
                Phases.Add(new PhaseModel(){ Phase = phase });
            }

            this.SolidSumOxides = new List<OxideResultModel>();
            foreach (var oxide in system.Oxides)
            {
                this.SolidSumOxides.Add(new OxideResultModel()
                                            {
                                                Oxide = oxide
                                            });
            }
        }
Example #3
0
        public static void Start()
        {
            //Setup SQL Server Connection Factory
            //var dbFactory =
            //    new OrmLiteConnectionFactory(
            //        @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\Database1.mdf;Integrated Security=True;User Instance=True", SqliteDialect.Provider);

            ////Use in-memory Sqlite DB instead
            //dbFactory = new OrmLiteConnectionFactory(AppDomain.CurrentDomain.BaseDirectory + "Chemical.sqlite", false, SqliteDialect.Provider);

            //Non-intrusive: All extension methods hang off System.Data.* interfaces
            IDbConnection db = dbFactory.OpenDbConnection();

            //Re-Create all table schemas:
            db.DropTable<Oxide>();
            db.DropTable<Phase>();
            db.DropTable<PhasesSystem>();
            //db.DropTable<Project>();

            db.CreateTable<Oxide>();
            db.CreateTable<Phase>();
            db.CreateTable<PhasesSystem>();
            //db.CreateTable<Project>();
            #region data
            var sio2 = new Oxide() { Formula = "SiO2" , IsDefault = true, IsRequred = true};
            var al2o3 = new Oxide() { Formula = "Al2O3", IsDefault = true, IsRequred = true };
            var cao = new Oxide() { Formula = "CaO", IsDefault = true, IsRequred = false };
            var k2o = new Oxide() { Formula = "K2O", IsDefault = true, IsRequred = false };
            var na2o = new Oxide() { Formula = "Na2O", IsDefault = true, IsRequred = false };
            var mgo = new Oxide() { Formula = "MgO", IsDefault = true, IsRequred = false };
            var tio2 = new Oxide() { Formula = "TiO2", IsDefault = false, IsRequred = false };
            var fe2o3 = new Oxide() { Formula = "Fe2O3", IsDefault = true, IsRequred = false };
            db.Save(sio2, al2o3, cao, k2o, na2o, mgo, tio2, fe2o3);
            var mno = new Oxide() { Formula = "MnO", IsDefault = false, IsRequred = false };
            var feo = new Oxide() { Formula = "FeO", IsDefault = false, IsRequred = false };
            var p2o5 = new Oxide() { Formula = "P2O5", IsDefault = false, IsRequred = false };
            var b2o3 = new Oxide() { Formula = "B2O3", IsDefault = false, IsRequred = false };
            var li2o = new Oxide() { Formula = "Li2O", IsDefault = false, IsRequred = false };
            var sro = new Oxide() { Formula = "SrO", IsDefault = false, IsRequred = false };
            var bao = new Oxide() { Formula = "BaO", IsDefault = false, IsRequred = false };
            var zno = new Oxide() { Formula = "ZnO", IsDefault = false, IsRequred = false };
            var pbo = new Oxide() { Formula = "PbO", IsDefault = false, IsRequred = false };
            var beo = new Oxide() { Formula = "BeO", IsDefault = false, IsRequred = false };
            var cuo = new Oxide() { Formula = "CuO", IsDefault = false, IsRequred = false };
            var zro2 = new Oxide() { Formula = "ZrO2", IsDefault = false, IsRequred = false };
            var sno2 = new Oxide() { Formula = "SnO2", IsDefault = false, IsRequred = false };
            var nio = new Oxide() { Formula = "NiO", IsDefault = false, IsRequred = false };
            var coo = new Oxide() { Formula = "CoO", IsDefault = false, IsRequred = false };
            var cdo = new Oxide() { Formula = "CdO", IsDefault = false, IsRequred = false };
            var f = new Oxide() { Formula = "F", IsDefault = false, IsRequred = false };
            db.Save(mno, feo, p2o5, b2o3, li2o, sro, bao, zno, pbo, beo, cuo, zro2, sno2, nio, coo, cdo, f);
            var dbOxides = db.Select<Oxide>();
            sio2 = dbOxides.FirstOrDefault(x => x.Formula.Equals(sio2.Formula));
            al2o3 = dbOxides.FirstOrDefault(x => x.Formula.Equals(al2o3.Formula));
            cao = dbOxides.FirstOrDefault(x => x.Formula.Equals(cao.Formula));
            k2o = dbOxides.FirstOrDefault(x => x.Formula.Equals(k2o.Formula));
            na2o = dbOxides.FirstOrDefault(x => x.Formula.Equals(na2o.Formula));
            mgo = dbOxides.FirstOrDefault(x => x.Formula.Equals(mgo.Formula));
            var a = new Phase() { Formula = "A" };
            a.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 100 });

            var s = new Phase() { Formula = "S" };
            s.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 100 });

            var nas2 = new Phase() { Formula = "NAS2" };
            nas2.Oxides.Add(new PhaseOxideContent() { Oxide = na2o, Percentage = 21.82f });
            nas2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 35.88f });
            nas2.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 42.30f });

            var nas6 = new Phase() { Formula = "NAS6" };
            nas6.Oxides.Add(new PhaseOxideContent() { Oxide = na2o, Percentage = 11.82f });
            nas6.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 19.44f });
            nas6.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 68.74f });

            var n2as2 = new Phase() { Formula = "N2AS2" };
            n2as2.Oxides.Add(new PhaseOxideContent() { Oxide = na2o, Percentage = 35.82f });
            n2as2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 29.45f });
            n2as2.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 34.72f });

            var kas6 = new Phase() { Formula = "KAS6" };
            kas6.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 18.32f });
            kas6.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 64.76f });
            kas6.Oxides.Add(new PhaseOxideContent() { Oxide = k2o, Percentage = 16.92f });

            var a3s2 = new Phase() { Formula = "A3S2" };
            a3s2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 71.79f });
            a3s2.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 28.21f });

            var kas4 = new Phase() { Formula = "KAS4" };
            kas4.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 23.36f });
            kas4.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 55.06f });
            kas4.Oxides.Add(new PhaseOxideContent() { Oxide = k2o, Percentage = 21.58f });

            var cas2 = new Phase() { Formula = "CAS2" };
            cas2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 36.65f });
            cas2.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 43.19f });
            cas2.Oxides.Add(new PhaseOxideContent() { Oxide = cao, Percentage = 20.16f });

            var c2as = new Phase() { Formula = "C2AS" };
            c2as.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 37.19f });
            c2as.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 21.91f });
            c2as.Oxides.Add(new PhaseOxideContent() { Oxide = cao, Percentage = 40.90f });

            var ca6 = new Phase() { Formula = "CA6" };
            ca6.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 91.60f });
            ca6.Oxides.Add(new PhaseOxideContent() { Oxide = cao, Percentage = 8.40f });

            var cs = new Phase() { Formula = "CS" };
            cs.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 51.72f });
            cs.Oxides.Add(new PhaseOxideContent() { Oxide = cao, Percentage = 48.28f });

            var ca2 = new Phase() { Formula = "CA2" };
            ca2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 78.43f });
            ca2.Oxides.Add(new PhaseOxideContent() { Oxide = cao, Percentage = 21.57f });

            var m2a2s5 = new Phase() { Formula = "M2A2S5" };
            m2a2s5.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 34.86f });
            m2a2s5.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 51.36f });
            m2a2s5.Oxides.Add(new PhaseOxideContent() { Oxide = mgo, Percentage = 13.78f });

            var ms = new Phase() { Formula = "MS" };
            ms.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 59.85f });
            ms.Oxides.Add(new PhaseOxideContent() { Oxide = mgo, Percentage = 40.15f });

            var m2s = new Phase() { Formula = "M2S" };
            m2s.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 42.71f });
            m2s.Oxides.Add(new PhaseOxideContent() { Oxide = mgo, Percentage = 57.29f });

            var m4a5s2 = new Phase() { Formula = "M4A5S2" };
            m4a5s2.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 64.43f });
            m4a5s2.Oxides.Add(new PhaseOxideContent() { Oxide = sio2, Percentage = 15.19f });
            m4a5s2.Oxides.Add(new PhaseOxideContent() { Oxide = mgo, Percentage = 20.38f });

            var ma = new Phase() { Formula = "MA" };
            ma.Oxides.Add(new PhaseOxideContent() { Oxide = al2o3, Percentage = 71.67f });
            ma.Oxides.Add(new PhaseOxideContent() { Oxide = mgo, Percentage = 28.33f });

            db.Save(nas2, nas6, n2as2, kas6, a3s2, kas4, cas2, c2as, ca6, cs, ca2, m2a2s5, ms, m2s, m4a5s2, ma);

            var k2oSystem = new PhasesSystem() { Formula = "K2O–Al2O3–SiO2" };
            k2oSystem.Oxides.AddRange(new[] { k2o, al2o3, sio2 });
            k2oSystem.Phases.AddRange(new[] { a, s, kas4, kas6, a3s2 });
            var na2oSystem = new PhasesSystem() { Formula = "Na2O–Al2O3–SiO2" };
            na2oSystem.Oxides.AddRange(new[] { na2o, al2o3, sio2 });
            na2oSystem.Phases.AddRange(new[] { a, s, a3s2, n2as2, nas2, nas6 });
            var caoSystem = new PhasesSystem() { Formula = "CaO–Al2O3–SiO2" };
            caoSystem.Oxides.AddRange(new[] { cao, al2o3, sio2 });
            caoSystem.Phases.AddRange(new[] { a, s, a3s2, c2as, ca2, ca6, cas2, cs });
            var mgoSystem = new PhasesSystem() { Formula = "MgO–Al2O3–SiO2" };
            mgoSystem.Oxides.AddRange(new[] { mgo, al2o3, sio2 });
            mgoSystem.Phases.AddRange(new[] { a, s, a3s2, m2a2s5, m2s, m4a5s2, ma, ms });

            db.Save(k2oSystem, na2oSystem, caoSystem, mgoSystem);
            #endregion
        }
 private void SetSystems()
 {
     this.GetSystemsOxides();
     var systems = Sqlite.GetSystems(firstOxide, secondOxide).ToList();
     this.FirstSystem = systems.FirstOrDefault();
     this.SecondSystem = systems.LastOrDefault();
     MessageBox.Show(string.Format("{0}\n{1}", this.FirstSystem.Formula, this.SecondSystem.Formula));
 }
 public SystemsByTemperaturesModel(PhasesSystem firstSystem, PhasesSystem secondSystem, int temperature)
 {
     this.FirstSystem = new PhaseSystemModel(firstSystem);
     this.SecondSystem = new PhaseSystemModel(secondSystem);
     this.Temperature = temperature;
 }