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();
}
