Beispiel #1
0
        public HttpResponseMessage Post(afs_expense post_afs_expense)
        {
            try
            {
                using (var context = new SAPContext())
                {
                    afs_expense data = new afs_expense();
                    data.EXPENSE_ID     = post_afs_expense.EXPENSE_ID;
                    data.EXPENSE_DESC   = post_afs_expense.EXPENSE_DESC;
                    data.EXPENSE_AMOUNT = post_afs_expense.EXPENSE_AMOUNT;
                    context.afs_expense.Add(data);
                    context.SaveChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK, data));
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        }
Beispiel #2
0
        public HttpResponseMessage Put(afs_expense put_afs_expense)
        {
            try
            {
                using (var context = new SAPContext())
                {
                    var existing = context.afs_expense.Where(t => t.EXPENSE_ID == put_afs_expense.EXPENSE_ID).FirstOrDefault();
                    if (existing == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "afs_expense not found"));
                    }

                    context.afs_expense.Remove(existing);
                    context.afs_expense.Add(put_afs_expense);
                    context.SaveChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK, put_afs_expense));
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        }