public static dynamic DeleteItem(USMenu dto) { DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "User_Menu", new string[] { "@flag", "@Id", "@ModifiedBy" }, new object[] { "DeleteItem", dto.Id, dto.ModifiedBy }); return((from r in tabl.AsEnumerable() select new { N = (int)(r["N"]), }).FirstOrDefault()); }
public static dynamic SaveItem(USMenu dto) { DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "User_Menu", new string[] { "@flag", "@Id", "@Title", "@PathName", "@IdParent", "@Styles", "@Description", "@SortOrder", "@Status", "@CreatedBy", "@CreatedDate", "@ModifiedBy", "@ModifiedDate", "@Deleted" }, new object[] { "SaveItem", dto.Id, dto.Title, dto.PathName, dto.IdParent, dto.Styles, dto.Description, dto.SortOrder, dto.Status, dto.CreatedBy, dto.CreatedDate, dto.ModifiedBy, dto.ModifiedDate, dto.Deleted }); return((from r in tabl.AsEnumerable() select new { N = (int)(r["N"]), }).FirstOrDefault()); }