public static List<EmployeeProject> findList(string @where, params object[] @params) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return dbm.findList(@where, @params); }
/// <summary> /// Convinience method to save a EmployeeProject Object. /// Important note: DO NOT CALL THIS IN A LOOP! /// </summary> /// <param name="EmployeeProjectObj"></param> /// <remarks> /// Important note: DO NOT CALL THIS IN A LOOP! /// This method simply instantiates a EmployeeProjectDBMapper and calls the save method /// </remarks> public static void saveEmployeeProject(params EmployeeProject[] EmployeeProjectObj) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); dbm.saveList(EmployeeProjectObj.ToList()); }
public static void deleteEmployeeProject(EmployeeProject EmployeeProjectObj) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); dbm.delete(EmployeeProjectObj); }
public static List<EmployeeProject> findList(string @where, List<IDataParameter> listOfIParams) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return dbm.findList(@where,listOfIParams); }
public static EmployeeProject findOne(string @where, params object[] @params) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return (EmployeeProject)dbm.findWhere(@where, @params); }
[TestMethod()] public void TestLoadAndSaveEmployeeProject() { ModelContext.beginTrans(); try { CsModelMappers.EmployeeProjectDBMapper pdb = new CsModelMappers.EmployeeProjectDBMapper(); 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 EmployeeProject in database, table is empty"); } else { /** * using (DataContext ctx = DBUtils.Current().dbContext()) { * * var query = ctx.ExecuteQuery<EmployeeProject>(@"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); EmployeeProject p = pdb.findByKey(pid); EmployeeProject p2 = (EmployeeProject)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.PrEmployeeProjectId == p2.PrEmployeeProjectId, "Expected Field EmployeeProjectId to be equal"); Assert.IsTrue(p.PrEPEmployeeId.GetValueOrDefault() == p2.PrEPEmployeeId.GetValueOrDefault(), "Expected Field EPEmployeeId to be equal"); Assert.IsTrue(p.PrEPProjectId.GetValueOrDefault() == p2.PrEPProjectId.GetValueOrDefault(), "Expected Field EPProjectId to be equal"); Assert.IsTrue(p.PrAssignDate.GetValueOrDefault() == p2.PrAssignDate.GetValueOrDefault(), "Expected Field AssignDate to be equal"); Assert.IsTrue(p.PrEndDate.GetValueOrDefault() == p2.PrEndDate.GetValueOrDefault(), "Expected Field EndDate to be equal"); Assert.IsTrue(p.PrRate.GetValueOrDefault() == p2.PrRate.GetValueOrDefault(), "Expected Field Rate to be equal"); p.isDirty = true; //to force save ModelContext.Current.saveModelObject(p); p = ModelContext.Current.loadModelObject <EmployeeProject>(p.Id); p.loadObjectHierarchy(); string json = JsonConvert.SerializeObject(p, Formatting.Indented, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeProject.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! } }
public static EmployeeProject findOne(string @where, params object[] @params) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return((EmployeeProject)dbm.findWhere(@where, @params)); }
public static List <EmployeeProject> findList(string @where, List <IDataParameter> listOfIParams) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return(dbm.findList(@where, listOfIParams)); }
public static List <EmployeeProject> findList(string @where, params object[] @params) { EmployeeProjectDBMapper dbm = new EmployeeProjectDBMapper(); return(dbm.findList(@where, @params)); }
public void TestLoadAndSaveEmployeeProject() { ModelContext.beginTrans(); try { CsModelMappers.EmployeeProjectDBMapper pdb = new CsModelMappers.EmployeeProjectDBMapper(); 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 EmployeeProject in database, table is empty"); } else { /** using (DataContext ctx = DBUtils.Current().dbContext()) { var query = ctx.ExecuteQuery<EmployeeProject>(@"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); EmployeeProject p = pdb.findByKey(pid); EmployeeProject p2 = (EmployeeProject)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.PrEmployeeProjectId==p2.PrEmployeeProjectId,"Expected Field EmployeeProjectId to be equal"); Assert.IsTrue(p.PrEPEmployeeId.GetValueOrDefault() ==p2.PrEPEmployeeId.GetValueOrDefault(),"Expected Field EPEmployeeId to be equal"); Assert.IsTrue(p.PrEPProjectId.GetValueOrDefault() ==p2.PrEPProjectId.GetValueOrDefault(),"Expected Field EPProjectId to be equal"); Assert.IsTrue(p.PrAssignDate.GetValueOrDefault() ==p2.PrAssignDate.GetValueOrDefault(),"Expected Field AssignDate to be equal"); Assert.IsTrue(p.PrEndDate.GetValueOrDefault() ==p2.PrEndDate.GetValueOrDefault(),"Expected Field EndDate to be equal"); Assert.IsTrue(p.PrRate.GetValueOrDefault() ==p2.PrRate.GetValueOrDefault(),"Expected Field Rate to be equal"); p.isDirty = true; //to force save ModelContext.Current.saveModelObject(p); p = ModelContext.Current.loadModelObject< EmployeeProject >(p.Id); p.loadObjectHierarchy(); string json = JsonConvert.SerializeObject(p,Formatting.Indented, new JsonSerializerSettings(){ ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeProject.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! } }