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; } }