private void FormTransfer_FormClosed(object sender, FormClosedEventArgs e)
{
FormClienti fClienti = new FormClienti(banca);
fClienti.Show();
this.Hide();
}
private void FormAdaugareCont_FormClosed(object sender, FormClosedEventArgs e)
{
FormClienti fClienti = new FormClienti(banca);
fClienti.Show();
this.Hide();
}
public void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
var SelectedItem = listView1.SelectedItems[0]; //obiectul selectat
string banca = SelectedItem.Text; // denumirea bancii selectate
FormClienti formOpenClienti = new FormClienti(banca);
formOpenClienti.Show();
this.Hide();
}
private void buttonTransfer_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(comboBoxTransferFrom.Text) || string.IsNullOrWhiteSpace(comboBoxTransferTo.Text))
{
DialogResult result = MessageBox.Show("Selectati conturile!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else if (String.IsNullOrEmpty(textBoxSumaTransfer.Text) || String.IsNullOrWhiteSpace(textBoxSumaTransfer.Text))
{
DialogResult result = MessageBox.Show("Introduceti suma pe care doriti sa o transferati!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else
{
double suma = Convert.ToDouble(textBoxSumaTransfer.Text);
//update db cu sumele calculate dupa transfer
foreach (DataRow dr in bazaDeDateDataSet.ContBancar)
{
if (dr["Numar_Cont"].ToString().Contains("RON"))
{
if (dr["Numar_Cont"].Equals(comboBoxTransferFrom.Text))
{
dr["Suma"] = Convert.ToDouble(dr["suma"].ToString()) - suma;
contBancarTableAdapter.Update(dr);
}
if (dr["Numar_Cont"].Equals(comboBoxTransferTo.Text))
{
dr["Suma"] = Convert.ToDouble(dr["suma"].ToString()) + suma;
contBancarTableAdapter.Update(dr);
}
}
}
tableAdapterManager.UpdateAll(bazaDeDateDataSet);
FormClienti fClienti = new FormClienti(banca);
fClienti.Show();
this.Hide();
}
}
private void buttonAdaugareCont_Click(object sender, EventArgs e)
{
int nrConturi = 0;
nrConturi = MaxConturi(comboBoxClient.Text);
if (String.IsNullOrEmpty(comboBoxClient.Text) || String.IsNullOrWhiteSpace(comboBoxClient.Text))
{
DialogResult result = MessageBox.Show("Selectati clientul!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else if (String.IsNullOrEmpty(comboBoxtipCont.Text) || String.IsNullOrWhiteSpace(comboBoxtipCont.Text))
{
MessageBox.Show("Selectati tipul contului!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (nrConturi < 5)
{
double suma = 0;
if (String.IsNullOrEmpty(textBoxSuma.Text) || String.IsNullOrWhiteSpace(textBoxSuma.Text))
{
suma = 0;
}
else
{
suma = Convert.ToDouble(textBoxSuma.Text);
}
string cont = comboBoxtipCont.Text + Convert.ToString(nrCont);
string client = comboBoxClient.Text;
contBancarTableAdapter.Insert(cont, suma, GetIdClient(client));
tableAdapterManager.UpdateAll(bazaDeDateDataSet);
contBancarTableAdapter.Fill(bazaDeDateDataSet.ContBancar);
FormClienti fClienti = new FormClienti(banca);
fClienti.Show();
this.Hide();
}
else
{
MessageBox.Show("Clientul are deja 5 conturi.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
FormClienti fClienti = new FormClienti(banca);
fClienti.Show();
this.Hide();
}
}
private void buttonAdaugaClient_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(textBoxNume.Text) || String.IsNullOrWhiteSpace(textBoxNume.Text))
{
DialogResult result = MessageBox.Show("Introduceti numele clientului!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else if (String.IsNullOrEmpty(textBoxCnp.Text) || String.IsNullOrWhiteSpace(textBoxCnp.Text) || ValidareCNP(textBoxCnp.Text) == false)
{
DialogResult result = MessageBox.Show("CNP-ul clientului nu este valid!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else if (String.IsNullOrEmpty(textBoxAdresa.Text) || String.IsNullOrWhiteSpace(textBoxAdresa.Text))
{
DialogResult result = MessageBox.Show("Introduceti adresa clientului!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else if (String.IsNullOrEmpty(comboBoxTipCont.Text) || String.IsNullOrWhiteSpace(comboBoxTipCont.Text))
{
DialogResult result = MessageBox.Show("Selectati tipul contului!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
this.Show();
}
}
else
{
double suma = 0;
if (String.IsNullOrEmpty(textBoxSuma.Text) || String.IsNullOrWhiteSpace(textBoxSuma.Text))
{
suma = 0;
}
else
{
suma = Convert.ToDouble(textBoxSuma.Text);;
}
string tipCont = comboBoxTipCont.Text;
string formareCont = tipCont.ToUpper() + contGenerat.ToString();
int maxValue = (int)bazaDeDateDataSet.Client.Compute("MAX([Id_Client])", "");
bazaDeDateDataSet.Client.AddClientRow(maxValue + 1, textBoxCnp.Text, textBoxNume.Text, textBoxAdresa.Text);//adaugare in tabelul client
tableAdapterManager.UpdateAll(bazaDeDateDataSet);
clientTableAdapter.Fill(bazaDeDateDataSet.Client);
//adaugare legaturi in tabelele ContBancar si banca_client
foreach (DataRow dr in bazaDeDateDataSet.Client)
{
if (dr["cnp"].ToString() == textBoxCnp.Text)
{
contBancarTableAdapter1.Insert(formareCont, suma, Convert.ToInt16(dr["Id_client"]));
contBancarTableAdapter1.Fill(bazaDeDateDataSet.ContBancar);
banca_ClientTableAdapter1.Insert(banca, Convert.ToInt16(dr["Id_client"]));
banca_ClientTableAdapter1.Fill(bazaDeDateDataSet.Banca_Client);
tableAdapterManager.UpdateAll(bazaDeDateDataSet);
}
}
this.tableAdapterManager.UpdateAll(this.bazaDeDateDataSet);
FormClienti formClient = new FormClienti(banca);
formClient.Show();
this.Hide();
}
}
