//Update button private void Button1_Click(object sender, EventArgs e) { try { bool res = true; //Get values from form MainInformation.Add_ID = _UPDID.Text; MainInformation.Add_Bonus = _UPDBONUS.Text; //Check values if (MainInformation.Add_ID == "" || MainInformation.Add_Bonus == "") { MessageBox.Show("Заполните все поля"); } else { //Check numbers foreach (char c in MainInformation.Add_ID) { if (!Char.IsDigit(c)) { MessageBox.Show("ID: неверный формат"); MainInformation.ResetValues(); res = false; break; } else { foreach (char c1 in MainInformation.Add_Bonus) { if (!Char.IsDigit(c1)) { MessageBox.Show("Скидка: неверный формат"); MainInformation.ResetValues(); res = false; break; } } } } //Success if (res) { this.Close(); } } } catch (Exception) { MessageBox.Show("Ошибка обновления"); } }
// Update button private void Button6_Click(object sender, EventArgs e) { Form ifrm4 = new UpdateForm(); ifrm4.ShowDialog(); if (MainInformation.Add_Bonus != "" && MainInformation.Add_ID != "") { ComplexSQL(@"UPDATE CLIENTS SET BONUS = " + MainInformation.Add_Bonus + " WHERE ID = " + MainInformation.Add_ID + ";", "Запись изменена", false); MainInformation.ResetValues(); } }
//Delete button private void Button5_Click(object sender, EventArgs e) { Form ifrm2 = new FindForm(); ifrm2.ShowDialog(); if (MainInformation.Add_ID != "") { ComplexSQL(@"DELETE FROM CLIENTS WHERE ID = " + MainInformation.Add_ID + ";", "Запись удалена", false); MainInformation.ResetValues(); } }
// select button private void Button4_Click(object sender, EventArgs e) { Form ifrm2 = new FindForm(); label_IDvalue.Text = "-"; label_NAMEvalue.Text = "-"; label_PHONEvalue.Text = "-"; label_BONUS.Text = "%"; ifrm2.ShowDialog(); if (MainInformation.Add_ID != "") { ComplexSQL("", "", true); } MainInformation.ResetValues(); }
//Find/delete button private void Button1_Click(object sender, EventArgs e) { try { bool res = true; MainInformation.Add_ID = _FINDID.Text; //Check value if (MainInformation.Add_ID == "") { MessageBox.Show("Введите ID"); } else { //Check number foreach (char c in MainInformation.Add_ID) { if (!Char.IsDigit(c)) { MessageBox.Show("ID: неверный формат"); MainInformation.ResetValues(); res = false; break; } } //Success if (res) { this.Close(); } } } catch (Exception) { MessageBox.Show("Ошибка поиска"); } }
//Insert button private void Button3_Click(object sender, EventArgs e) { Form ifrm3 = new AddForm(); ifrm3.ShowDialog(); if (MainInformation.Add_ID != "" || MainInformation.Add_Name != "" || MainInformation.Add_Phone != "" || MainInformation.Add_Bonus != "") { try { // query RunSQL(@"INSERT INTO CLIENTS (ID,NAME,PHONE,BONUS) VALUES (" + MainInformation.Add_ID + ", '" + MainInformation.Add_Name + "', '" + MainInformation.Add_Phone + "', " + MainInformation.Add_Bonus + ");"); MessageBox.Show("Запись добавлена"); MainInformation.ResetValues(); } catch (Exception) { MessageBox.Show("Ошибка добавления: ID уже существует"); } } }