// consulta reuniao
public DataTable ConsultaReuniao(DReuniao Reuniao)
{
DataTable dtResultado = new DataTable("tbReunioes");
SqlConnection sqlCon = new SqlConnection();
try
{
sqlCon.ConnectionString = Conexao.Cn;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandText = "consultaReuniao";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter parAssunto = new SqlParameter();
parAssunto.ParameterName = "@assunto";
parAssunto.SqlDbType = SqlDbType.VarChar;
parAssunto.Size = 50;
parAssunto.Value = Reuniao.Assunto;
sqlCmd.Parameters.Add(parAssunto);
SqlDataAdapter sqlDat = new SqlDataAdapter(sqlCmd);
sqlDat.Fill(dtResultado);
}
catch (Exception)
{
dtResultado = null;
}
return dtResultado;
}
// Cancelar Reuniao
public static string ExcluirReuniao(int idReuniao)
{
DReuniao Obj = new CamadaDados.DReuniao();
Obj.IdReunioes = idReuniao;
return(Obj.CancelarReuniao(Obj));
}
// cancelar / excluir reuniao
public string CancelarReuniao(DReuniao Reuniao)
{
string resp = "";
SqlConnection sqlCon = new SqlConnection();
try
{
//codigo
sqlCon.ConnectionString = Conexao.Cn;
sqlCon.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandText = "cancelarReuniao";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter parIdReuniao = new SqlParameter();
parIdReuniao.ParameterName = "@idReuniao";
parIdReuniao.SqlDbType = SqlDbType.Int;
parIdReuniao.Value = Reuniao.IdReunioes;
sqlCmd.Parameters.Add(parIdReuniao);
//executar comando
resp = sqlCmd.ExecuteNonQuery() == 1 ? "Reuniao excluido" : "Reuniao não excluido";
}
catch (Exception ex)
{
resp = ex.Message;
}
finally
{
if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();
}
return resp;
}
//Agendar Reunião
public string AgendaReuniao(DReuniao Reuniao)
{
string resp = "";
SqlConnection sqlCon = new SqlConnection();
try
{
//codigo
sqlCon.ConnectionString = Conexao.Cn;
sqlCon.Open();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandText = "agendaReuniao";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter parIdMorador = new SqlParameter();
parIdMorador.ParameterName = "@idReuniao";
parIdMorador.SqlDbType = SqlDbType.Int;
parIdMorador.Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add(parIdMorador);
SqlParameter parAssunto = new SqlParameter();
parAssunto.ParameterName = "@assunto";
parAssunto.SqlDbType = SqlDbType.VarChar;
parAssunto.Size = 50;
parAssunto.Value = Reuniao.Assunto;
sqlCmd.Parameters.Add(parAssunto);
SqlParameter parInfo = new SqlParameter();
parInfo.ParameterName = "@informacoes";
parInfo.SqlDbType = SqlDbType.VarChar;
parInfo.Size = 250;
parInfo.Value = Reuniao.Informacoes;
sqlCmd.Parameters.Add(parInfo);
SqlParameter parResponsavel = new SqlParameter();
parResponsavel.ParameterName = "@responsavel";
parResponsavel.SqlDbType = SqlDbType.VarChar;
parResponsavel.Size = 50;
parResponsavel.Value = Reuniao.Responsavel;
sqlCmd.Parameters.Add(parResponsavel);
SqlParameter parData = new SqlParameter();
parData.ParameterName = "@data";
parData.SqlDbType = SqlDbType.Date;
parData.Value = Reuniao.Data;
sqlCmd.Parameters.Add(parData);
//executar comando
resp = sqlCmd.ExecuteNonQuery() == 1 ? "Reuniao Inserido" : "Reuniao não inserido";
}
catch (Exception ex)
{
resp = ex.Message;
}
finally
{
if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();
}
return resp;
}