private void SaveButton_Click(object sender, EventArgs e) { var name = nameTextBox.Text; if (string.IsNullOrWhiteSpace(name)) { nameTextBox.BackColor = Color.IndianRed; } if (!int.TryParse(priceTextBox.Text, out var price)) { priceTextBox.BackColor = Color.IndianRed; } if (!int.TryParse(idTextBox.Text, out var id)) { idTextBox.BackColor = Color.IndianRed; } var note = noteTextBox.Text; var path = pictureBox1.ImageLocation; var tool = new Tool(name, price, id, note, path); var db = new SQLiteClient(); db.Tools.Add(tool); db.SaveChanges(); this.Hide(); }
private void Save1_Click(object sender, EventArgs e) { var name = nameLabel.Text; var surname = surnameLabel.Text; var patronymic = patronymicLabel.Text; var city = cityLabel.Text; var passportStr = passportLabel.Text; if (!CheckInput(name, surname, patronymic, city, passportStr)) { return; } var day = issueDateLabel1.Text; var month = issueDateLabel2.Text; var year = issueDateLabel3.Text; if (!CheckIssueDate(day, month, year)) { return; } var passport = long.Parse(passportStr); var street = streetLabel.Text; var building = buildingLabel.Text; var apartment = apartmentLabel.Text; var homePhone = homePhoneLabel.Text; var officePhone = officePhoneLabel.Text; var cellPhone = cellPhoneLabel.Text; var email = emailLabel.Text; var balance = int.Parse(balanceLabel.Text); var discount = int.Parse(discountLabel.Text); var deposit = checkBox1.Checked; var note = noteTextBox1.Text; var issueDate = day + "-" + month + "-" + year; var whoIssuedPassport = whoIssuedPassportLabel.Text; var residenceAddress = residenceAddressLabel.Text; if (!CheckSex(out var sex)) { return; } var client = new Client(name, surname, patronymic, city, street, building, apartment, sex, passport, issueDate, whoIssuedPassport, residenceAddress, note, discount, balance, deposit, cellPhone, email, officePhone, homePhone); var db = new SQLiteClient(); db.Clients.Add(client); db.SaveChanges(); this.Hide(); }
private void Form1_Load(object sender, EventArgs e) { var db = new SQLiteClient(); db.Clients.Load(); this.dataGridView1.DataSource = db.Clients.Local.ToBindingList(); tool_add.Hide(); tool_edit.Hide(); panel1.Show(); }
private void ИнструментToolStripMenuItem_Click(object sender, EventArgs e) { var db = new SQLiteClient(); db.Tools.Load(); dataGridView1.DataSource = db.Tools.Local.ToBindingList(); addClient.Hide(); editClient.Hide(); tool_add.Show(); tool_edit.Show(); panel1.Show(); }
/// <summary> /// Button for editing client. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_EditClient(object sender, EventArgs e) { var ids = FindSelectedRows().ToList(); var db = new SQLiteClient(); var clients = db.FindClients(ids); var count = db.Clients.Count(); foreach (var client in clients) { var form = new Form2(); form.FillFields(client); form.Show(); if (db.Clients.Count() > count) { db.Clients.Remove(client); } } db.SaveChanges(); }
/// <summary> /// Button for editing tool. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_EditTool(object sender, EventArgs e) { var ids = FindSelectedRows().ToList(); var db = new SQLiteClient(); var tools = db.FindTools(ids); var count = db.Tools.Count(); foreach (var tool in tools) { var form = new Form3(); form.FillFields(tool); form.Show(); if (db.Tools.Count() > count) { db.Tools.Remove(tool); } } db.SaveChanges(); }