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