public List <T> ExecuteQuery <T>(string _SelectStatement) where T : new() { try { sqlcmd.CommandType = CommandType.Text; sqlcmd.CommandText = _SelectStatement; if (sqlconn.State == ConnectionState.Closed) { sqlconn.Open(); } dr = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection); GenericDataReaderMapper <T> _GenericDataReaderMapper = new GenericDataReaderMapper <T>(); List <T> lst = _GenericDataReaderMapper.ToList(dr); if (!dr.IsClosed) { dr.Close(); } return(lst); } catch (Exception ex) { throw ex; } finally { try { if (sqlconn.State == ConnectionState.Open) { sqlconn.Close(); } if (sqlcmd != null) { sqlcmd.Dispose(); } if (!dr.IsClosed) { dr.Close(); } } catch { } } }
public List <T> ExecuteQuery <T>(string _Select_SP, List <SqlParameter> _Param) where T : new() { try { sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.CommandText = _Select_SP; sqlcmd.Parameters.Clear(); if (_Param != null) { foreach (SqlParameter sp in _Param) { sqlcmd.Parameters.Add(sp); } } if (sqlconn.State == ConnectionState.Closed) { sqlconn.Open(); } dr = sqlcmd.ExecuteReader(CommandBehavior.CloseConnection); GenericDataReaderMapper <T> _GenericDataReaderMapper = new GenericDataReaderMapper <T>(); List <T> lst = _GenericDataReaderMapper.ToList(dr); // dt.Load(dr); if (!dr.IsClosed) { dr.Close(); } return(lst); } catch (Exception ex) { //LogError.Write_Log(Apps.WorkList, ex, Log_Level.Basic); return(null); } finally { try { if (sqlconn.State == ConnectionState.Open) { sqlconn.Close(); } if (sqlcmd != null) { sqlcmd.Dispose(); } if (!dr.IsClosed) { dr.Close(); } } catch { } } }