private void txtARCode_DoubleClick(object sender, EventArgs e)
{
SearchCustomer search = new SearchCustomer();
search.ShowDialog();
if (search.selectedAccountCode != null && search.selectedAccountCode != "")
{
txtARCode.Text = search.selectedAccountCode;
}
}
private void btn_Search_Click(object sender, EventArgs e)
{
DataRow[] drs;
// drs = dbAccountingProjectDS.ARtrans.Select("TransactionType = 'CreditNote'");
string NOBatches = "";
string s = "";
//if (drs.Length != 0)
//{
// foreach (DataRow r in drs)
// {
// NOBatches = NOBatches + s + r["APBatchNumber"].ToString() + "'";
// s = ",'";
// }
// NOBatches = "('" + NOBatches + ")";
//}
DataRow[] drb = dbAccountingProjectDS.Batch.Select("BatchSRC = 'ARP' AND BatchStat = 'P'");
NOBatches = "";
s = "";
if (drb.Length != 0)
{
foreach (DataRow r in drb)
{
NOBatches = NOBatches + s + r["BatchNo"].ToString() + "'";
s = ",'";
}
NOBatches = "('" + NOBatches + ")";
}
if (applyMode == "AccountCode")
{
if (NOBatches == "")
{
if (NOTranARCredit != "")
{
drs = dbAccountingProjectDS.ARtrans.Select(" ( Paid = 'N' AND BatchNo IN (0) ) OR ( Paid = 'N' AND TransNO IN " + NOTranARCredit + ")");
}
else
{
drs = dbAccountingProjectDS.ARtrans.Select(" Paid = 'N' AND BatchNo IN (0)");
}
}
else
{
if (NOTranARCredit != "")
{
drs = dbAccountingProjectDS.ARtrans.Select(" ( Paid = 'N' AND BatchNo IN " + NOBatches + " ) OR ( Paid = 'N' AND TransNO IN " + NOTranARCredit + ")");
}
else
{
drs = dbAccountingProjectDS.ARtrans.Select(" Paid = 'N' AND BatchNo IN " + NOBatches);
}
}
SearchCustomer search = new SearchCustomer();
if (drs.Length != 0)
{
search.NOSearch = "";
s = "";
foreach (DataRow r in drs)
{
search.NOSearch = search.NOSearch + s + r["AccountCode"].ToString() + "'";
s = ",'";
}
search.NOSearch = "('" + search.NOSearch + ")";
}
search.ApplyCredits = "Credits";
search.ShowDialog();
if (search.selectedAccountCode != null && search.selectedAccountCode != "")
{
txt_Mode.Text = search.selectedAccountCode;
FindTransactions();
}
}
if (applyMode == "Batch")
{
if (NOBatchesARP == "")
{
if (NOTranARCredit != "")
{
drs = dbAccountingProjectDS.ARtrans.Select(" ( Paid = 'N' AND BatchNo IN (0) ) OR ( Paid = 'N' AND TransNO IN " + NOTranARCredit + ")");
}
else
{
drs = dbAccountingProjectDS.ARtrans.Select(" Paid = 'N' AND BatchNo IN (0)");
}
}
else
{
if (NOTranARCredit != "")
{
drs = dbAccountingProjectDS.ARtrans.Select(" ( Paid = 'N' AND BatchNo IN " + NOBatchesARP + " ) OR ( Paid = 'N' AND TransNO IN " + NOTranARCredit + ")");
}
else
{
drs = dbAccountingProjectDS.ARtrans.Select(" Paid = 'N' AND BatchNo IN " + NOBatchesARP);
}
}
SearchAR search = new SearchAR();
if (drs.Length != 0)
{
search.NOSearch = "";
s = "";
foreach (DataRow r in drs)
{
search.NOSearch = search.NOSearch + s + r["BatchNo"].ToString() + "'";
s = ",'";
}
search.NOSearch = "('" + search.NOSearch + ")";
}
search.ApplyCredits = "Credits";
search.ShowDialog();
if (search.selectARNumber != null && search.selectARNumber != "")
{
txt_Mode.Text = search.selectARNumber;
FindTransactions();
}
}
}