コード例 #1
0
        /// <summary>
        /// Inserimento row
        /// </summary>
        /// <param name="museo"></param>
        /// <returns></returns>
        private Museo AddMuseo(Museo museo)
        {
            Int32 Id = 0;

            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("AddMuseo", con))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.Add("@id_macroaree", SqlDbType.Int).Value    = museo.id_macroaree;
                        cmd.Parameters.Add("@nome", SqlDbType.VarChar).Value        = museo.nome;
                        cmd.Parameters.Add("@descrizione", SqlDbType.VarChar).Value = museo.descrizione;
                        cmd.Parameters.Add(new SqlParameter("@returnId", SqlDbType.Int));
                        cmd.Parameters["@returnId"].Direction = ParameterDirection.Output;

                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                        Id = Convert.ToInt32(cmd.Parameters["@returnId"].Value);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel AddMuseo: " + ex.Message);
            }
            return(GetMuseo(Id));
        }
コード例 #2
0
        /// <summary>
        /// Update row
        /// </summary>
        /// <param name="museo"></param>
        /// <returns></returns>
        private Museo UpdateMuseo(Museo museo)
        {
            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("UpDataMuseo", con))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.Add("@id", SqlDbType.Int).Value              = museo.Id;
                        cmd.Parameters.Add("@id_macroaree", SqlDbType.Int).Value    = museo.id_macroaree;
                        cmd.Parameters.Add("@nome", SqlDbType.VarChar).Value        = museo.nome;
                        cmd.Parameters.Add("@descrizione", SqlDbType.VarChar).Value = museo.descrizione;
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel UpdateMuseo: " + ex.Message);
            }
            return(museo);
        }
コード例 #3
0
        /// <summary>
        /// Elenco macro aree
        /// </summary>
        /// <returns>macro aree trovate</returns>
        public List <MacroArea> GetMacroAree()
        {
            List <MacroArea> macroaree = new List <MacroArea>();

            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("GetMacroAree", con))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;

                        con.Open();
                        using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            while (reader.Read())
                            {
                                MacroArea macroarea = new MacroArea();
                                macroarea.id = reader.GetInt64(reader.GetOrdinal("id"));

                                if (reader.GetValue(reader.GetOrdinal("data_cancellazione")).ToString() != "")
                                {
                                    macroarea.data_cancellazione = DBHelper.ConvertDBStringToDatetime(reader.GetValue(reader.GetOrdinal("data_cancellazione")).ToString()).Value;
                                }
                                macroarea.zona           = reader.GetString(reader.GetOrdinal("zona"));
                                macroarea.data_creazione = reader.GetDateTime(reader.GetOrdinal("data_creazione"));
                                macroarea.data_modifica  = reader.GetDateTime(reader.GetOrdinal("data_modifica"));


                                macroaree.Add(macroarea);
                            }
                        }
                        con.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel GetMacroAree: " + ex.Message);
            }
            return(macroaree);
        }
コード例 #4
0
        /// <summary>
        /// Ricerca musei
        /// </summary>
        /// <param name="filtro">Filtro di ricerca</param>
        /// <returns>Musei trovati</returns>
        public Museo GetMuseo(int id)
        {
            Museo museo = new Museo();

            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("GetListMusei", con))
                    {
                        cmd.CommandTimeout = 0;
                        cmd.CommandType    = CommandType.StoredProcedure;

                        cmd.Parameters.Add("@Id", SqlDbType.Int).Value             = id;
                        cmd.Parameters.Add("@IdMacroArea", SqlDbType.Int).Value    = 0;
                        cmd.Parameters.Add("@DataDa", SqlDbType.VarChar, 50).Value = "";
                        cmd.Parameters.Add("@DataAl", SqlDbType.VarChar, 50).Value = "";


                        con.Open();
                        using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            while (reader.Read())
                            {
                                museo.Id             = DBHelper.ConvertDBStringToInt(reader["Id"].ToString());
                                museo.nome           = DBHelper.GetString(reader["nome"].ToString());
                                museo.descrizione    = DBHelper.GetString(reader["descrizione"].ToString());
                                museo.data_creazione = reader.GetDateTime(reader.GetOrdinal("data_creazione"));
                                museo.zona           = reader.GetString(reader.GetOrdinal("zona"));
                            }
                        }
                        con.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel GetMuseo: " + ex.Message);
            }
            return(museo);
        }
コード例 #5
0
        /// <summary>
        /// Delete row
        /// </summary>
        /// <param name="id"></param>
        public void DeleteMuseo(int id)
        {
            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("DeleteMuseo", con))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;

                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel UpdateMuseo: " + ex.Message);
            }
        }
コード例 #6
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public List <Museo> GetListMusei(RequestMuseoFilter request)
        {
            List <Museo> list = new List <Museo>();

            try
            {
                using (SqlConnection con = new SqlConnection(UtilitiesDB.GetConnectionStringSQL()))
                {
                    using (SqlCommand cmd = new SqlCommand("GetListMusei", con))
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add("@Id", SqlDbType.Int).Value             = 0;
                        cmd.Parameters.Add("@IdMacroArea", SqlDbType.Int).Value    = request.IdMacroArea;
                        cmd.Parameters.Add("@DataDa", SqlDbType.VarChar, 50).Value = request.DataDa.Value.ToString("yyyyMMdd");
                        cmd.Parameters.Add("@DataAl", SqlDbType.VarChar, 50).Value = request.DataAl.Value.ToString("yyyyMMdd");

                        con.Open();
                        using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            while (reader.Read())
                            {
                                list.Add(PopulateMuseo(reader));
                            }
                        }
                        con.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("Si è verificato un errore nel GetListMusei: " + ex.Message);
            }
            finally
            {
            }
            return(list);
        }