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;
}
