private void btnInsert_Click(object sender, EventArgs e) { bool valueIsValid = true; if (CLSValidityCheck.IsInt(txtInstalmentBalance)) { if (int.Parse(txtInstalmentBalance.Text) <= 0) valueIsValid = false; } else valueIsValid = false; if (valueIsValid) { double newInstalment = double.Parse(txtInstalmentBalance.Text); if (newInstalment <= remainBalance) { bool termExistsInTable = false; DataRow drCurrentTerm = null; foreach (DataRow dr in dtInstalment.Rows) { if (dr["Pay_Term_No"].ToString() == numTermNo.Value.ToString()) { termExistsInTable = true; drCurrentTerm = dr; } } if (termExistsInTable) { if (MessageBox.Show("مبلغ " + drCurrentTerm["Balance"].ToString() + " برای این دوره ثبت گردیده است. مبلغ جدید به مبلغ قبلی اضافه شود؟", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { drCurrentTerm["Balance"] = double.Parse(drCurrentTerm["Balance"].ToString()) + newInstalment; CalcFormBalances(); } } else { DataRow drNew = dtInstalment.Rows.Add(); drNew["Bill_Term_No"] = termNo; drNew["Pay_Term_No"] = (int)numTermNo.Value; drNew["Cntr_No"] = int.Parse(cntrNo); drNew["Balance"] = newInstalment; drNew["cmdDelete"] = "حذف"; instalmentSum += newInstalment; lblInstalmentSum.Text = instalmentSum.ToString(); remainBalance = billBalance - instalmentSum; lblRemainBalance.Text = remainBalance.ToString(); txtInstalmentBalance.Text = remainBalance.ToString(); numTermNo.Value++; } } else { MessageBox.Show("مقدار وارد شده از مبلغ باقیمانده قبض بیشتر است."); } } else MessageBox.Show("مقدار وارد شده معتبر نیست."); txtInstalmentBalance.Focus(); txtInstalmentBalance.SelectAll(); }
private bool InsertUpdateAction() { if (CLSValidityCheck.IsInt(txtPayBalance) && CLSValidityCheck.IsDate(mskPayDate)) { string query = ""; if (modeIsUpdate) { query += "update tbl_payment set "; query += "Pay_Balance =" + txtPayBalance.Text.Trim() + ","; query += "Pay_Date = '" + (mskPayDate.Text.Trim()) + "'"; query += " where Cust_No = " + cmbCust.Text + " and Pay_Date = '" + original_Pay_Date + "' and Pay_Balance = " + original_Pay_Balance; } else { string Cntr_No = ""; try { Cntr_No = dataAccess.GetAccessDataSetByQuery("select Cntr_No from tbl_Cust where cust_No = " + cmbCust.Text).Tables[0].Rows[0]["Cntr_No"].ToString(); } catch { MessageBox.Show("مشتری با این شماره وجود ندارد", "", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign); return(false); } query += "insert into tbl_payment (cust_No,cntr_No,Pay_Date,Pay_Balance)"; query += " values (" + cmbCust.Text.Trim() + "," + Cntr_No + ",'" + mskPayDate.Text.Trim() + "'," + txtPayBalance.Text + ")"; } dataAccess.ExecuteAccess(query); if (!modeIsUpdate) { if (cmbCust.SelectedIndex < dtCust.Rows.Count - 1) { cmbCust.SelectedIndex++; } if (mskPayDate.Enabled) { mskPayDate.Select(); mskPayDate.SelectAll(); } else { txtPayBalance.Select(); txtPayBalance.SelectAll(); } } else { DialogResult = DialogResult.OK; //Close(); } } else { MessageBox.Show("لطفاً مقادیر وارد شده را تصحیح نمایید"); return(false); } return(true); }
private void txtPayBalance_Leave(object sender, EventArgs e) { CLSValidityCheck.IsInt(txtPayBalance); }