private void button3_Click(object sender, EventArgs e)
{//string sql = "update clientdetails set name ='" + comboBox1.Text + "',addr ='" + textBox3.Text + "',phno ='" + textBox4.Text + "',email ='" + textBox5.Text + "',tob ='" + textBox6.Text + "',camt ='" + textBox7.Text + "',date ='" +dateTimePicker1.Text + "',period ='" + textBox8.Text + "' where slno ='" + textBox1.Text + "'";
int k = 0;
string sql;
if (textBox2.Text.Length > 0 && textBox3.Text.Length > 0 && comboBox2.Text.Length > 0 && comboBox3.Text.Length > 0 && textBox7.Text.Length > 0)
{
if (radioButton2.Checked == true)
{
if (textBox1.Text.Length == 0 && textBox8.Text.Length == 0 && textBox9.Text.Length == 0)
{
k = 1;
}
sql = "update addindetails set date ='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "',name ='" + textBox3.Text + "',inacc ='" + comboBox2.Text + "',inhd ='" + comboBox3.Text + "',des ='" + textBox6.Text + "',amnt ='" + textBox7.Text + "',bnkname ='" + textBox8.Text + "',chqno ='" + textBox9.Text + "',chqdt ='" + textBox1.Text + "',mthd ='CHECK' where id ='" + row.Cells[0].Value.ToString() + "'";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), textBox3.Text, textBox7.Text, "CHECK", textBox9.Text, textBox1.Text, textBox8.Text, };
}
else if (radioButton3.Checked == true)
{
if (textBox4.Text.Length == 0)
{
k = 1;
}
sql = "update addindetails set date ='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "',name ='" + textBox3.Text + "',inacc ='" + comboBox2.Text + "',inhd ='" + comboBox3.Text + "',des ='" + textBox6.Text + "',amnt ='" + textBox7.Text + "',bnkname ='" + textBox4.Text + "',mthd ='BANK TRANSFER' where id ='" + row.Cells[0].Value.ToString() + "'";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), textBox3.Text, textBox7.Text, "BANK", textBox4.Text };
}
else
{
sql = "update addindetails set date ='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "',name ='" + textBox3.Text + "',inacc ='" + comboBox2.Text + "',inhd ='" + comboBox3.Text + "',des ='" + textBox6.Text + "',amnt ='" + textBox7.Text + "',mthd ='CASH' where id ='" + row.Cells[0].Value.ToString() + "'";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), textBox3.Text, textBox7.Text, "CASH" };
}
if (k == 0)
{
using (SQLiteConnection cnn = new SQLiteConnection(dbConnection))
{
SQLiteCommand sqlCmd = new SQLiteCommand(sql, cnn);
cnn.Open();
int a = sqlCmd.ExecuteNonQuery();
if (q == 1)
{
MessageBox.Show("SAVED SUCCEFULLY");
}
else
{
Form15 form15 = new Form15(print);
form15.ShowDialog();
}
q = 1;
}
}
else
{
MessageBox.Show("Completely Fill data");
}
}
else
{
MessageBox.Show("Completely Fill data");
}
}
private void button3_Click(object sender, EventArgs e)
{
int k = 0;
if (textBox2.Text.Length > 0 && comboBox1.Text.Length > 0 && comboBox2.Text.Length > 0 && comboBox3.Text.Length > 0 && textBox7.Text.Length > 0)
{
if (radioButton2.Checked == true)
{
if (textBox1.Text.Length == 0 && textBox8.Text.Length == 0 && textBox9.Text.Length == 0)
{
k = 1;
}
sql = "insert into addindetails (date,name,inacc,inhd,des,amnt,bnkname,chqno,chqdt,mthd) values ('" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + comboBox1.Text + "','" + comboBox2.Text + "','" + comboBox3.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox1.Text + "','CHECK');";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), comboBox1.Text, textBox7.Text, "CHECK", textBox9.Text, textBox1.Text, textBox8.Text };
}
else if (radioButton3.Checked == true)
{
if (textBox8.Text.Length == 0)
{
k = 1;
}
sql = "insert into addindetails (date,name,inacc,inhd,des,amnt,bnkname,mthd) values ('" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + comboBox1.Text + "','" + comboBox2.Text + "','" + comboBox3.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','BANK TRANSFER');";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), comboBox1.Text, textBox7.Text, "BANK", textBox8.Text };
}
else
{
sql = "insert into addindetails (date,name,inacc,inhd,des,amnt,mthd) values ('" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + comboBox1.Text + "','" + comboBox2.Text + "','" + comboBox3.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','CASH');";
print = new string[] { dateTimePicker1.Value.ToString("dd-MM-yyyy"), comboBox1.Text, textBox7.Text, "CASH" };
}
if (k == 0)
{
using (SQLiteConnection cnn = new SQLiteConnection(dbConnection))
{
SQLiteCommand sqlCmd = new SQLiteCommand(sql, cnn);
cnn.Open();
int a = sqlCmd.ExecuteNonQuery();
textBox6.Text = ""; textBox7.Text = ""; textBox8.Text = ""; textBox9.Text = ""; textBox1.Text = "";
textBox2.Text = "";
combo_load();
imainhd_load();
comboBox2_SelectedIndexChanged(null, null);
//comboBox2.ResetText();
if (q == 1)
{
MessageBox.Show("SAVED SUCCEFULLY");
}
else
{
Form15 form15 = new Form15(print);
form15.ShowDialog();
}
q = 1;
}
}
else
{
MessageBox.Show("Completely Fill data");
}
}
else
{
MessageBox.Show("Completely Fill data");
}
}
