//public bool deletePayment(int payment_no)
//{
// SQL = "delete from customer_payment where EmailItemID = " + EmailItemID + " and payment_no=" + payment_no;
// Cmd = new SqlCommand(SQL, Con);
// int rowCount = 0;
// try
// {
// Con.Open();
// rowCount = Int32.Parse(Cmd.ExecuteNonQuery().ToString());
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// Con.Close();
// }
// if (rowCount == 1)
// {
// return true;
// }
// else
// {
// return false;
// }
//}
public PaymentManager(string elt_acct) : base(elt_acct)
{
pdMgr = new PaymentDetailManager(elt_account_number);
AAJMgr = new AllAccountsJournalManager(elt_account_number);
ivMgr = new InvoiceManager(elt_account_number);
ccMgr = new CustomerCreditManager(elt_account_number);
}
public PaymentRecord getcustomerPaymentRecordByRefCheck(string ref_check)
{
SQL = "select * from customer_payment where elt_account_number = " + elt_account_number + " and ref_no='" + ref_check + "'";
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
PaymentRecord PRec = new PaymentRecord();
PRec.payment_no = 0;
GeneralUtility gUtil = new GeneralUtility();
PaymentDetailManager pdMger = new PaymentDetailManager(elt_account_number);
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
try
{
gUtil.removeNull(ref dt);
PRec.accounts_receivable = Decimal.Parse(dt.Rows[0]["accounts_receivable"].ToString());
PRec.added_amt = Decimal.Parse(dt.Rows[0]["added_amt"].ToString());
PRec.balance = Decimal.Parse(dt.Rows[0]["balance"].ToString());
PRec.branch = dt.Rows[0]["branch"].ToString();
PRec.customer_name = dt.Rows[0]["customer_name"].ToString();
PRec.customer_number = Int32.Parse((dt.Rows[0]["customer_number"].ToString()));
PRec.deposit_to = Int32.Parse(dt.Rows[0]["deposit_to"].ToString());
PRec.existing_credits = Decimal.Parse(dt.Rows[0]["existing_credits"].ToString());
PRec.is_org_merged = dt.Rows[0]["is_org_merged"].ToString();
PRec.payment_date = dt.Rows[0]["payment_date"].ToString();
PRec.payment_no = Int32.Parse((dt.Rows[0]["payment_no"].ToString()));
PRec.pmt_method = dt.Rows[0]["pmt_method"].ToString();
PRec.received_amt = Decimal.Parse(dt.Rows[0]["received_amt"].ToString());
//PRec.PAY
PRec.ref_no = dt.Rows[0]["ref_no"].ToString();
PRec.unapplied_amt = Decimal.Parse(dt.Rows[0]["unapplied_amt"].ToString());
PRec.PaymentDetailList = pdMger.getPaymentDetailList(PRec.payment_no);
}
catch (Exception ex)
{
throw ex;
}
}
return(PRec);
}
