private void btn_Invoices_Click(object sender, EventArgs e) { DataTable dt3 = new DataTable(); try { if (txt_Customer.Text.Trim() == "") { dt3 = T_RecDetDL.GetCQ("", rdo_post.Checked, rdo_retured.Checked, dte_to.Value, dte_from.Value); dte_cheques.DataSource = dt3; dte_cheques.Columns[0].Width = 100; dte_cheques.Columns[1].Width = 100; dte_cheques.Columns[2].Width = 100; dte_cheques.Columns[3].Width = 190; dte_cheques.Columns[4].Width = 100; dte_cheques.Columns[5].Width = 100; dte_cheques.Columns[0].ReadOnly = true; dte_cheques.Columns[1].ReadOnly = true; dte_cheques.Columns[2].ReadOnly = true; dte_cheques.Columns[3].ReadOnly = true; dte_cheques.Columns[4].ReadOnly = true; dte_cheques.Columns[5].ReadOnly = true; dte_cheques.Refresh(); } else { if (findExisting.FindExisitingCUstomer(txt_Customer.Text.Trim()).Trim() == "<Error!!!>".Trim()) { errorProvider1.SetError(txt_Customer, "Please enter valied customer id"); commonFunctions.SetMDIStatusMessage("Please enter valied customer id", 1); return; } dt3 = T_RecDetDL.GetCQ(txt_Customer.Text.Trim(), rdo_post.Checked, rdo_retured.Checked, dte_to.Value, dte_from.Value); dte_cheques.DataSource = dt3; dte_cheques.Columns[0].Width = 100; dte_cheques.Columns[1].Width = 100; dte_cheques.Columns[2].Width = 100; dte_cheques.Columns[3].Width = 190; dte_cheques.Columns[4].Width = 100; dte_cheques.Columns[5].Width = 100; dte_cheques.Columns[0].ReadOnly = true; dte_cheques.Columns[1].ReadOnly = true; dte_cheques.Columns[2].ReadOnly = true; dte_cheques.Columns[3].ReadOnly = true; dte_cheques.Columns[4].ReadOnly = true; dte_cheques.Columns[5].ReadOnly = true; dte_cheques.Refresh(); } } catch (Exception ex) { LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception"); commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1); } }
private void button4_Click(object sender, EventArgs e) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { foreach (DataGridViewRow drow in dte_cheques.Rows) { if (drow.Cells[0].Value.ToString().Trim() != null) { T_RecDet det = new T_RecDet(); det = new T_RecDetDL().Selectt_RecDet(det, drow.Cells[0].Value.ToString().Trim(), drow.Cells[1].Value.ToString().Trim()); if (det != null) { det.isReconsile = Convert.ToBoolean(drow.Cells[6].Value); det.isreturned = Convert.ToBoolean(drow.Cells[7].Value); new T_RecDetDL().Savet_RecDetSP(det, 3); } } } } }