public DataTable ExecuteDataTable(string query, SqlParameter[] parameters, CommandType commandType = CommandType.StoredProcedure) { var conn = Database.GetDbConnection(); DataTable dt = new DataTable(); if (conn.State != ConnectionState.Open) { conn.Open(); } try { var command = conn.CreateCommand(); command.CommandText = query; command.CommandType = commandType; if (parameters != null) { command.Parameters.AddRange(parameters); } using (var reader = command.ExecuteReader()) { dt.Load(reader); reader.Close(); } } catch (Exception ex) { throw ex; } finally { if (conn.State != ConnectionState.Closed) { conn.Close(); } } return(dt); }
public DataSet ExecuteDataSet(string query, SqlParameter[] parameters) { var conn = Database.GetDbConnection(); DataSet ds = new DataSet(); if (conn.State != ConnectionState.Open) { conn.Open(); } try { var command = conn.CreateCommand(); command.CommandText = query; command.CommandType = CommandType.StoredProcedure; if (parameters != null) { command.Parameters.AddRange(parameters); } using (DbDataAdapter dataAdapter = new SqlDataAdapter((SqlCommand)command)) { dataAdapter.Fill(ds); } } catch (Exception ex) { throw ex; } finally { if (conn.State != ConnectionState.Closed) { conn.Close(); } } return(ds); }
public int ExecuteNonQuery(string query, params object[] parameters) { var conn = Database.GetDbConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); } var command = conn.CreateCommand(); command.CommandText = query; command.CommandType = CommandType.StoredProcedure; if (parameters != null) { DbParameter[] _params = GetParameters(parameters); command.Parameters.AddRange(_params); } return(command.ExecuteNonQuery()); }