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); }
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); }
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); }
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); } }
public int Edit(Entity.Category category) { return(CategoryService.categoryDataAccess.Edit(category)); }
public int Add(Entity.Category category) { return(CategoryService.categoryDataAccess.Add(category)); }
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); }
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)); }