public Funnel DeleteFunnel(int id)
{
Funnel funnel = db.Funnel.Find(id);
if (funnel == null)
{
_loggerService.CreateLog("Jordan", "Funnel", "Delete", string.Empty, $"Funnel {id} not found to delete.");
return(null);
}
try
{
db.Funnel.Remove(funnel);
db.SaveChanges();
_loggerService.CreateLog("Jordan", "Funnel", "Delete", funnel.ToString());
}
catch (Exception e)
{
_loggerService.CreateLog("Jordan", "Funnel", "Delete", funnel.ToString(), "Error deleting Funnel: " + e.Message);
return(null);
}
return(funnel);
}
public Funnel InsertFunnel(Funnel funnel)
{
try
{
funnel.CreatedDateTime = DateTime.Now;
db.Funnel.Add(funnel);
db.SaveChanges();
_loggerService.CreateLog("Jordan", "Funnel", "Create", funnel.ToString());
return(funnel);
}
catch (Exception e)
{
_loggerService.CreateLog("Jordan", "Funnel", "Create", funnel.ToString(), "Error creating this record: " + e.Message);
return(null);
}
}
public IHttpActionResult Update(int id, Funnel funnel)
{
_loggerService.CreateLog(_user, "API", "FunnelController", "Funnel", "Update", funnel.ToString(), null);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != funnel.Id)
{
return(BadRequest("The Id's do not match"));
}
var updatedFunnel = _funnelRepository.UpdateFunnel(funnel);
if (updatedFunnel == null)
{
return(BadRequest("There was a problem updating your record. Please try again"));
}
return(Ok($"api/funnel?id={funnel.Id}"));
}
public IHttpActionResult Insert(Funnel funnel)
{
_loggerService.CreateLog(_user, "API", "FunnelController", "Funnel", "Insert", funnel.ToString(), null);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var createdFunnel = _funnelRepository.InsertFunnel(funnel);
if (createdFunnel == null)
{
BadRequest("There was a problem inserting your record. Please try again.");
}
return(Created($"api/funnel?id={createdFunnel.Id}", createdFunnel));
}
