public int Create(CategoryView item)
 {
     Entity.Category cate = new Entity.Category()
     {
         id = item.id, name_category = item.name_category, status = item.status
     };
     database.Categories.Add(cate);
     database.SaveChanges();
     return(cate.id);
 }
        public void Setup()
        {
            Repository = new TransactionRepository(Context, new AccountRepository(Context), new CategoryRepository(Context), new SubCategoryRepository(Context), new TransactionTypeRepository(Context));

            var user = new Entity.User()
            {
                FirstName = "test", LastName = "test", Email = "*****@*****.**", Phone = "123-123-1234"
            };

            Context.Users.Add(user);
            Context.SaveChanges();

            var account = new Entity.Account()
            {
                User = user.ID, Name = "test", Description = "test"
            };

            Context.Accounts.Add(account);
            Context.SaveChanges();

            var category = new Entity.Category()
            {
                User = user.ID, Name = "test", Description = "test"
            };

            Context.Categories.Add(category);
            Context.SaveChanges();

            var subCategory = new Entity.SubCategory()
            {
                User = user.ID, Category = category.ID, Name = "test", Description = "test"
            };

            Context.SubCategories.Add(subCategory);
            Context.SaveChanges();

            var type = new Entity.TransactionType()
            {
                Name = "test", Description = "test"
            };

            Context.TransactionTypes.Add(type);
            Context.SaveChanges();

            UserId            = user.ID;
            AccountId         = account.ID;
            CategoryId        = category.ID;
            SubCategoryId     = subCategory.ID;
            TransactionTypeId = type.ID;
        }
        public List <Entity.Category> GetAll()
        {
            string        query  = "SELECT CategoryID, CategoryName FROM Category";
            SqlDataReader reader = DataAccess.GetData(query);

            Entity.Category        category     = null;
            List <Entity.Category> categoryList = new List <Entity.Category>();

            while (reader.Read())
            {
                category = new Entity.Category(reader["CategoryID"].ToString());
                category.CategoryName = reader["CategoryName"].ToString();

                categoryList.Add(category);
            }
            return(categoryList);
        }
Beispiel #4
0
        public async Task <int> CreateCategory(int user, string name, string description)
        {
            var result = 0;

            var entity = new Entity.Category()
            {
                User        = user,
                Name        = name,
                Description = description
            };

            Context.Categories.Add(entity);

            if (await Context.SaveChangesAsync() > 0)
            {
                result = entity.ID;
            }

            return(result);
        }
Beispiel #5
0
        public async Task <bool> Populate(int user)
        {
            var result = false;

            foreach (var i in Categories.Keys)
            {
                var category = new Entity.Category()
                {
                    User        = user,
                    Name        = i,
                    Description = i
                };

                await Context.Categories.AddAsync(category);

                foreach (var j in Categories[i])
                {
                    await Context.SubCategories.AddAsync(new Entity.SubCategory()
                    {
                        User        = user,
                        Category    = category.ID,
                        Name        = j,
                        Description = j
                    });
                }
            }

            foreach (var tag in Tags)
            {
                await Context.Tags.AddAsync(new Entity.Tag()
                {
                    User        = user,
                    Name        = tag,
                    Description = tag
                });
            }

            result = await Context.SaveChangesAsync() > 0;

            return(result);
        }
Beispiel #6
0
        internal static int Save(Entity.Category ent)
        {
            Dictionary <string, object> dic = new Dictionary <string, object>();

            dic["NAME"] = ent.NAME;

            Dictionary <string, object> cond = new Dictionary <string, object>();

            cond["ID"] = ent.ID;
            if (App.DB.Update("Category", dic, cond) == 0)
            {
                App.DB.Insert("Category", dic);
            }

            if (ent.ID == 0)
            {
                return(GetLastID("Category"));
            }
            else
            {
                return(ent.ID);
            }
        }
Beispiel #7
0
 public int Edit(Entity.Category category)
 {
     return(CategoryService.categoryDataAccess.Edit(category));
 }
Beispiel #8
0
 public int Add(Entity.Category category)
 {
     return(CategoryService.categoryDataAccess.Add(category));
 }
Beispiel #9
0
        public JsonResult DoEdit()
        {
            Entity.Category entity = new Entity.Category();
            entity.ParentID = Request["parentid"];
            entity.CategoryID = Request["categoryID"];
            if (entity.ParentID == entity.CategoryID)
            {
                entity.ParentID = "0";
            }
            if (entity.ParentID.Length == entity.CategoryID.Length)
            {
                entity.ParentID = entity.CategoryID.Substring(entity.CategoryID.IndexOf("-"));
            }

            entity.Name = Request["name"];
            entity.Title = Request["title"];
            entity.Count = 0;
            entity.Status = 0;
            entity.IsHot = false;
            entity.CreateDate = DateTime.Now;
            entity.CreateID = this.CurUser.ID;

            ReturnValue retValue = new ReturnValue();
            retValue = this.CategoryMg.AddOrEdit(entity);
            return Json(retValue);
        }
Beispiel #10
0
        private void treeViewCategory_AfterLabelEdit(object sender, NodeLabelEditEventArgs e)
        {
            using (Entity.StoryDBEntities context = new Entity.StoryDBEntities(ConnectionString))
            {
                e.CancelEdit = true;
                try
                {
                    if (!string.IsNullOrWhiteSpace(e.Label))
                    {
                        int catId = (int)e.Node.Tag;

                        int parentCatId = 0;
                        if (e.Node.Parent != null)
                        {
                            parentCatId = (int)e.Node.Parent.Tag;
                        }

                        if (catId <= 0)
                        {
                            Entity.Category cat = new Entity.Category()
                            {
                                ParentCategoryId = parentCatId,
                                CategoryName = e.Label,
                                CreateBy = UpdateSourceName,
                                CreateDate = DateTime.UtcNow,
                                UpdateBy = UpdateSourceName,
                                UpdateDate = DateTime.UtcNow,
                            };

                            context.Categories.AddObject(cat);
                            try
                            {
                                context.SaveChanges();
                                e.CancelEdit = false;
                            }
                            catch (Exception x)
                            {
                                MessageBox.Show(x.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            }
                        }
                        else
                        {
                            Entity.Category cat = (
                                from c in context.Categories
                                where c.CategoryId == catId
                                select c).SingleOrDefault();
                            cat.CategoryName = e.Label;
                            cat.UpdateBy = UpdateSourceName;
                            cat.UpdateDate = DateTime.UtcNow;
                            context.SaveChanges();
                            e.CancelEdit = false;
                        }
                    }
                }
                finally
                {
                    if (e.CancelEdit)
                        e.Node.BeginEdit();
                }
            }
        }
        private bool DoAdd()
        {
            try
            {
                BLL.CategoryBll bll = new BLL.CategoryBll();
                Entity.Category model = new Entity.Category();

                model.ChannelID = this.channel_id;
                model.Title = txtTitle1.Text.Trim();
                //model. = int.Parse(ddlParentId.SelectedValue);
                model.SortID = int.Parse(txtSortId1.Text.Trim());

                //model. = txtLinkUrl.Text.Trim();
                //model.img_url = txtImgUrl.Text.Trim();
                //model.content = txtContent.Value;
                if (bll.Add(model) < 1)
                {
                    return false;
                }
            }
            catch
            {
                return false;
            }
            return true;
        }
        public int Edit(Entity.Category category)
        {
            string query = "UPDATE Category SET CategoryName='" + category.CategoryName + "' WHERE CategoryID=" + category.CategoryID;

            return(DataAccess.ExecuteQuery(query));
        }
        public int Add(Entity.Category category)
        {
            string query = string.Format("INSERT INTO Category(CategoryID, CategoryName) VALUES('{0}', '{1}')", category.CategoryID, category.CategoryName);

            return(DataAccess.ExecuteQuery(query));
        }