public ProjektCollection GetUntergeordneteProjekte(int ProjektID) { string pNumber = string.Empty; var buf = from n in db.projekte where n.id == ProjektID select n.ursprungsprojekt; pNumber = buf.FirstOrDefault(); // pNumber = db.projekte.Where(p => p.id == ProjektID).FirstOrDefault().ursprungsprojekt; // wirft Exception wenn ProjektId = 0; if (pNumber == string.Empty || pNumber == null) { return(null); } var ur = from up in db.projekte where up.ursprungsprojekt == pNumber select up; var pc = new ProjektCollection(ur, this.db); return(pc); }
public ProjektCollection GetAlleProjekte() { var result = from p in db.projekte.Include("projekt_verlauf") select p; var pc = new ProjektCollection(result, this.db); return(pc); }
public ProjektCollection GetLikeTest() { var test = from p in db.projekte where p.projektnummer.Contains("111") select p; var res = new ProjektCollection(test, db); return(res); }
public ProjektCollection GetLeerprojekt() { var result = from p in db.projekte where p.id == 0 select p; var pc = new ProjektCollection(result, this.db); return(pc); }
public ProjektCollection GetProjekteListe() { var result = from p in db.projekte where p.datum >= new DateTime(2011, 05, 1) orderby p.projektnummer descending select p; var pc = new ProjektCollection(result, this.db); return(pc); }
public ProjektCollection GetLikeTest2() { var p = db.projekte .Where("it.type = 'anlage' and it.firmenname = 'Jets As'") .OrderBy("it.projektnummer desc"); var res = new ProjektCollection(p.Skip(4).Take(3), db); return(res); }
public ProjektCollection GetProjekteByID(int ProjektID) { var result = from p in db.projekte //.Include("projekt_verlauf") where p.id == ProjektID select p; var pc = new ProjektCollection(result, this.db); return(pc); }
public void TestInitialize() { dbConnection = new DbConnection(); checks = new Checks(); projektCollection = ProjektCollection._instance; startdate = new DateTime(2018, 01, 01); finaldate = new DateTime(2018, 05, 01); medarbejder = new Employee("Erik", 2); dataManegment = new DataManegment(); budgetContrainer = new BudgetContrainer(); }
public ProjektCollection GetProjekteListe(int page, int rowsPerPage) { int toSkip = (page - 1) * rowsPerPage; var result = from p in db.projekte where p.datum >= new DateTime(2004, 01, 1) orderby p.projektnummer descending select p; var pc = new ProjektCollection(result.Skip(toSkip).Take(rowsPerPage), this.db); return(pc); }
public ProjektCollection GetUntergeordneteProjekte(int ProjektID) { var buf = from n in db.projekte where n.id == ProjektID select n.projektnummer; string pNumber = buf.FirstOrDefault(); var ur = from up in db.projekte where up.ursprungsprojekt == pNumber select up; var pc = new ProjektCollection(ur, this.db); return(pc); }
public ProjektCollection GetProjektData(string filter, int toSkip, int toTake) { System.Data.Objects.ObjectQuery<projekt> p; if (filter == string.Empty || filter == null) { p = db.projekte .OrderBy("it.created desc"); } else { p = db.projekte .Where(filter) .OrderBy("it.created desc"); } RecordCount = p.Count(); var res = new ProjektCollection(p.Skip(toSkip).Take(toTake), db); return res; }