public virtual void Insert(T entity)
{
try
{
if (entity == null)
{
throw new ArgumentNullException("entity");
}
Entities.Add(entity);
if (Context == null || _isDisposed)
{
Context = new EmployeeDBModel();
}
//Context.SaveChanges(); commented out call to SaveChanges as Context save changes will be
//called with Unit of work
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
_errorMessage += string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage) + Environment.NewLine;
}
}
throw new Exception(_errorMessage, dbEx);
}
}
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (EmployeeDBModel entities = new EmployeeDBModel())
{
var entity = entities.Employees.FirstOrDefault(x => x.ID == id);
if (entity == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee With ID= " + id.ToString() + " Not Found.."));
}
else
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, employee));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDBModel entities = new EmployeeDBModel())
{
var entity = entities.Employees.SingleOrDefault(x => x.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee With ID = " + id.ToString() + " Doesn't Exist.."));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Employee With ID = " + id.ToString() + " Deleted Successfully"));
}
}
}
catch (Exception ex)
{
var message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
return(message);
}
}
public IEnumerable <Employee> Get()
{
using (EmployeeDBModel entities = new EmployeeDBModel())
{
return(entities.Employees.ToList());
}
}
public HttpResponseMessage Post([FromBody] Employee employee)
{
try
{
using (EmployeeDBModel entities = new EmployeeDBModel())
{
entities.Employees.Add(employee);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, employee);
message.Headers.Location = new Uri(Request.RequestUri + "/" + employee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
var message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
return(message);
}
}
public HttpResponseMessage Get(int id)
{
try
{
using (EmployeeDBModel entities = new EmployeeDBModel())
{
var entity = entities.Employees.Where(x => x.ID == id).FirstOrDefault();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id =" + id.ToString() + " was not found."));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public GenericRepository(EmployeeDBModel context)
{
_isDisposed = false;
Context = context;
}
public EmployeeRepository(EmployeeDBModel context)
: base(context)
{
}
