internal bool Save(TurmaProgramacao_TO pTO) { SqlConnection connection = null; try { connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]); connection.Open(); } catch (Exception) { throw; } SqlCommand command = null; SqlDataReader reader = null; bool retorno = false; string sql = "INSERT INTO turma_programacao" + "( tpr_data_aula " + ", tpr_horas_inicial " + ", tpr_horas_final " + ", tur_codigo) " + "VALUES " + "( @tpr_data_aula " + " , @tpr_horas_inicial " + " , @tpr_horas_final " + " , @tur_codigo ) " + "SELECT @@IDENTITY AS tpr_codigo"; try { command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@tpr_data_aula", pTO.tpr_data_aula); //command.Parameters.AddWithValue("@tpr_codigo", pTO.tpr_codigo); command.Parameters.AddWithValue("@tpr_horas_inicial", pTO.tpr_horas_inicial); command.Parameters.AddWithValue("@tpr_horas_final", pTO.tpr_horas_final); command.Parameters.AddWithValue("@tur_codigo", pTO.TurmaTO.tur_codigo); reader = command.ExecuteReader(); if (reader.Read()) { pTO.tpr_codigo = Convert.ToInt32(reader["tpr_codigo"]); retorno = true; } } catch (Exception) { throw; } finally { command.Dispose(); connection.Close(); connection.Dispose(); } return(retorno); }
public bool Delete(TurmaProgramacao_TO pTO) { bool retorno = false; try { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { if (new Chamada_DAO().Delete(pTO)) { retorno = new TurmaProgramacao_DAO().Delete(pTO); } if (retorno) { ts.Complete(); } else { ts.Dispose(); } } } catch (Exception) { throw; } return(retorno); }
public TurmaProgramacao_TO GetByCode(TurmaProgramacao_TO pTO) { try { return(new TurmaProgramacao_DAO().GetByCode(pTO)); } catch (Exception) { throw; } }
internal TurmaProgramacao_TO GetByCode(TurmaProgramacao_TO pTO) { SqlConnection connection = null; try { connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]); connection.Open(); } catch (Exception) { throw; } SqlCommand command = null; SqlDataReader reader = null; string sql = " SELECT * FROM turma_programacao " + "WHERE tpr_codigo = @tpr_codigo "; try { command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@tpr_codigo", pTO.tpr_codigo); reader = command.ExecuteReader(); if (reader.Read()) { pTO.tpr_codigo = Convert.ToInt32(reader["tpr_codigo"]); pTO.tpr_data_aula = Convert.ToDateTime(reader["tpr_data_aula"]); pTO.tpr_horas_inicial = Convert.ToString(reader["tpr_horas_inicial"]); pTO.tpr_horas_final = Convert.ToString(reader["tpr_horas_final"]); pTO.TurmaTO = new Turma_TO(); pTO.TurmaTO.tur_codigo = Convert.ToInt32(reader["tur_codigo"]); } } catch (Exception) { throw; } finally { reader.Close(); command.Dispose(); connection.Close(); connection.Dispose(); } return(pTO); }
public List <TurmaProgramacao_TO> SearchAll(TurmaProgramacao_TO pTO) { string condicao = ""; try { // implementa a condição de procura condicao += ""; return(new TurmaProgramacao_DAO().SearchAll(condicao)); } catch (Exception) { throw; } }
internal bool Update(TurmaProgramacao_TO pTO) { SqlConnection connection = null; try { connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]); connection.Open(); } catch (Exception) { throw; } SqlCommand command = null; bool retorno = false; string sql = "UPDATE turma_programacao" + " SET tpr_data_aula = @tpr_data_aula " + " , tpr_horas_inicial = @tpr_horas_inicial " + " , tpr_horas_final = @tpr_horas_final " + " , tur_codigo = @tur_codigo " + "WHERE tpr_codigo = @tpr_codigo "; try { command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@tpr_codigo", pTO.tpr_codigo); command.Parameters.AddWithValue("@tpr_data_aula", pTO.tpr_data_aula); command.Parameters.AddWithValue("@tpr_horas_inicial", pTO.tpr_horas_inicial); command.Parameters.AddWithValue("@tpr_horas_final", pTO.tpr_horas_final); command.Parameters.AddWithValue("@tur_codigo", pTO.TurmaTO.tur_codigo); command.ExecuteNonQuery(); retorno = true; } catch (Exception) { throw; } finally { command.Dispose(); connection.Close(); connection.Dispose(); } return(retorno); }
public bool Save(TurmaProgramacao_TO pTO, bool novo) { bool retorno = false; try { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { if (novo) { if (new TurmaProgramacao_DAO().Save(pTO)) { string condicao = string.Format(" AND turma.tur_codigo = {0}", pTO.TurmaTO.tur_codigo); List <Matricula_TO> ListMatriculaTO = new Matricula_DAO().SearchAll(condicao); foreach (Matricula_TO mat in ListMatriculaTO) { Chamada_TO ChamadaTO = new Chamada_TO(); ChamadaTO.MatriculaTO = mat; ChamadaTO.TurmaProgramacaoTO = pTO; retorno = new Chamada_DAO().Save(ChamadaTO); } } } else { retorno = new TurmaProgramacao_DAO().Update(pTO); } if (retorno) { ts.Complete(); } else { ts.Dispose(); } } } catch (Exception) { throw; } return(retorno); }
internal bool Delete(TurmaProgramacao_TO pTO) { SqlConnection connection = null; try { connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]); connection.Open(); } catch (Exception) { throw; } SqlCommand command = null; bool retorno = false; string sql = "DELETE FROM chamada WHERE tpr_codigo = @tpr_codigo"; try { command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@tpr_codigo", pTO.tpr_codigo); command.ExecuteNonQuery(); retorno = true; } catch (Exception) { throw; } finally { command.Dispose(); connection.Close(); connection.Dispose(); } return(retorno); }
internal List <TurmaProgramacao_TO> SearchAll(string pCondicao) { SqlConnection connection = null; try { connection = new SqlConnection(ConfigurationSettings.AppSettings["conn_bdvveasycomp"]); connection.Open(); } catch (Exception) { throw; } SqlCommand command = null; SqlDataReader reader = null; string sql = "SELECT tpr_codigo " + " ,tpr_data_aula " + " ,tpr_horas_inicial " + " ,tpr_horas_final " + " ,tur_nome " + " ,cur_nome " + "FROM turma_programacao " + "INNER JOIN turma ON turma.tur_codigo = turma_programacao.tur_codigo " + "INNER JOIN curso ON curso.cur_codigo = turma.cur_codigo "; List <TurmaProgramacao_TO> collection = new List <TurmaProgramacao_TO>(); try { command = new SqlCommand(sql, connection); reader = command.ExecuteReader(); while (reader.Read()) { TurmaProgramacao_TO TurmaProgramacaoTO = new TurmaProgramacao_TO(); TurmaProgramacaoTO.tpr_codigo = Convert.ToInt32(reader["tpr_codigo"]); TurmaProgramacaoTO.tpr_data_aula = Convert.ToDateTime(reader["tpr_data_aula"]); TurmaProgramacaoTO.tpr_horas_inicial = Convert.ToString(reader["tpr_horas_inicial"]); TurmaProgramacaoTO.tpr_horas_final = Convert.ToString(reader["tpr_horas_final"]); TurmaProgramacaoTO.TurmaTO = new Turma_TO(); //TurmaProgramacaoTO.TurmaTO.tur_codigo = Convert.ToInt32(reader["tur_codigo"]); TurmaProgramacaoTO.TurmaTO.tur_nome = Convert.ToString(reader["tur_nome"]); TurmaProgramacaoTO.TurmaTO.CursoTO = new Curso_TO(); TurmaProgramacaoTO.TurmaTO.CursoTO.cur_nome = Convert.ToString(reader["cur_nome"]); collection.Add(TurmaProgramacaoTO); } } catch (Exception) { throw; } finally { reader.Close(); command.Dispose(); connection.Close(); connection.Dispose(); } return(collection); }