public IEnumerable <Quote> Get()
{
using (QuoteWebAPIEntities entities = new QuoteWebAPIEntities())
{
return(entities.Quotes.ToList());
}
}
public HttpResponseMessage GetTaskById(int id)
{
using (QuoteWebAPIEntities entities = new QuoteWebAPIEntities())
{
var info = entities.Quotes.FirstOrDefault(e => e.QuoteID == id);
if (info != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, info));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "QuoteID = " + id.ToString() + " is not found"));
}
}
}
public HttpResponseMessage Create([FromBody] Quote Quote)
{
try {
using (QuoteWebAPIEntities entities = new QuoteWebAPIEntities())
{
entities.Quotes.Add(Quote);
entities.SaveChanges();
var info = Request.CreateResponse(HttpStatusCode.Created, Quote);
info.Headers.Location = new Uri(Request.RequestUri + "/" + Quote.QuoteID.ToString());
return(info);
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Update(int id, [FromBody] Quote Quote)
{
try
{
using (QuoteWebAPIEntities entities = new QuoteWebAPIEntities())
{
var DBData = entities.Quotes.FirstOrDefault(e => e.QuoteID == id);
//if you want to change the Quote's value
if (DBData != null)
{
DBData.QuoteType = Quote.QuoteType;
DBData.Contact = Quote.Contact;
DBData.Task = Quote.Task;
DBData.DueDate = Quote.DueDate;
DBData.TaskType = Quote.TaskType;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, DBData));
}
//if the Quote values even does not exsit in Quote class
//you need to create it
else
{
entities.Quotes.Add(Quote);
entities.SaveChanges();
var info1 = Request.CreateResponse(HttpStatusCode.Created, Quote);
info1.Headers.Location = new Uri(Request.RequestUri + "/" + Quote.QuoteID.ToString());
return(info1);
}
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (QuoteWebAPIEntities entities = new QuoteWebAPIEntities())
{
var context = entities.Quotes.Find(id);
if (context == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Quote with Id = " + id.ToString() + " is not found"));
}
else
{
entities.Quotes.Remove(context);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
