public bool FindPayableListByCustomerCode(string CustomerCode)
{
bool bResult = false;
using (DbManager db = new DbManager())
{
try
{
db.Command.CommandText = string.Format(@"select * from CUSTOMER_PAYABLE_TBL
where CUSTCODE = '{0}'", CustomerCode);
using (IDataReader dbReader = (IDataReader)db.ExecuteReader())
{
CustomerPayableClass commpayable;
payableList.Clear();
while (dbReader.Read())
{
commpayable = new CustomerPayableClass();
commpayable.CustomerCode = CustomerCode;
commpayable.PayableCode = dbReader.GetString(dbReader.GetOrdinal("PAYABLE_CODE"));
commpayable.PayableAmount = (float)Convert.ToDecimal(dbReader.GetValue(dbReader.GetOrdinal("PAYABLE_AMOUNT")));
payableList.Add(commpayable);
bResult = true;
}
dbReader.Close();
}
}
catch (Exception except)
{
throw new Exception("Error in retrieving payable obligation!");
}
}
return(bResult);
}
public bool FindPayableListByCustomerCode(string CustomerCode)
{
bool bResult = false;
using (DbManager db = new DbManager())
{
try
{
db.Command.CommandText = string.Format(@"select * from CUSTOMER_PAYABLE_TBL
where CUSTCODE = '{0}'", CustomerCode);
using (IDataReader dbReader = (IDataReader)db.ExecuteReader())
{
CustomerPayableClass commpayable;
payableList.Clear();
while (dbReader.Read())
{
commpayable = new CustomerPayableClass();
commpayable.CustomerCode = CustomerCode;
commpayable.PayableCode = dbReader.GetString(dbReader.GetOrdinal("PAYABLE_CODE"));
commpayable.PayableAmount = (float)Convert.ToDecimal(dbReader.GetValue(dbReader.GetOrdinal("PAYABLE_AMOUNT")));
payableList.Add(commpayable);
bResult = true;
}
dbReader.Close();
}
}
catch (Exception except)
{
throw new Exception("Error in retrieving payable obligation!");
}
}
return bResult;
}
public void AddPayable(CustomerPayableClass payable)
{
payableList.Add(payable);
}
public void AddPayable(CustomerPayableClass payable)
{
payableList.Add(payable);
}
private string GetPayablesValue(string PayableCode)
{
CustomerPayableClass payableItem = new CustomerPayableClass();
payableItem = this.customerPayableListAccessor.AllPayables.Find(delegate(CustomerPayableClass cpayable)
{
return (cpayable.PayableCode == PayableCode);
});
if (payableItem == null)
return "0.00";
else
return string.Format("{0:0.00}", payableItem.PayableAmount);
}
