public void CreateComponentType(ComponentType componentType) { using (var db = new EsDbContext()) { db.ComponentTypes.Add(componentType); db.SaveChanges(); } }
public void CreateComponent(Component component) { using (var db = new EsDbContext()) { db.Components.Add(component); db.SaveChanges(); } }
public void CreateLoanInformation(LoanInformation loanInformation) { using (var db = new EsDbContext()) { db.LoanInformations.Add(loanInformation); db.SaveChanges(); } }
public void CreateStudent(Student student) { using (var db = new EsDbContext()) { db.Students.Add(student); db.SaveChanges(); } }
public void DeleteLoanInformation(int id) { using (var db = new EsDbContext()) { var loanInformation = db.LoanInformations.Find(id); db.LoanInformations.Remove(loanInformation); db.SaveChanges(); } }
public void DeleteStudent(int id) { using (var db = new EsDbContext()) { var student = db.Students.Find(id); db.Students.Remove(student); db.SaveChanges(); } }
public void DeleteComponentType(int id) { using (var db = new EsDbContext()) { var componentType = db.ComponentTypes.Find(id); db.ComponentTypes.Remove(componentType); db.SaveChanges(); } }
public void Update(EsDbContext context) { var category1 = new Category { CategoryName = "Cameras" }; context.Categories.Add(category1); var comType1 = new ComponentType { ComponentName = "Camera", CategoryId = category1.Id }; context.ComponentTypes.Add(comType1); var com1 = new Component { ComponentNumber = 14, ComponentTypeId = comType1.Id, SerieNr = "983234-EB", UserComment = "Great camera!", AdminComment = "Need to buy more of these", }; context.Components.Add(com1); var student1 = new Student { Email = "*****@*****.**", MobilNo = "88888888", StudentName = "Leasy", StudentId = "201012345", }; context.Students.Add(student1); var loan1 = new LoanInformation { IsReservation = false, LoanDate = DateTime.Now, StudentId = student1.Id, ReservationDate = DateTime.Now, ReturnDate = DateTime.Now.AddMonths(1) }; context.LoanInformations.Add(loan1); context.SaveChanges(); }
public void UpdateStudent(Student student) { using (var db = new EsDbContext()) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateLoanInformation(LoanInformation loanInformation) { using (var db = new EsDbContext()) { db.Entry(loanInformation).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateComponentType(ComponentType componentType) { using (var db = new EsDbContext()) { db.Entry(componentType).State = EntityState.Modified; db.SaveChanges(); } }
public IEnumerable<Student> GetStudents() { using (var db = new EsDbContext()) { return db.Students.ToList(); } }
public Student GetStudent(int? id) { using (var db = new EsDbContext()) { return db.Students.Find(id); } }
public IList<LoanInformation> GetAllLoanInformation() { using (var db = new EsDbContext()) { return db.LoanInformations.Include(c => c.Student).ToList(); } }
public ComponentType GetComponentType(int? id) { using (var db = new EsDbContext()) { return db.ComponentTypes.Find(id); } }
public IEnumerable<Category> GetCategories() { using (var db = new EsDbContext()) { return db.Categories.ToList(); } }
public StatusCodesController(EsDbContext context) { _context = context; }
public IList<Student> GetAllStudents() { using (var db = new EsDbContext()) { return db.Students.ToList(); } }
public CartService(EsDbContext context) { _context = context; }
public SpeciesController(EsDbContext context) { db_context = context; }
public IEnumerable<ComponentType> GetComponentTypes() { using (var db = new EsDbContext()) { return db.ComponentTypes.ToList(); } }
public CartsController(EsDbContext context) { _context = context; }
public LoanInformation GetLoanInformation(int? id) { using (var db = new EsDbContext()) { return db.LoanInformations.Find(id); } }
public IEnumerable<LoanInformation> GetLoanInformations() { using (var db = new EsDbContext()) { return db.LoanInformations.ToList(); } }
public IList<ComponentType> GetAllComponentTypes() { using (var db = new EsDbContext()) { return db.ComponentTypes.Include(c => c.Category).ToList(); } }
public CountryCodesController(EsDbContext context) { _context = context; }