示例#1
0
        protected void InsertCategory(object sender, EventArgs e)
        {
            Control control = CategoriesGridView.FooterRow;

            if (control == null)
            {
                control = CategoriesGridView.Controls[0].Controls[0];
            }

            var name = (control.FindControl("CategoryName") as TextBox).Text;

            TodoListEntities db = new TodoListEntities();
            using (db)
            {
                var category = db.Categories.FirstOrDefault(c => c.name == name);

                if (category == null)
                {
                    db.Categories.Add(new Categories()
                    {
                        name = name
                    });

                    db.SaveChanges();
                }
            }
        }
示例#2
0
        protected void InsertTodo(object sender, EventArgs e)
        {
            Control control = DataGridTodos.FooterRow;

            if (control == null)
            {
                control = DataGridTodos.Controls[0].Controls[0];
            }

            var title = (control.FindControl("TodoTitle") as TextBox).Text;
            var categoryName = (control.FindControl("TodoCategory") as TextBox).Text;
            var body = (control.FindControl("TodoBody") as TextBox).Text;

            TodoListEntities db = new TodoListEntities();
            using (db)
            {
                var category = db.Todos.FirstOrDefault(c => c.Categories.name == categoryName);
                var catId = 0;

                if (category == null)
                {
                    db.Categories.Add(new Categories()
                    {
                        name = categoryName
                    });

                    catId = db.Categories.Count();
                }
                else
                {
                    catId = category.id;
                }

                db.Todos.Add(new Models.Todos()
                {
                    title = title,
                    body = body,
                    catId = catId,
                    lastChange = DateTime.Now
                });

                db.SaveChanges();
            }
        }