예제 #1
0
 public UnitOfWork(LarcContext context)
 {
     _context   = context;
     Events     = new EventRepository(_context);
     EventTypes = new EventTypeRepository(_context);
     Ministries = new MinistryRepository(_context);
     Podcasts   = new PodcastRepository(_context);
     Preachers  = new PreacherRepository(_context);
 }
예제 #2
0
        public int ExecuteSql(string storedProcedureName, List <SqlParameter> listSqlParameter)
        {
            var context = new LarcContext();

            using (var sqlConnection = new SqlConnection(context.Database.Connection.ConnectionString))
            {
                sqlConnection.Open();
                try
                {
                    var command = new SqlCommand
                    {
                        CommandText = storedProcedureName,
                        Connection  = sqlConnection,
                        CommandType = CommandType.StoredProcedure
                    };
                    var resultParameter = command.CreateParameter();
                    resultParameter.ParameterName = "@result";
                    resultParameter.Direction     = ParameterDirection.Output;
                    resultParameter.DbType        = DbType.Int32;
                    resultParameter.Value         = -1;
                    if (listSqlParameter != null)
                    {
                        foreach (var parameter in listSqlParameter)
                        {
                            command.Parameters.Add(parameter);
                        }

                        command.Parameters.Add(resultParameter);
                    }
                    command.ExecuteNonQuery();
                    return((int)resultParameter.Value);
                }
                catch (Exception ex)
                {
                    //Log.Error("ExecutePostSqlStoredProcedure - " + storedProcedureName, ex);
                }
            }
            return(-1);
        }
예제 #3
0
 public Repository(LarcContext context)
 {
     Context = context;
 }