Esempio n. 1
0
 /// <summary>
 /// Creates a new entity in the database.
 /// </summary>
 /// <param name="entity">The entity being created.</param>
 /// <returns>The created entity's Id.</returns>
 public virtual int CreateEntity(DAL_Entity entity)
 {
     int entityId = 0;
     object obj = ExecuteScalar(entity.CreateSproc, entity.ToSqlParams().ToArray());
     if (obj is int)
         entityId = (int)obj;
     return entityId;
 }
Esempio n. 2
0
        /// <summary>
        /// Retrieves all entities in the database.
        /// </summary>
        /// <param name="entity">The entity being used for retrieving all entities.</param>
        /// <returns>A list of entities found in the database.</returns>
        public virtual List<DAL_Entity> RetrieveEntities(DAL_Entity entity)
        {
            List<DAL_Entity> entities = new List<DAL_Entity>();
            using (SqlConnection conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(entity.RetrieveAllSproc, conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                        entities.Add(entity.ConvertToEntity(reader));
                }
            }
            return entities;
        }
Esempio n. 3
0
        /// <summary>
        /// Retrieves an entity with the specified Id in the database.
        /// </summary>
        /// <param name="entity">The entity that contains the Id to query by.</param>
        /// <returns>An single enity.</returns>
        public virtual DAL_Entity RetrieveEntityById(DAL_Entity entity)
        {
            DAL_Entity dal_entity = null;
            using (SqlConnection conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(entity.RetrieveSingleSproc, conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddRange(entity.ToSqlParams().ToArray());
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                        dal_entity = entity.ConvertToEntity(reader);
                }
            }
            return dal_entity;
        }
Esempio n. 4
0
 /// <summary>
 /// Deletes an entity in the database.
 /// </summary>
 /// <param name="entity">The entity being deleted.</param>
 /// <returns>Determines whether the operation was successful.</returns>
 public virtual bool DeleteEntity(DAL_Entity entity)
 {
     return ExecuteSproc(entity.DeleteSproc, entity.ToSqlParams().ToArray());
 }