Esempio n. 1
0
        public Int32 postTableGroup()
        {
            try
            {
                Data.MstTableGroup newTableGroup = new Data.MstTableGroup();
                newTableGroup.TableGroup     = "n/a";
                newTableGroup.EntryUserId    = UserId();
                newTableGroup.EntryDateTime  = DateTime.Today;
                newTableGroup.UpdateUserId   = UserId();
                newTableGroup.UpdateDateTime = DateTime.Today;
                newTableGroup.IsLocked       = false;
                db.MstTableGroups.InsertOnSubmit(newTableGroup);
                db.SubmitChanges();

                return(newTableGroup.Id);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
        public int Post(Models.MstTableGroup tablegroup)
        {
            try
            {
                var isLocked = true;
                var identityUserId = User.Identity.GetUserId();
                var mstUserId = (from d in db.MstUsers where "" + d.Id == identityUserId select d.Id).SingleOrDefault();
                var date = DateTime.Now;

                Data.MstTableGroup newTableGroup = new Data.MstTableGroup();

                //
                newTableGroup.TableGroup = tablegroup.TableGroup;
                newTableGroup.EntryUserId = mstUserId;
                newTableGroup.EntryDateTime = date;
                newTableGroup.UpdateUserId = mstUserId;
                newTableGroup.UpdateDateTime = date;
                newTableGroup.IsLocked = isLocked;
                //

                db.MstTableGroups.InsertOnSubmit(newTableGroup);
                db.SubmitChanges();

                return newTableGroup.Id;
            }
            catch
            {
                return 0;
            }
        }