コード例 #1
0
        public HttpResponseMessage updateAccountCashFlow(String id, Models.MstAccountCashFlow accountCashFlow)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                var accountCashFlows = from d in db.MstAccountCashFlows where d.Id == Convert.ToInt32(id) select d;
                if (accountCashFlows.Any())
                {
                    var updateAccountCashFlow = accountCashFlows.FirstOrDefault();
                    updateAccountCashFlow.AccountCashFlowCode = accountCashFlow.AccountCashFlowCode;
                    updateAccountCashFlow.AccountCashFlow     = accountCashFlow.AccountCashFlow;
                    updateAccountCashFlow.IsLocked            = accountCashFlow.IsLocked;
                    updateAccountCashFlow.UpdatedById         = userId;
                    updateAccountCashFlow.UpdatedDateTime     = DateTime.Now;

                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound));
                }
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest));
            }
        }
コード例 #2
0
        public Int32 insertAccountCashFlow(Models.MstAccountCashFlow accountCashFlow)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();

                Data.MstAccountCashFlow newAccountCashFlow = new Data.MstAccountCashFlow();
                newAccountCashFlow.AccountCashFlowCode = accountCashFlow.AccountCashFlowCode;
                newAccountCashFlow.AccountCashFlow     = accountCashFlow.AccountCashFlow;
                newAccountCashFlow.IsLocked            = accountCashFlow.IsLocked;
                newAccountCashFlow.CreatedById         = userId;
                newAccountCashFlow.CreatedDateTime     = DateTime.Now;
                newAccountCashFlow.UpdatedById         = userId;
                newAccountCashFlow.UpdatedDateTime     = DateTime.Now;

                db.MstAccountCashFlows.InsertOnSubmit(newAccountCashFlow);
                db.SubmitChanges();

                return(newAccountCashFlow.Id);
            }
            catch
            {
                return(0);
            }
        }