Exemple #1
0
        public bool inserir(ClasseEntity classeEntity)
        {
            classe classe = new classe();

            classe.nome = classeEntity.Nome;
            DB.classes.InsertOnSubmit(classe);

            try
            {
                DB.SubmitChanges();
                classeEntity.Id = classe.id;
                if (classeEntity.Professores.Count > 0)
                {
                    foreach (PessoaEntity professor in classeEntity.Professores.Values)
                    {
                        professor_classe pfClasse = new professor_classe();
                        pfClasse.id_classe = classe.id;
                        pfClasse.id_pessoa = professor.Id;
                        DB.professor_classes.InsertOnSubmit(pfClasse);
                        DB.SubmitChanges();
                    }
                }

                DB.SubmitChanges();
                MessageBox.Show("Classe inserida com sucesso", "Informação", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return(true);
            }
            catch (Exception ex)
            {
                Validator.tratarErrosSql("Classe", Validator.INSERIR, ex.Message);
                DB.Transaction.Rollback();
                DB = new db_entityDataContext();
                return(false);
            }
        }
Exemple #2
0
 public ClasseEntity GetOne(int id)
 {
     using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
     {
         using (SqlCommand cmd = c.CreateCommand())
         {
             cmd.CommandText = "SELECT * FROM Classes WHERE Id = @Id AND Active = 1";
             cmd.Parameters.AddWithValue("Id", id);
             c.Open();
             using (SqlDataReader Tab = cmd.ExecuteReader())
             {
                 if (Tab.Read())
                 {
                     ClasseEntity S = new ClasseEntity()
                     {
                         Id     = (int)Tab["Id"],
                         NameEN = Tab["NameEN"].ToString(),
                         NameFR = Tab["NameFR"].ToString(),
                         Active = (int)Tab["Active"]
                     };
                     return(S);
                 }
                 else
                 {
                     return(null);
                 }
             }
         }
     }
 }
Exemple #3
0
        public bool editar(ClasseEntity classeEntity, List <int> idsExcluirProfessor)
        {
            var query = from c in DB.classes where c.id == classeEntity.Id select c;

            foreach (classe ci in query)
            {
                ci.nome = classeEntity.Nome;
            }
            try
            {
                DB.SubmitChanges();
                if (idsExcluirProfessor.Count > 0)
                {
                    foreach (int idpessoa in idsExcluirProfessor)
                    {
                        var queryClasses = from c in DB.professor_classes
                                           where c.id_classe == classeEntity.Id
                                           where c.id_pessoa == idpessoa
                                           select c;
                        foreach (professor_classe pc in queryClasses)
                        {
                            DB.professor_classes.DeleteOnSubmit(pc);
                            DB.SubmitChanges();
                        }
                    }
                }
                if (classeEntity.Professores.Count > 0)
                {
                    //exclui todos os professores e inclui novamente
                    var classeProfessor = from cp in DB.professor_classes
                                          where cp.classe.id == classeEntity.Id
                                          select cp;
                    foreach (var cp in classeProfessor)
                    {
                        DB.professor_classes.DeleteOnSubmit(cp);
                    }
                    foreach (PessoaEntity professor in classeEntity.Professores.Values)
                    {
                        professor_classe pfClasse = new professor_classe();
                        pfClasse.id_classe = classeEntity.Id;
                        pfClasse.id_pessoa = professor.Id;
                        DB.professor_classes.InsertOnSubmit(pfClasse);
                        DB.SubmitChanges();
                    }
                }
                MessageBox.Show("Classe editada com sucesso", "Informação", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return(true);
            }
            catch (Exception ex)
            {
                Validator.tratarErrosSql("Classe", Validator.EDITAR, ex.Message);
                DB = new db_entityDataContext();
                return(false);
            }
        }
Exemple #4
0
 public FormCadastroClasse(bool isSubCadastro)
 {
     InitializeComponent();
     this.isSubCadastro = isSubCadastro;
     dao                           = new ClasseDAO();
     daoProfessor                  = new ProfessorDAO();
     formSearchProfessores         = new FormSearch(daoProfessor);
     formSearchProfessores.FormAdd = new FormCadastroPessoaMembro(true);
     classe                        = new ClasseEntity();
     idProfessoresExcluir          = new List <int>();
     configTela();
     configEvents();
 }
Exemple #5
0
 private void reset()
 {
     if (gridDados.RowCount > 0)
     {
         textBoxNome.Text = "";
         gridDados.CurrentRow.Selected = false;
         classe            = new ClasseEntity();
         gridDados.Enabled = true;
         gridProfessores.Rows.Clear();
         setEditarExcluirEnable(false);
         idProfessoresExcluir = new List <int>();
     }
 }
Exemple #6
0
        public override Entity getEntityByIdentificador(int id)
        {
            ClasseEntity classe = new ClasseEntity();
            var          query  = from c in DB.classes
                                  where c.id == id
                                  select new { c.id, c.nome };

            foreach (var c in query)
            {
                classe.Id   = c.id;
                classe.Nome = c.nome;
            }
            return(classe);
        }
Exemple #7
0
 private void getDadosRow()
 {
     foreach (DataGridViewColumn column in gridDados.Columns)
     {
         if (column.DataPropertyName == "Código")
         {
             int id = Int32.Parse((gridDados.CurrentRow.Cells[column.DisplayIndex].Value).ToString());
             classe           = dao.getClasseComProfessores(id);
             textBoxNome.Text = classe.Nome;
             gridProfessores.Rows.Clear();
             foreach (PessoaEntity professor in classe.Professores.Values)
             {
                 gridProfessores.Rows.Add(new Object[] { professor.Id, professor.Nome, professor.DataNascimento.ToString("dd/MM/yyyy") });
             }
             gridProfessores.Refresh();
         }
     }
 }
Exemple #8
0
        public ClasseEntity getClasseComProfessores(int id)
        {
            ClasseEntity classeEntity = new ClasseEntity();
            var          query        = from cp in DB.professor_classes
                                        where cp.id_classe == id
                                        orderby cp.classe.nome
                                        select new { cp.id_classe, nomeClasse = cp.classe.nome, cp.professor };

            foreach (var cp in query)
            {
                classeEntity.Id   = cp.id_classe;
                classeEntity.Nome = cp.nomeClasse;
                PessoaEntity professor = new PessoaEntity();
                professor.Id             = cp.professor.id;
                professor.Nome           = cp.professor.nome;
                professor.DataNascimento = (DateTime)cp.professor.data_nascimento;
                classeEntity.Professores.Add(professor.Id, professor);
            }
            return(classeEntity);
        }
Exemple #9
0
 public void Create(ClasseEntity T)
 {
     using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString))
     {
         using (SqlCommand cmd = c.CreateCommand())
         {
             if (T != null && T.NameFR != null && T.NameEN != null)
             {
                 cmd.CommandText = "SP_AddClasse";
                 cmd.CommandType = CommandType.StoredProcedure;
                 SqlParameter NameFR = new SqlParameter("NameFR", T.NameFR);
                 SqlParameter NameEN = new SqlParameter("NameEN", T.NameEN);
                 cmd.Parameters.Add(NameFR);
                 cmd.Parameters.Add(NameEN);
                 c.Open();
                 cmd.ExecuteNonQuery();
             }
         }
     }
 }