示例#1
0
文件: Form1.cs 项目: CenturionDi/C-
        //Add
        private void button3_Click(object sender, EventArgs e)
        {
            var             db      = new ChemistryContext();
            IngredientsForm ingForm = new IngredientsForm();



            List <Recipe> recipes = db.Recipes.ToList();

            ingForm.comboBox1.DataSource    = recipes;
            ingForm.comboBox1.ValueMember   = "Id";
            ingForm.comboBox1.DisplayMember = "Name";



            DialogResult result = ingForm.ShowDialog(this);

            //if (result == DialogResult.Cancel)
            //    return;

            Ingredient ingredient = new Ingredient();

            ingredient.Name        = ingForm.textBox1.Text;
            ingredient.Composition = ingForm.textBox2.Text;
            ingredient.Description = ingForm.textBox3.Text;
            ingredient.Amount      = ingForm.textBox4.Text;
            ingredient.Recipe      = (Recipe)ingForm.comboBox1.SelectedItem;

            db.Ingredients.Add(ingredient);
            db.SaveChanges();

            MessageBox.Show("New ingredient added");
        }
示例#2
0
        private void button3_Click(object sender, EventArgs e)
        {
            var db = new ChemistryContext();

            if (dataGridView1.SelectedRows.Count > 0)
            {
                int  index     = dataGridView1.SelectedRows[0].Index;
                int  id        = 0;
                bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
                if (converted == false)
                {
                    return;
                }

                Recipe recipe = db.Recipes.Find(id);

                RecipeForm recForm = new RecipeForm();
                recForm.textBox1.Text = recipe.Name;
                recForm.textBox2.Text = recipe.Description;

                DialogResult result = recForm.ShowDialog(this);


                recipe.Name        = recForm.textBox1.Text;
                recipe.Description = recForm.textBox2.Text;

                db.Entry(recipe).State = EntityState.Modified;
                db.SaveChanges();
                MessageBox.Show("Updated");
            }
        }//Dimash
示例#3
0
文件: Form1.cs 项目: CenturionDi/C-
        private void button5_Click(object sender, EventArgs e)
        {
            var db = new ChemistryContext();

            db.Ingredients.Load();
            dataGridView1.DataSource = db.Ingredients.Local.ToBindingList();
        }
示例#4
0
        public AllRecipes()
        {
            InitializeComponent();
            var db = new ChemistryContext();

            db.Recipes.Load();
            dataGridView1.DataSource = db.Recipes.Local.ToBindingList();
        }
示例#5
0
文件: Form1.cs 项目: CenturionDi/C-
        public Form1()
        {
            InitializeComponent();
            var db = new ChemistryContext();

            db.Ingredients.Load();
            dataGridView1.DataSource = db.Ingredients.Local.ToBindingList();
        }
示例#6
0
        //ADd
        private void button4_Click(object sender, EventArgs e)
        {
            var          db      = new ChemistryContext();
            RecipeForm   recForm = new RecipeForm();
            DialogResult result  = recForm.ShowDialog(this);

            //if (result == DialogResult.Cancel)
            //    return;

            Recipe recipe = new Recipe();

            recipe.Name        = recForm.textBox1.Text;
            recipe.Description = recForm.textBox2.Text;

            db.Recipes.Add(recipe);
            db.SaveChanges();
            MessageBox.Show("New recipe added");
        }
示例#7
0
        private void button1_Click(object sender, EventArgs e)
        {
            var db = new ChemistryContext();

            if (dataGridView1.SelectedRows.Count > 0)
            {
                int  index     = dataGridView1.SelectedRows[0].Index;
                int  id        = 0;
                bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
                if (converted == false)
                {
                    return;
                }

                Recipe recipe = db.Recipes.Find(id);
                listBox1.DataSource    = recipe.Ingredients.ToList();
                listBox1.DisplayMember = "Name";
            }
        }
示例#8
0
文件: Form1.cs 项目: CenturionDi/C-
        //Change
        private void button1_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count > 0)
            {
                var  db        = new ChemistryContext();
                int  index     = dataGridView1.SelectedRows[0].Index;
                int  id        = 0;
                bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
                if (converted == false)
                {
                    return;
                }

                Ingredient ingredient = db.Ingredients.Find(id);

                IngredientsForm ingForm = new IngredientsForm();
                ingredient.Name        = ingForm.textBox1.Text;
                ingredient.Composition = ingForm.textBox2.Text;
                ingredient.Description = ingForm.textBox3.Text;
                ingredient.Amount      = ingForm.textBox4.Text;

                List <Recipe> recipes = db.Recipes.ToList();
                ingForm.comboBox1.DataSource    = recipes;
                ingForm.comboBox1.ValueMember   = "Id";
                ingForm.comboBox1.DisplayMember = "Name";

                DialogResult result = ingForm.ShowDialog(this);

                //if (result == DialogResult.Cancel)
                //    return;

                ingredient.Name        = ingForm.textBox1.Text;
                ingredient.Composition = ingForm.textBox2.Text;
                ingredient.Description = ingForm.textBox3.Text;
                ingredient.Amount      = ingForm.textBox4.Text;
                ingredient.Recipe      = (Recipe)ingForm.comboBox1.SelectedItem;

                db.Entry(ingredient).State = EntityState.Modified;
                db.SaveChanges();

                MessageBox.Show("Объект обновлен");
            }
        }
示例#9
0
文件: Form1.cs 项目: CenturionDi/C-
        //Delete
        private void button2_Click(object sender, EventArgs e)
        {
            var db = new ChemistryContext();

            if (dataGridView1.SelectedRows.Count > 0)
            {
                int  index     = dataGridView1.SelectedRows[0].Index;
                int  id        = 0;
                bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
                if (converted == false)
                {
                    return;
                }

                Ingredient ingredient = db.Ingredients.Find(id);
                db.Ingredients.Remove(ingredient);
                db.SaveChanges();

                MessageBox.Show("Объект удален");
            }
        }