public static DegreeType LoadById(int id) { try { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType row = (from dt in dc.tblDegreeTypes where dt.Id == id select dt).FirstOrDefault(); if (row != null) { return new DegreeType { Id = row.Id, Description = row.Description } } ; else { throw new Exception("Row was not found."); } } } catch (Exception ex) { throw ex; } }
public void LoadById() { try { using (ProgDecEntities dc = new ProgDecEntities()) { if (Id >= 0) { tblDegreeType degreeType = dc.tblDegreeTypes.Where(p => p.Id == Id).FirstOrDefault(); if (degreeType != null) { this.Id = degreeType.Id; this.Description = degreeType.Description; } else { throw new Exception("Row was not found"); } } else { throw new Exception("Id was not set"); } } } catch (Exception ex) { throw ex; } }
public static int Insert(out int id, string description) { try { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType newrow = new tblDegreeType(); newrow.Description = description; newrow.Id = dc.tblDegreeTypes.Any() ? dc.tblDegreeTypes.Max(dt => dt.Id) + 1 : 1; id = newrow.Id; //if(dc.tblDegreeTypes.Any()) //{ // newrow.Id = dc.tblDegreeTypes.Max(dt => dt.Id) + 1; //} //else //{ // newrow.Id = 1; //} dc.tblDegreeTypes.Add(newrow); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int Update() { try { using (ProgDecEntities dc = new ProgDecEntities()) { if (Id >= 0) { tblDegreeType degreeType = dc.tblDegreeTypes.Where(p => p.Id == Id).FirstOrDefault(); if (degreeType != null) { degreeType.Description = this.Description; return(dc.SaveChanges()); } else { throw new Exception("Row was not found"); } } else { throw new Exception("ID is not set"); } } } catch (Exception ex) { throw ex; } }
public void DeleteTest() { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType row = (from dt in dc.tblDegreeTypes where dt.Id == -99 select dt).FirstOrDefault(); if (row != null) { dc.tblDegreeTypes.Remove(row); int actual = dc.SaveChanges(); Assert.AreNotEqual(0, actual); } } }
public static int Delete(int id) { try { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType deleterow = (from dt in dc.tblDegreeTypes where dt.Id == id select dt).FirstOrDefault(); dc.tblDegreeTypes.Remove(deleterow); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public static int Update(int id, string description) { try { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType updaterow = (from dt in dc.tblDegreeTypes where dt.Id == id select dt).FirstOrDefault(); updaterow.Description = description; return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public void UpdateTest() { using (ProgDecEntities dc = new ProgDecEntities()) { // Get the record that I want to update // SELECT * FROM tblDegreeType WHERE Id = -99 tblDegreeType row = (from dt in dc.tblDegreeTypes where dt.Id == -99 select dt).FirstOrDefault(); if (row != null) { // Change values row.Description = "New Description"; int actual = dc.SaveChanges(); Assert.AreNotEqual(0, actual); } } }
public void InsertTest() { using (ProgDecEntities dc = new ProgDecEntities()) { // Make a new degreetype tblDegreeType newrow = new tblDegreeType(); // Set the column values newrow.Id = -99; newrow.Description = "My new shiny degree type"; // Add the row dc.tblDegreeTypes.Add(newrow); // Save the Changes int results = dc.SaveChanges(); Assert.IsTrue(results > 0); } }
public bool Insert() { try { using (ProgDecEntities dc = new ProgDecEntities()) { tblDegreeType degreeType = new tblDegreeType(); degreeType.Id = dc.tblDegreeTypes.Any() ? dc.tblDegreeTypes.Max(p => p.Id) + 1 : 1; // (condition) ? if{} : else{} degreeType.Description = this.Description; dc.tblDegreeTypes.Add(degreeType); dc.SaveChanges(); // returns rows affected return(true); } } catch (Exception ex) { throw ex; } }