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);
}
}
}
}
}
