Пример #1
0
        public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Deca_Company> items)
        {
            if (asset.Create)
            {
                if (items != null && ModelState.IsValid)
                {
                    using (var dbConn = Helpers.OrmliteConnection.openConn())
                    {
                        foreach (var item in items)
                        {
                            using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
                            {
                                try
                                {
                                    item.IsNew     = true;
                                    item.CreatedAt = DateTime.Now;
                                    item.CreatedBy = User.Identity.Name;
                                    dbConn.Insert(item);
                                    int Id = (int)dbConn.GetLastInsertId();
                                    item.Id        = Id;
                                    item.CompanyID = "C" + DateTime.Now.ToString("yyMMdd") + Id;
                                    //item.CompanyID = "C" + DateTime.Now.ToString("yyMMdd") + string.Format("{0:000}", Id);
                                    dbConn.Update(item);

                                    var log = new Deca_Company_Log();
                                    log.CompanyID = item.CompanyID;
                                    log.Log       = item;
                                    log.CreatedAt = DateTime.Now;
                                    log.CreatedBy = currentUser.UserName;
                                    dbConn.Insert(log);

                                    dbTrans.Commit();
                                }
                                catch (Exception ex)
                                {
                                    ModelState.AddModelError("", ex.Message);
                                    return(Json(items.ToDataSourceResult(request, ModelState)));
                                }
                            }
                        }
                    }
                }
            }
            else
            {
                ModelState.AddModelError("", "Don't have permission");
            }

            return(Json(items.ToDataSourceResult(request, ModelState)));
        }
Пример #2
0
        public ActionResult Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Deca_Company> items)
        {
            if (asset.Update)
            {
                if (items != null && ModelState.IsValid)
                {
                    using (var dbConn = Helpers.OrmliteConnection.openConn())
                    {
                        foreach (var item in items)
                        {
                            using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
                            {
                                item.IsNew     = true;
                                item.UpdatedAt = DateTime.Now;
                                item.UpdatedBy = User.Identity.Name;
                                dbConn.Update(item);

                                var log = new Deca_Company_Log();
                                log.CompanyID = item.CompanyID;
                                log.Log       = item;
                                log.CreatedAt = DateTime.Now;
                                log.CreatedBy = currentUser.UserName;
                                dbConn.Insert(log);
                                dbTrans.Commit();
                            }
                        }
                    }
                }
            }
            else
            {
                ModelState.AddModelError("", "Don't have permission");
            }

            return(Json(items.ToDataSourceResult(request, ModelState)));
        }