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!"));
            }
        }