protected bool Exec(string ProcedureName, params SqlParameter[] parameter) { //IList<SqlParameter> listOutput = null; try { if (_context.Database.Connection.State != ConnectionState.Open) { _context.Database.Connection.Open(); } var command = _context.Database.Connection.CreateCommand(); command.CommandText = ProcedureName; command.CommandType = CommandType.StoredProcedure; SqlParameter output = null; string outputMessage = string.Empty; foreach (SqlParameter p in parameter) { command.Parameters.Add(p); if (string.Compare(p.ParameterName, "OutputMessage", true) == 0) { output = p; } //else if(p.Direction == ParameterDirection.Output) { // if (listOutput == null) { // listOutput = new List<SqlParameter>(); // } // listOutput.Add(p); //} } var count = command.ExecuteNonQuery(); if (output != null) { output.CheckOutputErrorMessage(); } //if (listOutput != null && listOutput.Count() > 0) { //} return(true); } catch (Exception ex) { throw ex; } finally { if (_context != null && _context.Database.Connection.State == ConnectionState.Open) { _context.Database.Connection.Close(); } } return(false); }
protected IList <T> GetList1 <T>(Func <DbDataReader, IList <T> > Method , Dictionary <string, string> Mapping, string ProcedureName, params SqlParameter[] parameter) //where T : new() { IList <T> data = null; try { if (_context.Database.Connection.State != ConnectionState.Open) { _context.Database.Connection.Open(); } var command = _context.Database.Connection.CreateCommand(); command.CommandText = ProcedureName; command.CommandType = CommandType.StoredProcedure; SqlParameter output = null; string outputMessage = string.Empty; foreach (SqlParameter p in parameter) { command.Parameters.Add(p); if (string.Compare(p.ParameterName, "OutputMessage", true) == 0) { output = p; } } using (var reader = command.ExecuteReader()) { if (output != null) { output.CheckOutputErrorMessage(); } data = Method(reader); } } finally { if (_context != null && _context.Database.Connection.State == ConnectionState.Open) { _context.Database.Connection.Close(); } } return(data); }
protected DbDataReader GetDbDataReader(string ProcedureName, params SqlParameter[] parameter) { DbDataReader data = null; try { if (_context.Database.Connection.State != ConnectionState.Open) { _context.Database.Connection.Open(); } var command = _context.Database.Connection.CreateCommand(); command.CommandText = ProcedureName; command.CommandType = CommandType.StoredProcedure; SqlParameter output = null; string outputMessage = string.Empty; foreach (SqlParameter p in parameter) { command.Parameters.Add(p); if (string.Compare(p.ParameterName, "OutputMessage", true) == 0) { output = p; } } using (var reader = command.ExecuteReader()) { if (output != null) { output.CheckOutputErrorMessage(); } data = reader; } } finally { if (_context != null && _context.Database.Connection.State == ConnectionState.Open) { _context.Database.Connection.Close(); } } return(data); }
protected DataSet GetDataSetResult(string ProcedureName, params SqlParameter[] Parameter) { DataSet retVal = new DataSet(); SqlConnection sqlConn = (SqlConnection)_context.Database.Connection; SqlCommand command = new SqlCommand(ProcedureName, sqlConn); SqlDataAdapter da = new SqlDataAdapter(command); SqlParameter output = null; using (command) { BindParameter(command, ref output, Parameter); command.CommandType = CommandType.StoredProcedure; da.Fill(retVal); if (output != null) { output.CheckOutputErrorMessage(); } } return(retVal); }