public string GetTrnRef()
{
int _nVGMID = 0;
string sRetStr = "";
string _flag = "000";
try
{
string QueryString = "SELECT CONVERT(VARCHAR,ISNULL(MAX(dt.TranRef),0)) FROM tbl_DailyTransactions dt WHERE dt.DBSDT='" + DateTime.Now.ToString("yyyy-MM-dd") + "'";
sRetStr = ExecuteQueryFunctions.ExeRetStr(_conn, QueryString);
if (sRetStr == "0")
{
sRetStr = "001";
}
else
{
_nVGMID = Convert.ToInt32(sRetStr.Substring(sRetStr.Length - 3, 3)) + 1;
_flag = _flag.Substring(0, _flag.Length - _nVGMID.ToString().Length);
sRetStr = _flag + _nVGMID;
}
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
return(sRetStr);
}
public bool Delete(int nID)
{
try
{
string sRetStr = ExecuteQueryFunctions.ExeRetStr(_conn, "SELECT CONVERT(VARCHAR,ISNULL(currentBalance,0)) FROM [tbl_bankAccount] WHERE ObjectID=" + nID);
if (Convert.ToDouble(sRetStr) > 0)
{
throw new ServiceException("Delete not posible, It has balance.!");
}
else
{
string QueryString = "DELETE FROM [tbl_bankAccount] WHERE ObjectID=" + nID;
ExecuteQueryFunctions.ExeNonQuery(_conn, QueryString);
return(true);
}
}
catch (Exception e)
{
throw new ServiceException(e.Message, e);
}
}
