private void button1_Click_1(object sender, EventArgs e) { if (seq.Text == "" || description.Text == "" || status.Text == "" || startdate.Text == "" || idreq.Text == "" || type.Text == "") { MessageBox.Show("Pozostawiono puste pola"); } else { int convert = Int32.Parse(idreq.Text); DateTime dDate; if (DateTime.TryParse(startdate.Text, out dDate)) { String.Format("dd/MM/yyyy HH:mm", dDate); DateTime start = DateTime.Parse(startdate.Text); ManagerSection.Create_Activity(seq.Text, description.Text, status.Text, start, convert, type.Text); MessageBox.Show("Dodano czynność"); this.Close(); } else { MessageBox.Show("Zły format daty"); } } }
private void button1_Click(object sender, EventArgs e) { if (worker.Text != "" && worker.Text != "0") { ManagerSection.Edit_Activity(activity.Text, worker.Text); } this.Close(); }
private void GetData() { dataGridView1.DataSource = ManagerSection.Get_Data(); dataGridView1.Update(); dataGridView1.Refresh(); // string drugie_id = dataGridView1.Rows[dataGridView1.RowCount-1].Cells[0].Value.ToString(); // int id = Int32.Parse(drugie_id)+1; textBox2.Text = "?";//id.ToString(); }
private void button1_Click(object sender, EventArgs e) { //try // string SQLConn = "Data Source=DESKTOP-7C6VI2V;Initial Catalog=projektDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False"; //DataClasses1DataContext idreq = new DataClasses1DataContext(SQLConn); DialogResult result1 = MessageBox.Show("Czy na pewno chcesz dodać rekord", "Potwierdzenie", MessageBoxButtons.YesNo); if (result1 == DialogResult.Yes) { if (textBox3.Text == "" || textBox4.Text == "") { MessageBox.Show("Nie uzupełniono wymaganych pól"); label9.ForeColor = Color.Black; if (textBox3.Text == "") { //MessageBox.Show("Pozostawiono puste pole"); if (textBox3.Text == "") { label9.ForeColor = Color.Red; } } label8.ForeColor = Color.Black; if (textBox4.Text == "") { //MessageBox.Show("Pozostawiono puste pole"); if (textBox4.Text == "") { label8.ForeColor = Color.Red; } } } else { //int id_request = Int32.Parse(textBox2.Text); int id_klient = System.Int32.Parse(textBox3.Text); int id_obiektu = System.Int32.Parse(textBox4.Text); //string box3 = comboBox3.SelectedValue.ToString(); string box2 = comboBox2.SelectedValue.ToString(); ManagerSection.RequestADD(richTextBox1.Text, richTextBox2.Text, box2, DateTime.Now, id_obiektu, id_klient); label3.ForeColor = Color.Black; label9.ForeColor = Color.Black; label8.ForeColor = Color.Black; GetData(); refresh(); menu(); MessageBox.Show("Dodano"); } } }
private void button2_Click(object sender, EventArgs e) { string imie = textBox1.Text; dataGridView1.DataSource = ManagerSection.Szukaj_2(imie); dataGridView1.Update(); dataGridView1.Refresh(); if (textBox1.Text == "") { GetData(); } }
private void button3_Click(object sender, EventArgs e) { DialogResult result1 = MessageBox.Show("Czy na pewno chcesz zaktualizować?", "Potwierdzenie", MessageBoxButtons.YesNo); if (result1 == DialogResult.Yes) { if (textBox3.Text == "" || textBox4.Text == "") { MessageBox.Show("Nie uzupełniono wymaganych pól"); label9.ForeColor = Color.Black; if (textBox3.Text == "") { //MessageBox.Show("Pozostawiono puste pole"); if (textBox3.Text == "") { label9.ForeColor = Color.Red; } } label8.ForeColor = Color.Black; if (textBox4.Text == "") { //MessageBox.Show("Pozostawiono puste pole"); if (textBox4.Text == "") { label8.ForeColor = Color.Red; } } } else { int id_request = Int32.Parse(textBox2.Text); int id_klient = System.Int32.Parse(textBox3.Text); int id_obiektu = System.Int32.Parse(textBox4.Text); //string box3 = comboBox3.SelectedValue.ToString(); string box2 = comboBox2.SelectedValue.ToString(); ManagerSection.RequestEDIT(id_request, richTextBox1.Text, richTextBox2.Text, box2, id_obiektu, id_klient, DateTime.Now); label3.ForeColor = Color.Black; label9.ForeColor = Color.Black; label8.ForeColor = Color.Black; GetData(); refresh(); menu(); MessageBox.Show("Zaktualizowano"); } } }
private void button1_Click(object sender, EventArgs e) { if (code.Text == "" || describe.Text == "") { MessageBox.Show("Pozostawiono puste pola"); } else { ManagerSection.Create_ActivityType(code.Text, describe.Text); MessageBox.Show("Dodano nowy rodzaj czynności"); this.Close(); } }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "") { GetData(); } else { int numer_wiersza = Int32.Parse(textBox1.Text); dataGridView1.DataSource = ManagerSection.Szukaj_1(numer_wiersza); dataGridView1.Update(); dataGridView1.Refresh(); } }
private void button4_Click(object sender, EventArgs e) { try { string currIndex = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value.ToString(); EditClient nw = new EditClient(currIndex); nw.ShowDialog(); } catch { MessageBox.Show("Proszę wybrać klienta"); } dataGridView2.DataSource = (from a in ManagerSection.Find_user(idszukaj.Text, companyszukaj.Text, nameszukaj.Text, lnameszukaj.Text) select new { ID_Klienta = a.id_cli, Nazwa_firmy = a.name, Imię = a.fname, Nazwisko = a.lname, Telefon = a.tel, Ulica = a.street_name, Kod_pocztowy = a.post_code, Numer_domu = a.number }); }
private void button1_Click(object sender, EventArgs e) { if (Tel.Text == "" || StreetName.Text == "" || Post.Text == "" || Number.Text == "") { MessageBox.Show("Pozostawiono puste pola"); } else if ((Fname.Text == "" || Lname.Text == "") && CName.Text == "") { MessageBox.Show("Pozostawiono puste pola"); } else { ManagerSection.Create_Client(Fname.Text, Lname.Text, Tel.Text, StreetName.Text, Post.Text, Number.Text, CName.Text); MessageBox.Show("Dodano klienta"); this.Close(); } }
private void szukaj_Click(object sender, EventArgs e) { dataGridView2.DataSource = (from a in ManagerSection.Find_user(idszukaj.Text, companyszukaj.Text, nameszukaj.Text, lnameszukaj.Text) select new { ID_Klienta = a.id_cli, Nazwa_firmy = a.name, Imię = a.fname, Nazwisko = a.lname, Telefon = a.tel, Ulica = a.street_name, Kod_pocztowy = a.post_code, Numer_domu = a.number }); }
private void GetData() { dataGridView1.DataSource = ManagerSection.Get_Data3(); dataGridView1.Update(); dataGridView1.Refresh(); }
private void Button2_Click(object sender, EventArgs e) { ManagerSection.Edit_Client(name.Text, fname.Text, lname.Text, tel.Text, street.Text, postcode.Text, number.Text, edit.Text); this.Close(); }