Example #1
0
        public List <CapitalInfo> getAllCapital()
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                List <CapitalInfo> ListCapital = CapitalDataLayer.GetInstance().GetAllCapital(connection);

                return(ListCapital);
            }
        }
Example #2
0
        public List <CapitalInfo> GetByName(string name)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                List <CapitalInfo> ListCapital = CapitalDataLayer.GetInstance().GetByName(connection, name);

                return(ListCapital);
            }
        }
Example #3
0
        public ActionMessage deleteCapital(int id)
        {
            ActionMessage ret = new ActionMessage();

            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                try
                {
                    CapitalDataLayer.GetInstance().DeleteCapital(connection, id);
                    ret.isSuccess = true;
                }
                catch (Exception ex)
                {
                    ret.isSuccess     = false;
                    ret.err.msgCode   = "Internal Error";
                    ret.err.msgString = ex.ToString();
                }
            }
            return(ret);
        }