Esempio n. 1
0
        public static dynamic UpdateStatus(USGroups dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "User_Groups",
                                                            new string[] { "@flag", "@Id", "@Status", "@ModifiedBy" },
                                                            new object[] { "UpdateStatus", dto.Id, dto.Status, dto.ModifiedBy });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }
Esempio n. 2
0
        public static dynamic SaveItem(USGroups dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "User_Groups",
                                                            new string[] { "@flag", "@Id", "@Title", "@ListMenuId", "@Status", "@CreatedBy", "@ModifiedBy", "@Deleted" },
                                                            new object[] { "SaveItem", dto.Id, dto.Title, dto.ListMenuId, dto.Status, dto.CreatedBy, dto.ModifiedBy, dto.Deleted });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }
Esempio n. 3
0
 public static dynamic UpdateMenu(USGroups dto)
 {
     return(ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "user_groups",
                                           new string[] { "@flag", "@Id", "@ListMenuId" },
                                           new object[] { "UpdateMenu", dto.Id, dto.ListMenuId }));
 }