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; } }