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