public DepartmentModel GetById(int id)
{
using (var db = new ListerHaighEntites())
{
var department = db.Departments.FirstOrDefault(x => x.DepartmentId == id);
return(Mapper.Map(department, new DepartmentModel()));
}
}
public DepartmentModel GetByName(string name)
{
using (var db = new ListerHaighEntites())
{
var department = db.Departments.FirstOrDefault(x => x.Name.Trim() == name.Trim());
return(Mapper.Map(department, new DepartmentModel()));
}
}
public IEnumerable <DepartmentModel> GetAll()
{
using (var db = new ListerHaighEntites())
{
var departments = db.Departments.ToList();
return(departments.Select(Mapper.Map <DepartmentModel>).ToList());
}
}
public EventModel GetById(int id)
{
using (var db = new ListerHaighEntites())
{
var objEvent = db.Events.Where(x => x.EventId == id);
return(Mapper.Map(objEvent, new EventModel()));
}
}
public bool Update(DepartmentModel entity)
{
using (var db = new ListerHaighEntites())
{
var department = db.Departments.SingleOrDefault(x => x.DepartmentId == entity.DepartmentId);
department = Mapper.Map(entity, department);
db.Entry <Department>(department).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
public bool Delete(DepartmentModel entity)
{
bool result = false;
using (var db = new ListerHaighEntites())
{
var department = db.Departments.FirstOrDefault(x => x.DepartmentId == entity.DepartmentId);
db.Entry <Department>(department).State = EntityState.Deleted;
result = (db.SaveChanges() > 0 ? false : true);
}
return(result);
}
public bool Add(DepartmentModel entity)
{
try
{
using (var db = new ListerHaighEntites())
{
var department = Mapper.Map <Department>(entity);
db.Departments.Add(department);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw new Exception("There is error saving department", ex);
}
}
public RepositoryBase(ListerHaighEntites context)
{
this.DataContext = context;
}
