private void button3_Click(object sender, EventArgs e)
{
FormHome.valform = 0;
fcatclient = new ClientsCatalogue();
fcatclient.ShowDialog();
idcl = ClientsCatalogue.idclient;
if (idcl != 0)
{
mycon.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"SELECT * FROM Clienti WHERE (id = " + idcl + ")";
cmd.Connection = mycon;
OleDbDataReader rd = cmd.ExecuteReader();
rd.Read();
label11.Text = Convert.ToString(rd[2]);
label12.Text = Convert.ToString(rd[3]);
//Grupul
OleDbCommand cmdgr = new OleDbCommand();
cmdgr.CommandType = CommandType.Text;
cmdgr.CommandText = @"SELECT * FROM GrupuriClienti WHERE (id = " + Convert.ToInt32(rd[13]) + ")";
cmdgr.Connection = mycon;
OleDbDataReader rdgr = cmdgr.ExecuteReader();
rdgr.Read();
string gr = Convert.ToString(rdgr[1]);
label13.Text = gr;
rdgr.Close();
rd.Close();
mycon.Close();
}
}
private void button3_Click(object sender, EventArgs e)
{
FormHome.valform = 0;
fcatclient = new ClientsCatalogue();
fcatclient.ShowDialog();
if (ClientsCatalogue.idclient != 0)
{
mycon.Open();
dataGridView1.Rows.Clear();
OleDbCommand cmdidcl = new OleDbCommand();
OleDbCommand cmdidcarte = new OleDbCommand();
cmdidcl.CommandType = CommandType.Text;
cmdidcarte.CommandType = CommandType.Text;
cmdidcl.CommandText = @"SELECT COUNT(*) FROM Imprumuturi WHERE (idClienti = " + ClientsCatalogue.idclient + ")";
cmdidcl.Connection = mycon;
cmdidcarte.Connection = mycon;
int imprumut = Convert.ToInt32(cmdidcl.ExecuteScalar());
if (imprumut != 0)
{
dataGridView1.Rows.Clear();
int idcarte;
cmdidcl.CommandText = @"SELECT * FROM Imprumuturi WHERE (idClienti = " + ClientsCatalogue.idclient + ")";
OleDbDataReader rdcl = cmdidcl.ExecuteReader();
while (rdcl.Read())
{
idcarte = Convert.ToInt32(Convert.ToString(rdcl[1]));
cmdidcarte.CommandText = @"SELECT * FROM Carti WHERE (id = " + idcarte + ")";
OleDbDataReader rdcarte = cmdidcarte.ExecuteReader();
rdcarte.Read();
DataGridViewRow dgvr = new DataGridViewRow();
dgvr.CreateCells(dataGridView1);
dgvr.Cells[0].Value = Convert.ToString(rdcarte[1]);
dgvr.Cells[1].Value = Convert.ToString(rdcarte[3]);
dgvr.Cells[2].Value = Convert.ToString(rdcarte[4]);
rdcarte.Close();
dataGridView1.Rows.Add(dgvr);
}
rdcl.Close();
}
cmdidcl.CommandText = @"SELECT * FROM Clienti WHERE (id = " + ClientsCatalogue.idclient + ")";
OleDbDataReader rdidcl = cmdidcl.ExecuteReader();
rdidcl.Read();
label5.Text = Convert.ToString(rdidcl[2]);
label6.Text = Convert.ToString(rdidcl[3]);
rdidcl.Close();
mycon.Close();
}
else
{
label5.Text = "";
label6.Text = "";
}
}
private void catalogCliențiToolStripMenuItem_Click(object sender, EventArgs e)
{
valform = 1;
fclcatalog = new ClientsCatalogue();
fclcatalog.Show();
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
valform = 1;
fclcatalog = new ClientsCatalogue();
fclcatalog.Show();
}
private void button3_Click(object sender, EventArgs e)
{
fcatclient = new ClientsCatalogue();
fcatclient.Show();
}