Example #1
0
 /// <summary>
 /// Nieuw Model
 /// </summary>
 /// <param name="databaseConnection"></param>
 /// <param name="brand"></param>
 /// <param name="type"></param>
 /// <param name="dimmable"></param>
 /// <param name="twoWay"></param>
 public Model(Brand brand, string type, bool dimmable, bool twoWay)
     : base(new Vendjuuren.SQL.Table(TableName))
 {
     Brand = brand;
       Type = type;
       Dimmable = dimmable;
       TwoWay = twoWay;
 }
Example #2
0
 /// <summary>
 /// 
 /// </summary>
 /// <param name="name"></param>
 public void GetByBrandAndType(Brand brand, string type)
 {
     SELECT select = new SELECT(Table);
       select.AddWhere(new Column(BrandIDColumnName), Operator.Equals, brand.ID, Vendjuuren.SQL.Boolean.AND);
       select.AddWhere(new Column(TypeColumnName), Operator.Equals, type, Vendjuuren.SQL.Boolean.AND);
       base.GetByStatement(select);
 }
        public void AddDemoData()
        {
            Brand kakuBrand = new Brand();
              kakuBrand.GetByName("KlikaanKlikuit");
              if (kakuBrand.ID == Guid.Empty)
              {
            kakuBrand = new Brand(BrandType.Radiographically, "KlikaanKlikuit", "");
            kakuBrand.Save();
              }

              Brand marmitekBrand = new Brand();
              marmitekBrand.GetByName("Marmitek");
              if (marmitekBrand.ID == Guid.Empty)
              {
            marmitekBrand = new Brand(BrandType.X10, "Marmitek", "");
            marmitekBrand.Save();
              }

              Model switchModel = new Model();
              switchModel.GetByBrandAndType(kakuBrand, "Schakelaar");
              if (switchModel.ID == Guid.Empty)
              {
            switchModel = new Model(kakuBrand, "Schakelaar", false, false);
            switchModel.Save();
              }

              Model dimmModel = new Model();
              dimmModel.GetByBrandAndType(kakuBrand, "Dimmer");
              if (dimmModel.ID == Guid.Empty)
              {
            dimmModel = new Model(kakuBrand, "Dimmer", true, false);
            dimmModel.Save();
              }

              Model lwm1Model = new Model();
              lwm1Model.GetByBrandAndType(kakuBrand, "LWM1");
              if (lwm1Model.ID == Guid.Empty)
              {
            lwm1Model = new Model(marmitekBrand, "LWM1", true, true);
            lwm1Model.Save();
              }

              Letter letterC = Letter.C;
              Group groupC = new Group();
              groupC.GetByLetter(letterC);

              if (groupC.ID == Guid.Empty)
              {
            groupC = new Group(letterC, string.Empty);
            groupC.Save();
              }

              Letter letterE = Letter.E;
              Group groupE = new Group();
              groupE.GetByLetter(letterE);

              if (groupE.ID == Guid.Empty)
              {
            groupE = new Group(letterE, string.Empty);
            groupE.Save();
              }

              Device vaasTvDevice = AddDevice(switchModel, groupC, 1, "VaasTV", "Verlichting in vaas bij TV");
              Device kerstDevice = AddDevice(switchModel, groupC, 2, "Kerst", "Kerstboom en overige kerstverlichting");
              Device gangDevice = AddDevice(switchModel, groupC, 4, "Gang", "Gang beneden");
              Device tuinDevice = AddDevice(switchModel, groupC, 5, "Tuin", "Achtertuin");
              Device drankkastDevice = AddDevice(switchModel, groupC, 6, "Drankkast", "Witte leds in drankkast");
              Device openhaardDevice = AddDevice(switchModel, groupC, 7, "Openhaard", "Openhaard in huiskamer");
              Device dressiorDevice = AddDevice(dimmModel, groupC, 8, "Dressoir", "2 Lampjes op dressior");
              Device aircoSlaapkamerDevice = AddDevice(switchModel, groupC, 9, "AircoSlaapkamer", "Airco in de kledingkast slaapkamer");

              Device eettafelDevice = AddDevice(lwm1Model, groupE, 2, "Eettafel", "Lamp boven de eettafel");
              Device fotoHoekDevice = AddDevice(lwm1Model, groupE, 1, "Fotohoek", "Lamp bij de fotohoek");

              Program kerstProgram = AddProgram(ProgramScheduleMode.Time, ProgramScheduleMode.Time, true, "Kerst",
              "Speciaal voor kerstverlichting in de decembermaand",
              Convert.ToDateTime("06-12"), Convert.ToDateTime("06-01"),
              Convert.ToDateTime("18:00"), Convert.ToDateTime("23:30"));
              kerstProgram.AddDevice(kerstDevice);

              Program verlichtingQ1Program = AddProgram(ProgramScheduleMode.Sun, ProgramScheduleMode.Time, true, "VerlichtingQ1",
              "Verlichting huiskamer 1e kwartaal",
              Convert.ToDateTime("01-01"), Convert.ToDateTime("31-03"),
              Convert.ToDateTime("17:00"), Convert.ToDateTime("23:30"));
              verlichtingQ1Program.AddDevice(vaasTvDevice);
              verlichtingQ1Program.AddDevice(tuinDevice);
              verlichtingQ1Program.AddDevice(drankkastDevice);
              verlichtingQ1Program.AddDevice(openhaardDevice);
              verlichtingQ1Program.AddDevice(dressiorDevice);

              Program verlichtingQ2Program = AddProgram(ProgramScheduleMode.Sun, ProgramScheduleMode.Time, true, "VerlichtingQ2",
             "Verlichting huiskamer 2e kwartaal",
             Convert.ToDateTime("01-04"), Convert.ToDateTime("30-06"),
             Convert.ToDateTime("19:00"), Convert.ToDateTime("23:30"));
              verlichtingQ2Program.AddDevice(vaasTvDevice);
              verlichtingQ2Program.AddDevice(tuinDevice);
              verlichtingQ2Program.AddDevice(drankkastDevice);
              verlichtingQ2Program.AddDevice(openhaardDevice);
              verlichtingQ2Program.AddDevice(dressiorDevice);
              verlichtingQ2Program.AddDevice(aircoSlaapkamerDevice);

              Program verlichtingQ3Program = AddProgram(ProgramScheduleMode.Sun, ProgramScheduleMode.Time, true, "VerlichtingQ3",
             "Verlichting huiskamer 3e kwartaal",
             Convert.ToDateTime("01-07"), Convert.ToDateTime("30-09"),
             Convert.ToDateTime("21:00"), Convert.ToDateTime("0:00"));
              verlichtingQ3Program.AddDevice(vaasTvDevice);
              verlichtingQ3Program.AddDevice(tuinDevice);
              verlichtingQ3Program.AddDevice(drankkastDevice);
              verlichtingQ3Program.AddDevice(openhaardDevice);
              verlichtingQ3Program.AddDevice(dressiorDevice);
              verlichtingQ2Program.AddDevice(aircoSlaapkamerDevice);

              Program verlichtingQ4Program = AddProgram(ProgramScheduleMode.Sun, ProgramScheduleMode.Time, true, "VerlichtingQ4",
             "Verlichting huiskamer 4e kwartaal",
             Convert.ToDateTime("01-10"), Convert.ToDateTime("31-12"),
             Convert.ToDateTime("18:00"), Convert.ToDateTime("23:30"));
              verlichtingQ4Program.AddDevice(vaasTvDevice);
              verlichtingQ4Program.AddDevice(tuinDevice);
              verlichtingQ4Program.AddDevice(drankkastDevice);
              verlichtingQ4Program.AddDevice(openhaardDevice);
              verlichtingQ4Program.AddDevice(dressiorDevice);

              Program randomProgramTuin = AddProgram(ProgramScheduleMode.Random, ProgramScheduleMode.Random, false, "RandomTuin",
             "Random verlichting tuin",
             Convert.ToDateTime("01-01"), Convert.ToDateTime("31-12"),
             null, null);
              randomProgramTuin.AddDevice(tuinDevice);

              Program randomProgramHuiskamer = AddProgram(ProgramScheduleMode.Random, ProgramScheduleMode.Random, false, "RandomHuiskamer",
             "Random verlichting huiskamer",
             Convert.ToDateTime("01-01"), Convert.ToDateTime("31-12"),
             null, null);
              randomProgramHuiskamer.AddDevice(drankkastDevice);
              randomProgramHuiskamer.AddDevice(openhaardDevice);
              randomProgramHuiskamer.AddDevice(dressiorDevice);

              Program randomProgramGang = AddProgram(ProgramScheduleMode.Random, ProgramScheduleMode.Random, false, "RandomGang",
             "Random verlichting gang",
             Convert.ToDateTime("01-01"), Convert.ToDateTime("31-12"),
             null, null);
              randomProgramGang.AddDevice(gangDevice);
        }