Ejemplo n.º 1
0
        public static dynamic UpdateFeatured(CategoriesAblums dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "SP_CategoriesAblums",
                                                            new string[] { "@flag", "@Id", "@Featured", "@ModifiedBy" },
                                                            new object[] { "UpdateFeatured", dto.Id, dto.Featured, dto.ModifiedBy });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }
Ejemplo n.º 2
0
        public static dynamic SaveItem(CategoriesAblums dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "SP_CategoriesAblums",
                                                            new string[] { "@flag", "@Id", "@Title", "@Alias", "@Featured", "@Description", "@Images", "@Status", "@CreatedBy", "@ModifiedBy", "@ParentId" },
                                                            new object[] { "SaveItem", dto.Id, dto.Title, dto.Alias, dto.Featured, dto.Description, dto.Images, dto.Status, dto.CreatedBy, dto.ModifiedBy, dto.ParentId });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }