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