private void btnSave_Click(object sender, EventArgs e) { string name = tabControl1.SelectedTab.Text; connection con = new connection(); switch (name) { case "Сотрудник": con.update("Сотрудник", "[Фамилия] = '" + F.Text + "', [Имя] ='" + I.Text + "', [Отчество] ='" + O.Text + "', [Дата рождения] ='" + BirthDate.Text + "', [Адрес] ='" + Adress.Text + "', [Телефон] ='" + PhoneStaff.Text + "', [E-mail] ='" + emailstaff.Text + "', [Образование] ='" + Education.Text + "', [Должность] ='" + Occupation.Text + "'", "[ID сотрудника] = " + ID_s); break; case "Покупатели": con.update("Покупатели", "[Фамилия] = '" + FP.Text + "', [Имя] ='" + IP.Text + "', [Отчество] ='" + OP.Text + "', [Мобильный телефон] ='" + PhoneP.Text + "', [Город] ='" + CityP.Text + "', [Адрес] ='" + AdressP.Text + "'", "[ID покупателя] = " + ID_p); break; case "Товары": con.update("Товары", "[Наименование] = '" + ChtoG.Text + "', [Название] ='" + NameG.Text + "', [Описание] ='" + CommentG.Text + "', [Цена] =" + PriceG.Text + "", "[ID Товара] = " + ID_g); break; case "Услуги": con.update("Услуги", "[Наименование услуги] = '" + NameS.Text + "', [Описание] ='" + CommentS.Text + "', [Цена] =" + PriceS.Text + "", "[ID Услуги] = " + ID_u); break; case "Заказы": string IDP, IDS; IDS = con.select1String("[ID сотрудника]", "Сотрудник", "Фамилия LIKE '" + cbS.Text + "'"); IDP = con.select1String("[ID покупателя]", "Покупатели", "Фамилия LIKE '" + cbP.Text + "'"); con.update("Заказы", "[Дата заказа] = '" + DateN.Text + "', [id Сотрудника] =" + IDS + ", [id Покупателя] =" + IDP + ", [Отметка об исполнении] =" + CheckBox.Text + ", [Предоплата] =" + Preorder.Text+ "", "[ID Заказа] = " + ID_N); break; case "Заказанные товары": string[] wordsG = cbG.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); con.update("[Заказанные товары]", "[ID заказа] = " + cbIDN.Text + ", [ID товара] =" + wordsG[0] + ", [Количество] =" + CountPG.Text + ", [Цена] =" + PricePG.Text + ", [Общая стоимость] =" + TotalPricsPG.Text + "", "[ID ЗТ] = " + ID_NG); break; case "Заказанные услуги": string[] wordsU = cbU.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); con.update("[Заказанные услуги]", "[ID заказа] = " + cbIDNU.Text + ", [ID услуги] =" + wordsU[0] + ", [Количество] =" + CountNS.Text + ", [Цена] =" + PriceNS.Text + ", [Общая стоимость] =" + TotalPriceNS.Text + "", "[ID ЗУ] = " + ID_NU); break; } con.Close(); ClearAll(); UpdateAll(); }
private void buttonEDIT_Click(object sender, EventArgs e) { btnSave.Visible = true; buttonADD.Visible = false; buttonEDIT.Visible = false; buttonDELETE.Visible = false; string name = tabControl1.SelectedTab.Text; connection con = new connection(); SqlDataReader myReader; switch (name) { case "Сотрудник": ID_s = (int) dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value; myReader = con.select("*", "Сотрудник", "[ID сотрудника] = " + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value); while (myReader.Read()) { F.Text = myReader[1].ToString(); I.Text = myReader[2].ToString(); O.Text = myReader[3].ToString(); BirthDate.Text = myReader[4].ToString(); Adress.Text = myReader[5].ToString(); PhoneStaff.Text = myReader[6].ToString(); emailstaff.Text = myReader[7].ToString(); Education.Text = myReader[8].ToString(); Occupation.Text = myReader[9].ToString(); } myReader.Close(); break; case "Покупатели": ID_p = (int)dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value; myReader = con.select("*", "Покупатели", "[ID покупателя] = " + dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value); while (myReader.Read()) { FP.Text = myReader[1].ToString(); IP.Text = myReader[2].ToString(); OP.Text = myReader[3].ToString(); PhoneP.Text = myReader[4].ToString(); CityP.Text = myReader[5].ToString(); AdressP.Text = myReader[6].ToString(); } myReader.Close(); break; case "Товары": ID_g = (int)dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[0].Value; myReader = con.select("*", "Товары", "[ID Товара] = " + dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[0].Value); while (myReader.Read()) { ChtoG.Text = myReader[1].ToString(); NameG.Text = myReader[2].ToString(); CommentG.Text = myReader[3].ToString(); PriceG.Text = myReader[4].ToString(); } myReader.Close(); break; case "Услуги": ID_u = (int)dataGridView4.Rows[dataGridView4.CurrentRow.Index].Cells[0].Value; myReader = con.select("*", "Услуги", "[ID Услуги] = " + dataGridView4.Rows[dataGridView4.CurrentRow.Index].Cells[0].Value); while (myReader.Read()) { NameS.Text = myReader[1].ToString(); CommentS.Text = myReader[2].ToString(); PriceS.Text = myReader[3].ToString(); } myReader.Close(); break; case "Заказы": ID_N = (int)dataGridView5.Rows[dataGridView5.CurrentRow.Index].Cells[0].Value; string IDP = "1", IDS="1"; myReader = con.select("*", "Заказы", "[ID Заказа] = " + dataGridView5.Rows[dataGridView5.CurrentRow.Index].Cells[0].Value); while (myReader.Read()) { DateN.Text = myReader[1].ToString(); IDS = myReader[2].ToString(); IDP = myReader[3].ToString(); CheckBox.Text = myReader[4].ToString(); Preorder.Text = myReader[5].ToString(); } cbS.Text=dataGridView1.Rows[Convert.ToInt32(IDS) - 1].Cells[1].Value.ToString(); cbP.Text=dataGridView2.Rows[Convert.ToInt32(IDP) - 1].Cells[1].Value.ToString(); myReader.Close(); break; case "Заказанные товары": ID_NG = (int)dataGridView6.Rows[dataGridView6.CurrentRow.Index].Cells[0].Value; string IDG="1"; myReader = con.select("*", "[Заказанные товары]", "[ID ЗТ] = " + ID_NG); while (myReader.Read()) { cbIDN.Text = myReader[1].ToString(); IDG = myReader[2].ToString(); CountPG.Text = myReader[3].ToString(); PricePG.Text = myReader[4].ToString(); TotalPricsPG.Text = myReader[5].ToString(); } cbG.Text = dataGridView3.Rows[Convert.ToInt32(IDG) - 1].Cells[0].Value.ToString() + " " + dataGridView3.Rows[Convert.ToInt32(IDG) - 1].Cells[1].Value.ToString() + " " + dataGridView3.Rows[Convert.ToInt32(IDG) - 1].Cells[2].Value.ToString(); myReader.Close(); break; case "Заказанные услуги": ID_NU = (int)dataGridView6.Rows[dataGridView7.CurrentRow.Index].Cells[0].Value; string IDU = "1"; myReader = con.select("*", "[Заказанные услуги]", "[ID ЗУ] = " +ID_NU); while (myReader.Read()) { cbIDNU.Text = myReader[1].ToString(); IDU = myReader[2].ToString(); CountNS.Text = myReader[3].ToString(); PriceNS.Text = myReader[4].ToString(); TotalPriceNS.Text = myReader[5].ToString(); } cbU.Text = dataGridView4.Rows[Convert.ToInt32(IDU) - 1].Cells[0].Value.ToString() + " " + dataGridView4.Rows[Convert.ToInt32(IDU) - 1].Cells[1].Value.ToString() + " " + dataGridView4.Rows[Convert.ToInt32(IDU) - 1].Cells[2].Value.ToString(); myReader.Close(); break; } con.Close(); }
private void buttonDELETE_Click(object sender, EventArgs e) { string pole=""; string id_number=""; string name = tabControl1.SelectedTab.Text; switch (name) { case "Сотрудник": pole = "ID сотрудника"; id_number= dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Покупатели": pole = "ID покупателя"; id_number = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Товары": pole = "ID товара"; id_number = dataGridView3.Rows[dataGridView3.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Услуги": pole = "ID услуги"; id_number = dataGridView4.Rows[dataGridView4.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Заказы": pole = "ID заказа"; id_number = dataGridView5.Rows[dataGridView5.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Заказанные товары": pole = "ID ЗТ"; id_number = dataGridView6.Rows[dataGridView6.CurrentRow.Index].Cells[0].Value.ToString(); break; case "Заказанные услуги": pole = "ID ЗУ"; id_number = dataGridView7.Rows[dataGridView7.CurrentRow.Index].Cells[0].Value.ToString(); break; } connection conDel = new connection(); conDel.delete("["+name+"]", "["+pole+"]", id_number); UpdateAll(); }