Example #1
0
        /// <summary>
        /// Lấy về danh sách data của bảng
        /// </summary>
        /// <returns>Danh sách dữ liệu của bảng TEntity</returns>
        /// Create by: dvthang:19.04.2017
        public IList GetAllByEditMode(MT.Library.Enummation.EditMode editMode)
        {
            List <TEntity> lstData = null;

            try
            {
                string storeName = string.Format(Commonkey.mscSelectAllByEditMode, Commonkey.Schema, typeof(TEntity).Name);
                using (DbCommand command = this.DB.GetStoredProcCommand(storeName, editMode))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    IDataReader reader = null;
                    if (m_ts != null)
                    {
                        reader = this.DB.ExecuteReader(command, m_ts);
                    }
                    else
                    {
                        reader = this.DB.ExecuteReader(command);
                    }
                    lstData = reader.FillCollection <TEntity>();
                }
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(lstData);
        }
Example #2
0
        public virtual ResultData GetAllByEditMode(MT.Library.Enummation.EditMode editMode)
        {
            ResultData resultData = new ResultData {
                Success = true, Code = System.Net.HttpStatusCode.OK
            };

            try
            {
                resultData.Data = this.GetRep().GetAllByEditMode(editMode);
            }
            catch (Exception ex)
            {
                resultData.SetError(ex);
            }
            return(resultData);
        }