public AddForm(string buttonText, EnumAction buttonAction, Form1 form) : this() { CreateButton.Text = buttonText; MotherForm = form; switch (buttonAction) { case EnumAction.Add: ButtonAction = StandartAction; break; case EnumAction.Update: ButtonAction = EditAction; User target; using (ModelOfShop db = new ModelOfShop()) { target = db.Users.Find(int.Parse(MotherForm.DataBaseGrid[0, MotherForm.DataBaseGrid.SelectedRows[0].Index].Value.ToString())); } NameField.Text = target.FirsName; LastNameField.Text = target.LastName; MiddleNameField.Text = target.MiddleName; LoginField.Text = target.Login; PasswordField.Text = target.Password; CheckAdmin.Checked = (bool)target.IsAdmin; NumberField.Text = target.Phone.ToString(); CountryCodeField.SelectedIndex = (int)target.CountryCode; break; } CheckStats(this, null); }
public static void ItemsTable() { bool is_work = true; while (is_work) { Console.WriteLine("1 - вивести таблицю\n2 - добавити новий запис\n0- вихід"); switch (Console.ReadLine()) { case "0": is_work = false; break; case "1": Console.WriteLine("Items:"); // none string[] rows = Actions.ToStringItems(); foreach (string row in rows) { Console.WriteLine(row); } break; case "2": using (ModelOfShop db = new ModelOfShop()) { Item item = new Item(); Console.WriteLine("Напишіть Id категорії, в яку необхідно додати предмет"); Console.WriteLine("Категорії:"); foreach (Category category in db.Categories) { Console.WriteLine($"[{category.Id}] - {category.Name}"); } db.Categories.Find(int.Parse(Console.ReadLine())).Items.Add(item); Console.WriteLine("Напишіть Id бренда, в якией необхідно додати предмет"); Console.WriteLine("Категорії:"); foreach (Brand brand in db.Brands) { Console.WriteLine($"[{brand.Id}] - {brand.Name}"); } db.Brands.Find(int.Parse(Console.ReadLine())).Items.Add(item); Console.WriteLine("Напишіть імя предмета"); item.Name = ValidateReadLine(50); Console.WriteLine("Напишіть ціну предмета"); item.Price = float.Parse(Console.ReadLine()); db.Items.Add(item); db.SaveChanges(); } break; default: throw new Exception("String is wrong"); } } }
private void Delete_Click(object sender, EventArgs e) { if (DataBaseGrid.SelectedRows.Count == 0) { MessageBox.Show("No selected row!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } using (ModelOfShop db = new ModelOfShop()) { foreach (DataGridViewRow row in DataBaseGrid.SelectedRows) { db.Users.Remove(db.Users.Find(int.Parse(DataBaseGrid[0, row.Index].Value.ToString()))); } db.SaveChanges(); } this.usersTableAdapter.Fill(this.testDataSet.Users); }
public void EditAction() { if (ValidateFields()) { using (ModelOfShop db = new ModelOfShop()) { User target; target = db.Users.Find(int.Parse(MotherForm.DataBaseGrid[0, MotherForm.DataBaseGrid.SelectedRows[0].Index].Value.ToString())); target.FirsName = NameField.Text; target.LastName = LastNameField.Text; target.MiddleName = MiddleNameField.Text; target.Login = LoginField.Text; target.Password = PasswordField.Text; target.IsAdmin = CheckAdmin.Checked; target.Phone = long.Parse(NumberField.Text); target.CountryCode = (short)CountryCodeField.SelectedIndex; db.SaveChanges(); MessageBox.Show("Succesfull", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }