private void button1_Click(object sender, EventArgs e)
{
F_Main f_main = new F_Main();
int view_id, valute_id, costs_id = 0;
dt_query = f_main.QuerySel("select id from type_views where name = '" + cb_view.Text + "'");
view_id = Convert.ToInt32(dt_query.Rows[0][0]);
dt_query = f_main.QuerySel("select id from type_valute where name = '" + cb_valute.Text + "'");
valute_id = Convert.ToInt32(dt_query.Rows[0][0]);
if (groupBox7.Visible)
{
if (rb_osn.Checked)
{
dt_query = f_main.QuerySel("select id from type_costs where name = '" + cb_costs.Text + "'");
}
else if (rb_plan.Checked)
{
dt_query = f_main.QuerySel("select id from planning where name = '" + cb_costs.Text + "' and closse = 0");
}
costs_id = Convert.ToInt32(dt_query.Rows[0][0]);
}
if (numRow != 0)
{
if (f_main.QueryExec("UPDATE MONEY SET " +
" COMMENT = '" + tb_comment.Text + "', " +
" VIEW_ID = " + view_id + ", " +
" SUMMA = '" + Convert.ToString(tb_summa.Text) + "', " +
" VALUTE_ID = " + valute_id + ", " +
" date_crt = '" + dtp_date.Value + "' " +
((groupBox7.Visible)?", costs_id = " + costs_id:", costs_id = 0 ") +
((rb_plan.Checked) ? ", planning_id = 1 ": ", planning_id = 0 ") +
" where id = " + numRow) == true)
{
MessageBox.Show("Запись успешно обновлена!");
}
}
else
{
if (f_main.QueryExec("INSERT INTO MONEY (ID, COMMENT, VIEW_ID, SUMMA, VALUTE_ID, DATE_CRT, COSTS_ID, PLANNING_ID) "
+ " VALUES(null, '" + tb_comment.Text + "', " + view_id + ", " + Convert.ToString(tb_summa.Text)
+ "," + valute_id + ", '" + dtp_date.Value.ToString("dd.MM.yyyy hh:mm:ss") + "' " + ((groupBox7.Visible) ? ", " + costs_id : ", 0 ")
+ ((rb_plan.Checked) ? ", 1 )" : ", 0 )")) == true)
{
MessageBox.Show("Запись успешно добавлена!");
}
}
}
