public async Task SaveAsync(Qualification entity)
{
try
{
if (entity == null)
{
return;
}
using (var timeLineContext = _contextFactory.GetTimeLineContext())
{
var entityModel = await timeLineContext
.Qualifications
.FirstOrDefaultAsync(item => item.Id.Equals(entity.Id));
if (entityModel == null)
{
entityModel = new DA.Qualification();
MapForUpdateentity(entity, entityModel);
await timeLineContext.Qualifications.AddAsync(entityModel);
}
else
{
MapForUpdateentity(entity, entityModel);
}
timeLineContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
// DELETE api/qualifications/4
public HttpResponseMessage Delete(int id)
{
var qualification = new Qualification { QualificationId = id };
_db.Qualifications.Attach(qualification);
var status = _db.Qualifications.Remove(qualification);
_db.SaveChanges();
if (status != null) return new HttpResponseMessage(HttpStatusCode.OK);
throw new HttpResponseException(HttpStatusCode.NotFound);
}
//POST api/qualifications
public HttpResponseMessage Post([FromBody] QualificationModel values)
{
var empId=_db.Employees.Where(e=>e.FirstName==values.EmployeeFirstName).Where(e=>e.LastName==values.EmployeeLastName).FirstOrDefault().EmployeeId;
var serviceId=_db.Services.FirstOrDefault(s=>s.ServiceName==values.ServiceName).ServiceId;
var qualification = new Qualification
{
EmployeeId = empId,
ServiceId = serviceId
};
var q = _db.Qualifications.Add(qualification);
_db.SaveChanges();
_db.SaveChanges();
if (q != null)
{
var msg = new HttpResponseMessage(HttpStatusCode.Created);
msg.Headers.Location = new Uri(Request.RequestUri + "/" + qualification.QualificationId.ToString());
return msg;
}
else
{
var msg = new HttpResponseMessage(HttpStatusCode.BadRequest);
return msg;
}
}
private void MapForUpdateentity(Qualification entity, DA.Qualification daEntity)
{
daEntity.Id = entity.Id;
}