예제 #1
0
        public static bool Create(Grado grado)
        {
            using (SqlConnection connection = DBConfig.GetInstance().GetConnection())
            {
                try
                {
                    SqlCommand query = new SqlCommand("spGradoCreate", connection)
                    {
                        CommandType = CommandType.StoredProcedure
                    };
                    query.Parameters.AddWithValue("@nombre", grado.Nombre);
                    query.Parameters.AddWithValue("@profesorID", grado.ProfesorID);

                    int rowsAffected = query.ExecuteNonQuery();

                    if (rowsAffected == 1)
                    {
                        return(true);
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
            return(false);
        }
예제 #2
0
        public static bool Delete(int id)
        {
            using (SqlConnection connection = DBConfig.GetInstance().GetConnection())
            {
                try
                {
                    SqlCommand query = new SqlCommand("spGradoDeleteByID", connection)
                    {
                        CommandType = CommandType.StoredProcedure
                    };
                    query.Parameters.AddWithValue("@id", id);

                    int rowsAffected = query.ExecuteNonQuery();

                    if (rowsAffected == 1)
                    {
                        return(true);
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
            return(false);
        }
예제 #3
0
        public static List <Grado> GetAll()
        {
            List <Grado> grados = new List <Grado>();

            using (SqlConnection connection = DBConfig.GetInstance().GetConnection())
            {
                try
                {
                    SqlCommand query = new SqlCommand("spGradoGetAll", connection)
                    {
                        CommandType = CommandType.StoredProcedure
                    };

                    SqlDataReader reader = query.ExecuteReader();

                    while (reader.Read())
                    {
                        Grado grado = new Grado
                        {
                            ID         = Convert.ToInt32(reader["id"]),
                            Nombre     = Convert.ToString(reader["nombre"]),
                            ProfesorID = Convert.ToInt32(reader["profesorID"])
                        };
                        grados.Add(grado);
                    }
                } catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
            return(grados);
        }
예제 #4
0
        public static Grado GetByID(int id)
        {
            Grado grado = null;

            using (SqlConnection connection = DBConfig.GetInstance().GetConnection())
            {
                try
                {
                    SqlCommand query = new SqlCommand("spGradoGetByID", connection)
                    {
                        CommandType = CommandType.StoredProcedure
                    };
                    query.Parameters.AddWithValue("@id", id);

                    SqlDataReader reader = query.ExecuteReader();

                    while (reader.Read())
                    {
                        grado = new Grado
                        {
                            ID         = Convert.ToInt32(reader["id"]),
                            Nombre     = Convert.ToString(reader["nombre"]),
                            ProfesorID = Convert.ToInt32(reader["profesorID"])
                        };
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
            }
            return(grado);
        }
예제 #5
0
 public static DBConfig GetInstance()
 {
     try
     {
         if (Instance == null)
         {
             Instance = new DBConfig();
         }
         Instance.Connection = new SqlConnection(ConnectionString);
         Instance.Connection.Open();
     }
     catch (Exception e)
     {
         Console.WriteLine(e.Message);
     }
     return(Instance);
 }