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);
}
