コード例 #1
0
        public HttpResponseMessage AddContinuity(Entities.TrnContinuity objContinuity)
        {
            try
            {
                Data.IS_TrnContinuity newContinuity = new Data.IS_TrnContinuity
                {
                    Id = objContinuity.Id,
                    ContinuityNumber = objContinuity.ContinuityNumber,
                    ContinuityDate   = Convert.ToDateTime(objContinuity.ContinuityDate),
                    DeliveryId       = objContinuity.DeliveryId,
                    CustomerId       = objContinuity.CustomerId,
                    ProductId        = objContinuity.ProductId,
                    ExpiryDate       = Convert.ToDateTime(objContinuity.ExpiryDate),
                    Remarks          = objContinuity.Remarks,
                    ContinuityAmount = objContinuity.ContinuityAmount,
                    StaffUserId      = objContinuity.StaffUserId,
                    ContinuityStatus = objContinuity.ContinuityStatus
                };

                db.IS_TrnContinuities.InsertOnSubmit(newContinuity);
                db.SubmitChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, "Successfully Added!"));
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong!"));
            }
        }
コード例 #2
0
        public HttpResponseMessage UpdateContinuity(Entities.TrnContinuity objContinuity, String id)
        {
            try
            {
                var continuity = from d in db.IS_TrnContinuities
                                 where d.Id == Convert.ToInt32(id)
                                 select d;

                if (continuity.Any())
                {
                    var updateContinuity = continuity.FirstOrDefault();
                    updateContinuity.ContinuityNumber = objContinuity.ContinuityNumber;
                    updateContinuity.ContinuityDate   = Convert.ToDateTime(objContinuity.ContinuityDate);
                    updateContinuity.DeliveryId       = objContinuity.DeliveryId;
                    updateContinuity.CustomerId       = objContinuity.CustomerId;
                    updateContinuity.ProductId        = objContinuity.ProductId;
                    updateContinuity.ExpiryDate       = Convert.ToDateTime(objContinuity.ExpiryDate);
                    updateContinuity.Remarks          = objContinuity.Remarks;
                    updateContinuity.ContinuityAmount = objContinuity.ContinuityAmount;
                    updateContinuity.StaffUserId      = objContinuity.StaffUserId;
                    updateContinuity.ContinuityStatus = objContinuity.ContinuityStatus;
                    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!"));
            }
        }