public HttpResponseMessage AddDelivery(Entities.TrnDelivery objDelivery) { try { Data.IS_TrnDelivery newDelivery = new Data.IS_TrnDelivery { Id = objDelivery.Id, DeliveryNumber = objDelivery.DeliveryNumber, DeliveryDate = Convert.ToDateTime(objDelivery.DeliveryDate), QuotationId = objDelivery.QuotationId, CustomerId = objDelivery.CustomerId, ProductId = objDelivery.ProductId, MeetingDate = Convert.ToDateTime(objDelivery.MeetingDate), Remarks = objDelivery.Remarks, SalesUserId = objDelivery.SalesUserId, TechnicalUserId = objDelivery.TechnicalUserId, FunctionalUserId = objDelivery.FunctionalUserId, DeliveryStatus = objDelivery.DeliveryStatus }; db.IS_TrnDeliveries.InsertOnSubmit(newDelivery); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Added!")); } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!")); } }
public HttpResponseMessage UpdateDelivery(Entities.TrnDelivery objDelivery, String id) { try { var delivery = from d in db.IS_TrnDeliveries where d.Id == Convert.ToInt32(id) select d; if (delivery.Any()) { var updateDelivery = delivery.FirstOrDefault(); updateDelivery.DeliveryNumber = objDelivery.DeliveryNumber; updateDelivery.DeliveryDate = Convert.ToDateTime(objDelivery.DeliveryDate); updateDelivery.QuotationId = objDelivery.QuotationId; updateDelivery.CustomerId = objDelivery.CustomerId; updateDelivery.ProductId = objDelivery.ProductId; updateDelivery.MeetingDate = Convert.ToDateTime(objDelivery.MeetingDate); updateDelivery.Remarks = objDelivery.Remarks; updateDelivery.SalesUserId = objDelivery.SalesUserId; updateDelivery.TechnicalUserId = objDelivery.TechnicalUserId; updateDelivery.FunctionalUserId = objDelivery.FunctionalUserId; updateDelivery.DeliveryStatus = objDelivery.DeliveryStatus; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Updated!")); } else { return(Request.CreateResponse(HttpStatusCode.OK, "Data Not Exist!")); }; } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!")); } }