Exemple #1
0
        public void DmTable_AcceptChanges()
        {
            tbl.AcceptChanges();

            foreach (var dmRow in tbl.Rows)
            {
                Assert.Equal(DmRowState.Unchanged, dmRow.RowState);
            }
        }
        public DmSurrogateTests()
        {
            set = new DmSet("ClientDmSet");

            var tbl = new DmTable("ServiceTickets");

            set.Tables.Add(tbl);
            var id = new DmColumn <Guid>("ServiceTicketID");

            tbl.Columns.Add(id);
            var key = new DmKey(new DmColumn[] { id });

            tbl.PrimaryKey = key;
            tbl.Columns.Add(new DmColumn <string>("Title"));
            tbl.Columns.Add(new DmColumn <string>("Description"));
            tbl.Columns.Add(new DmColumn <int>("StatusValue"));
            tbl.Columns.Add(new DmColumn <int>("EscalationLevel"));
            tbl.Columns.Add(new DmColumn <DateTime>("Opened"));
            tbl.Columns.Add(new DmColumn <DateTime>("Closed"));
            tbl.Columns.Add(new DmColumn <int>("CustomerID"));
            tbl.Columns.Add(new DmColumn <Object>("VariantObject"));

            #region adding rows
            var st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre AER";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 1;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 1;
            st["VariantObject"]   = DateTime.Now;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre DE";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 3;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 1;
            st["VariantObject"]   = 12;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre FF";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 3;
            st["StatusValue"]     = 4;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 2;
            st["VariantObject"]   = new { Prop1 = 12, Prop2 = DateTime.Now };
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre AC";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 1;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 2;
            st["VariantObject"]   = null;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre ZDZDZ";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 2;
            st["VariantObject"]   = "Hello";
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre VGH";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            st["VariantObject"]   = DmRowState.Added;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre ETTG";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 2;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            st["VariantObject"]   = 0;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre SADZD";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 1;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            st["VariantObject"]   = new Byte[0];
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre AEEE";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 0;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 1;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre CZDADA";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 0;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre AFBBB";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 3;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre AZDCV";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 2;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 2;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre UYTR";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre NHJK";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 1;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre XCVBN";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 1;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 2;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre LKNB";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 3;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 3;
            tbl.Rows.Add(st);

            st = tbl.NewRow();
            st["ServiceTicketID"] = Guid.NewGuid();
            st["Title"]           = "Titre ADFVB";
            st["Description"]     = "Description 2";
            st["EscalationLevel"] = 0;
            st["StatusValue"]     = 2;
            st["Opened"]          = DateTime.Now;
            st["Closed"]          = null;
            st["CustomerID"]      = 1;
            tbl.Rows.Add(st);
            #endregion

            tbl.AcceptChanges();
        }