private void add_payment_btn_Click(object sender, EventArgs e)
{
date = dateTimePicker1.Value;
int n;
if (customer_combo.SelectedIndex >= 0 && int.TryParse(price_text.Text, out n))
{
String query = "INSERT INTO payments (cust_id,pay_price,pay_date,pay_note,user_id)" +
"VALUES((SELECT cust_id from customer where cust_name='" + customer_combo.SelectedItem + "') , '" + price_text.Text + "' , '" + FormatDate(date) + "', '" + textBox1.Text + "' ,'" + form.Id + "' )";
if (db.insertDB(query))
{
if (ch != null)
{
if (ch.IMG == null)
{
string query2 = "INSERT INTO checks VALUES('" + ch.Id + "', (SELECT MAX(pay_id) from payments) ,'" + ch.Bank + "'" +
",'" + ch.Owner + "' , '" + FormatDate(ch.Delv_Date) + "' ," + ch.Price + " ,'" + ch.Notes + "')";
db.insertDB(query2);
}
else
{
string query2 = "INSERT INTO checks VALUES('" + ch.Id + "', (SELECT MAX(pay_id) from payments) ,'" + ch.Bank + "'" +
",'" + ch.Owner + "' , '" + FormatDate(ch.Delv_Date) + "' ," + ch.Price + " ,'" + ch.Notes + "',@picture)";
db.insertImg(query2, ch.IMG);
}
}
this.Close();
if (form != null)
{
form.RefreshPayment(form.payment_query);
}
if (cust_form != null)
{
cust_form.RefreshData();
}
}
}
else
{
MessageBox.Show("يحب ان تختار زبون\nويجب ان تضل قيمه رقميه في قيمه الكاش");
}
}