public Order GetByID(int orderID)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
return(ctx.Orders.Where(o => o.OrderID == orderID).FirstOrDefault());
}
}
public User GetByID(int userID)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
return(ctx.Users.Where(u => u.UserID == userID).FirstOrDefault());
}
}
public Cartyp GetCarTypeByID(int CarID)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
return(ctx.Cartyps.Where(c => c.TypeID == CarID).FirstOrDefault());
}
}
public bool Update(Car carToUpdate)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
// option 1: find the employee, update the properties, save cahnges
//var e = ctx.Employees.Find(employeeToUpdate.EmployeeID);
//e.FirstName = employeeToUpdate.FirstName;
//e = employeeToUpdate;
// option 2: -- need to make the ctx as data member
//var e = GetByID(employeeToUpdate.EmployeeID);
//e.FirstName = employeeToUpdate.FirstName;
//e = employeeToUpdate;
// option 3: add the employee to the context
// 1) attach the employee to the context (in the memory)
ctx.Cars.Attach(carToUpdate);
// 2) mark the employee as "need to be updated"
ctx.Entry(carToUpdate).State = System.Data.EntityState.Modified;
// 3) save the changes in the database
int count = ctx.SaveChanges();
return(count > 0);
}
}
public List <Car> GetAll()
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
return(ctx.Cars.Include("Cartyp").Where(c => c.CarID == c.Cartyp.TypeID && c.IsActiv == true || c.Cartyp.IsActiv == true).ToList());
}
}
public List <RolesType> GetRoleForuser(string email)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
return(ctx.RolesTypes.ToList());
}
}
public bool Insert(User newUser)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
ctx.Users.Add(newUser);
int count = ctx.SaveChanges();
return(count > 0);
}
}
public bool Insert(Car newCar, Cartyp newcartype)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
ctx.Cars.Add(newCar);
ctx.Cartyps.Add(newcartype);
int count = ctx.SaveChanges();
return(count > 0);
}
}
public bool Update(User userToUpdate)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
// 1) attach the employee to the context (in the memory)
ctx.Users.Attach(userToUpdate);
// 2) mark the employee as "need to be updated"
ctx.Entry(userToUpdate).State = System.Data.EntityState.Modified;
// 3) save the changes in the database
int count = ctx.SaveChanges();
return(count > 0);
}
}
public bool Delete(Order orderToDelete)
{
using (DB_Car_RentalEntities ctx = new DB_Car_RentalEntities())
{
// 1) attach the employee to the context (in the memory)
ctx.Orders.Attach(orderToDelete);
// 2) mark the employee as "need to be updated"
ctx.Entry(orderToDelete).State = System.Data.EntityState.Modified;
if (orderToDelete.IsActiv == true)
{
orderToDelete.IsActiv = false;
}
// 3) save the changes in the database
int count = ctx.SaveChanges();
return(count > 0);
}
}
public UserManager()
{
ctx = new DB_Car_RentalEntities();
}
public ManufacturerManager()
{
ctx = new DB_Car_RentalEntities();
}
public BranchManager()
{
ctx = new DB_Car_RentalEntities();
}
