public List <dynamic> createRequest(int custID, int designID, int sizeID, string color, int webID, string prodCode, int quantity)
{
db.Configuration.ProxyCreationEnabled = false;
List <dynamic> list = new List <dynamic>();
Quotation_Request request = new Quotation_Request();
request.Customer_ID = custID;
request.Date = DateTime.Now;
db.Quotation_Request.Add(request);
db.SaveChanges();
list.Add(request);
if (request != null)
{
Quotation_Request_Line quotation_Request_Line = new Quotation_Request_Line();
quotation_Request_Line.Request_ID = request.Request_ID;
quotation_Request_Line.Design_ID = designID;
quotation_Request_Line.Product_Size_ID = sizeID;
quotation_Request_Line.Colour = color;
quotation_Request_Line.Web_Link_ID = webID;
quotation_Request_Line.Product_Code = prodCode;
quotation_Request_Line.Quantity = quantity;
db.Quotation_Request_Line.Add(quotation_Request_Line);
db.SaveChanges();
list.Add(quotation_Request_Line);
}
return(list);
}
public IHttpActionResult DeleteQuotation_Request(int id)
{
Quotation_Request quotation_Request = db.Quotation_Request.Find(id);
if (quotation_Request == null)
{
return(NotFound());
}
db.Quotation_Request.Remove(quotation_Request);
db.SaveChanges();
return(Ok(quotation_Request));
}
public IHttpActionResult PutQuotation_Request(Quotation_Request quotation_Request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(quotation_Request).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
throw;
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostQuotation_Request(Quotation_Request quotation_Request)
{
try
{
//Request table
db.Quotation_Request.Add(quotation_Request);
//RequestLine table
foreach (var item in quotation_Request.Quotation_Request_Line)
{
db.Quotation_Request_Line.Add(item);
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
throw ex;
}
}
