예제 #1
0
    [TestMethod()] public void TestLoadAndSaveEmployeeTrainingHistory()
    {
        ModelContext.beginTrans();
        try {
            OracleMappers.EmployeeTrainingHistoryDBMapper pdb = new OracleMappers.EmployeeTrainingHistoryDBMapper();

            long count = pdb.RecordCount();

            if (pdb.SelectFromObjectName != pdb.ManagedTableName)
            {
                long countFromSelectObject = pdb.dbConn.getLngValue("select count(*) from " + pdb.SelectFromObjectName);
                Assert.AreEqual(count, countFromSelectObject,
                                "Count of records in managedTableName {0} and SelectFromObjectName {1} should be equal, as there needs to be exactly 1 to 1 match between records in managed table and selectFromObject.",
                                pdb.ManagedTableName, pdb.SelectFromObjectName);
            }

            if (count == 0)
            {
                Assert.Inconclusive("No EmployeeTrainingHistory in database, table is empty");
            }
            else
            {
                /**
                 * using (DataContext ctx = DBUtils.Current().dbContext()) {
                 *
                 *      var query = ctx.ExecuteQuery<EmployeeTrainingHistory>(@"SELECT * FROM " + pdb.SelectFromObjectName ).Skip(1).Take(1);
                 *      var lst = query.ToList();
                 *
                 *      Assert.AreEqual(lst.Count, 1, "Expected to receive 1 record, got: " + lst.Count);
                 *
                 * }
                 * todo: fix boolean fields by generating properties of original fields
                 **/
                object pid = ModelContext.CurrentDBUtils.getObjectValue("select top 1 " + pdb.pkFieldName + " from " + pdb.ManagedTableName);

                EmployeeTrainingHistory p  = pdb.findByKey(pid);
                EmployeeTrainingHistory p2 = (EmployeeTrainingHistory)p.copy();

                //Test equality and hash codes
                Assert.AreEqual(p.GetHashCode(), p2.GetHashCode());
                Assert.AreEqual(p, p2);

                p.isDirty = true;                  // force save
                pdb.save(p);

                // now reload object from database
                p = null;
                p = pdb.findByKey(pid);

                //test fields to be equal before and after save
                Assert.IsTrue(p.PrEmployeeTrainingHistoryId == p2.PrEmployeeTrainingHistoryId, "Expected Field EmployeeTrainingHistoryId to be equal");
                Assert.IsTrue(p.PrEmployeeId.GetValueOrDefault() == p2.PrEmployeeId.GetValueOrDefault(), "Expected Field EmployeeId to be equal");
                Assert.IsTrue(p.PrDateFrom.GetValueOrDefault() == p2.PrDateFrom.GetValueOrDefault(), "Expected Field DateFrom to be equal");
                Assert.IsTrue(p.PrDateTo.GetValueOrDefault() == p2.PrDateTo.GetValueOrDefault(), "Expected Field DateTo to be equal");
                Assert.IsTrue(p.PrTrainingCourseCode == p2.PrTrainingCourseCode, "Expected Field TrainingCourseCode to be equal");



                p.isDirty = true;                 //to force save
                ModelContext.Current.saveModelObject(p);

                p = ModelContext.Current.loadModelObject <EmployeeTrainingHistory>(p.Id);
                p.loadObjectHierarchy();

                string json = JsonConvert.SerializeObject(p, Formatting.Indented,
                                                          new JsonSerializerSettings()
                {
                    ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                });
                System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeTrainingHistory.json");
                System.IO.File.WriteAllText(jf.FullName, json);

                if (pdb.isPrimaryKeyAutogenerated)
                {
                    p.isNew   = true;
                    p.isDirty = true;

                    try {
                        pdb.save(p);
                    } catch (System.Exception e) {
                        Assert.IsTrue(e.Message.ToUpper().Contains("UNIQUE INDEX") || e.Message.Contains("Violation of UNIQUE KEY constraint"),
                                      "Insert statement produced error other than violation of unique key:" + e.Message);
                    }
                }
            }
        } finally {
            ModelContext.rollbackTrans(); // 'Nothing should be saved to the database!
        }
    }
        /// <summary>
        /// Convinience method to save a EmployeeTrainingHistory Object.
        /// Important note: DO NOT CALL THIS IN A LOOP!
        /// </summary>
        /// <param name="EmployeeTrainingHistoryObj"></param>
        /// <remarks>
        /// Important note: DO NOT CALL THIS IN A LOOP!
        /// This method simply instantiates a EmployeeTrainingHistoryDBMapper and calls the save method
        /// </remarks>
        public static void saveEmployeeTrainingHistory(params EmployeeTrainingHistory[] EmployeeTrainingHistoryObj)
        {
            EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();

            dbm.saveList(EmployeeTrainingHistoryObj.ToList());
        }
        public static void deleteEmployeeTrainingHistory(EmployeeTrainingHistory EmployeeTrainingHistoryObj)
        {
            EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();

            dbm.delete(EmployeeTrainingHistoryObj);
        }
        public static List <EmployeeTrainingHistory> findList(string @where, List <IDataParameter> listOfIParams)
        {
            EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();

            return(dbm.findList(@where, listOfIParams));
        }
        public static EmployeeTrainingHistory findOne(string @where, params object[] @params)
        {
            EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();

            return((EmployeeTrainingHistory)dbm.findWhere(@where, @params));
        }
 public static List<EmployeeTrainingHistory> findList(string @where, List<IDataParameter> listOfIParams)
 {
     EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
     return dbm.findList(@where,listOfIParams);
 }
        public static List <EmployeeTrainingHistory> findList(string @where, params object[] @params)
        {
            EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();

            return(dbm.findList(@where, @params));
        }
 public static List<EmployeeTrainingHistory> findList(string @where, params object[] @params)
 {
     EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
     return dbm.findList(@where, @params);
 }
 public static void deleteEmployeeTrainingHistory(EmployeeTrainingHistory EmployeeTrainingHistoryObj)
 {
     EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
     dbm.delete(EmployeeTrainingHistoryObj);
 }
 /// <summary>
 /// Convinience method to save a EmployeeTrainingHistory Object.
 /// Important note: DO NOT CALL THIS IN A LOOP!
 /// </summary>
 /// <param name="EmployeeTrainingHistoryObj"></param>
 /// <remarks>
 /// Important note: DO NOT CALL THIS IN A LOOP!  
 /// This method simply instantiates a EmployeeTrainingHistoryDBMapper and calls the save method
 /// </remarks>
 public static void saveEmployeeTrainingHistory(params EmployeeTrainingHistory[] EmployeeTrainingHistoryObj)
 {
     EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
     dbm.saveList(EmployeeTrainingHistoryObj.ToList());
 }
 public static EmployeeTrainingHistory findOne(string @where, params object[] @params)
 {
     EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
     return (EmployeeTrainingHistory)dbm.findWhere(@where, @params);
 }
    public void TestLoadAndSaveEmployeeTrainingHistory()
    {
        ModelContext.beginTrans();
        try {

            OracleMappers.EmployeeTrainingHistoryDBMapper pdb = new OracleMappers.EmployeeTrainingHistoryDBMapper();

            long count = pdb.RecordCount();

            if (pdb.SelectFromObjectName != pdb.ManagedTableName) {
                long countFromSelectObject = pdb.dbConn.getLngValue("select count(*) from " + pdb.SelectFromObjectName);
                Assert.AreEqual(count, countFromSelectObject,
                    "Count of records in managedTableName {0} and SelectFromObjectName {1} should be equal, as there needs to be exactly 1 to 1 match between records in managed table and selectFromObject.",
                    pdb.ManagedTableName, pdb.SelectFromObjectName);
            }

            if (count == 0) {
                Assert.Inconclusive("No EmployeeTrainingHistory in database, table is empty");
            } else {
                /**
                using (DataContext ctx = DBUtils.Current().dbContext()) {

                    var query = ctx.ExecuteQuery<EmployeeTrainingHistory>(@"SELECT * FROM " + pdb.SelectFromObjectName ).Skip(1).Take(1);
                    var lst = query.ToList();

                    Assert.AreEqual(lst.Count, 1, "Expected to receive 1 record, got: " + lst.Count);

                }
                todo: fix boolean fields by generating properties of original fields
                **/
                object pid  = ModelContext.CurrentDBUtils.getObjectValue("select top 1 " + pdb.pkFieldName + " from " + pdb.ManagedTableName);

                EmployeeTrainingHistory p = pdb.findByKey(pid);
                EmployeeTrainingHistory p2 = (EmployeeTrainingHistory)p.copy();

                //Test equality and hash codes
                Assert.AreEqual(p.GetHashCode(), p2.GetHashCode());
                Assert.AreEqual(p, p2);

                p.isDirty = true ; // force save
                pdb.save(p);

                // now reload object from database
                p = null;
                p = pdb.findByKey(pid);

                //test fields to be equal before and after save
                Assert.IsTrue(p.PrEmployeeTrainingHistoryId==p2.PrEmployeeTrainingHistoryId,"Expected Field EmployeeTrainingHistoryId to be equal");
                Assert.IsTrue(p.PrEmployeeId.GetValueOrDefault() ==p2.PrEmployeeId.GetValueOrDefault(),"Expected Field EmployeeId to be equal");
                Assert.IsTrue(p.PrDateFrom.GetValueOrDefault() ==p2.PrDateFrom.GetValueOrDefault(),"Expected Field DateFrom to be equal");
                Assert.IsTrue(p.PrDateTo.GetValueOrDefault() ==p2.PrDateTo.GetValueOrDefault(),"Expected Field DateTo to be equal");
                Assert.IsTrue(p.PrTrainingCourseCode==p2.PrTrainingCourseCode,"Expected Field TrainingCourseCode to be equal");

                p.isDirty = true; //to force save
                ModelContext.Current.saveModelObject(p);

                p = ModelContext.Current.loadModelObject< EmployeeTrainingHistory >(p.Id);
                p.loadObjectHierarchy();

                string json = JsonConvert.SerializeObject(p,Formatting.Indented,
                    new JsonSerializerSettings(){
                            ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                        });
                System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeTrainingHistory.json");
                System.IO.File.WriteAllText(jf.FullName,json);

                if (pdb.isPrimaryKeyAutogenerated) {
                    p.isNew = true;
                    p.isDirty = true;

                    try {
                        pdb.save(p);
                    } catch (System.Exception e) {
                        Assert.IsTrue(e.Message.ToUpper().Contains("UNIQUE INDEX")||e.Message.Contains("Violation of UNIQUE KEY constraint"),
                            "Insert statement produced error other than violation of unique key:"+e.Message);

                    }
                }

            }

        } finally {
            ModelContext.rollbackTrans(); // 'Nothing should be saved to the database!
        }
    }