protected static AtributosConsultaCod[] AuxConsultasOcorrendoEmHorario(DateTime horarioRedondo, bool umaHora,
string emailMedico, string emailPaciente, ConexaoBD conexaoBD)
{
DateTime horarioConsultaDe1HAntes;
if (horarioRedondo.Minute == 0)
{
horarioConsultaDe1HAntes = new DateTime(horarioRedondo.Year, horarioRedondo.Month,
horarioRedondo.Day, horarioRedondo.Hour - 1, 30, 0);
}
else
{
horarioConsultaDe1HAntes = new DateTime(horarioRedondo.Year, horarioRedondo.Month,
horarioRedondo.Day, horarioRedondo.Hour, 0, 0);
}
string cmdSelect = "select codConsulta, proposito, horario, umaHora, observacoes, status, " +
"emailMedico, emailPac, satisfacao, comentario, horarioSatisfacao from consulta where ";
if (!String.IsNullOrEmpty(emailMedico))
{
cmdSelect += " emailMedico = '" + emailMedico + "' and ";
}
if (!String.IsNullOrEmpty(emailPaciente))
{
cmdSelect += " emailPac = '" + emailPaciente + "' and ";
}
cmdSelect += " (horario = '" + horarioRedondo + "' " +
" or (horario = '" + horarioConsultaDe1HAntes + "' and umaHora = 1)";
if (umaHora)
{
DateTime horarioConsultaDe1HoraDepois = new DateTime(horarioRedondo.Year, horarioRedondo.Month,
horarioRedondo.Day, (horarioRedondo.Minute == 0)?horarioRedondo.Hour:horarioRedondo.Hour + 1,
(horarioRedondo.Minute == 0)?30:0, 0);
cmdSelect += " or horario = '" + horarioConsultaDe1HoraDepois + "'";
}
cmdSelect += ")";
DataSet dadosConsulta = conexaoBD.ExecuteSelect(cmdSelect);
if (dadosConsulta.Tables[0].Rows.Count <= 0)
{
return(null);
}
AtributosConsultaCod[] atributosConsultas = new AtributosConsultaCod[dadosConsulta.Tables[0].Rows.Count];
for (int i = 0; i < dadosConsulta.Tables[0].Rows.Count; i++)
{
atributosConsultas[i] = Consulta.AtributosConsultaFromDataSet(dadosConsulta, i, conexaoBD);
}
return(atributosConsultas);
}
public static AtributosConsultaCod DeCodigo(int codConsulta, ConexaoBD conexaoBD)
{
DataSet dataSet = conexaoBD.ExecuteSelect("select codConsulta, proposito, horario, umaHora, observacoes, status, " +
"emailMedico, emailPac, satisfacao, comentario, horarioSatisfacao, medicoJahViuSatisfacao " +
"from consulta where codConsulta = " + codConsulta);
if (dataSet.Tables[0].Rows.Count != 1)
{
return(null);
}
AtributosConsultaCod atributos = Consulta.AtributosConsultaFromDataSet(dataSet, 0, conexaoBD);
return(atributos);
}
public object[,] PesquisarConsultas(string medico, string paciente, string data, int tipoData)
//0: consulta, 1: paciente, 2:medico
{
string cmd_s = "select c.codConsulta, c.proposito, c.horario, c.umaHora, c.observacoes, c.status, " +
"c.emailMedico, c.emailPac, c.satisfacao, c.comentario, c.horarioSatisfacao, c.medicoJahViuSatisfacao, " +
"m.nomeCompleto, p.nomeCompleto from " +
"consulta as c, " +
"medico as m, " +
"paciente as p " +
"where " +
"c.emailMedico = m.email and " +
"m.nomeCompleto like '%" + medico + "%' and " +
"c.emailPac = p.email and " +
"p.nomeCompleto like '%" + paciente + "%' ";
if (!String.IsNullOrEmpty(data))
{
cmd_s += " and ";
if (tipoData < 0)
{
cmd_s += " c.horario <";
}
else
if (tipoData > 0)
{
cmd_s += " c.horario >";
}
else
{
cmd_s += " CONVERT(VARCHAR(10), c.horario, 103) = "; // dd/mm/yyyy
}
cmd_s += "'" + data + "'";
}
cmd_s += " order by c.horario desc";
DataSet ds = this.conexaoBD.ExecuteSelect(cmd_s);
object[,] ret = new object[ds.Tables[0].Rows.Count, 3];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ret[i, 0] = Consulta.AtributosConsultaFromDataSet(ds, i, this.conexaoBD);
ret[i, 1] = (string)ds.Tables[0].Rows[i].ItemArray[13];
ret[i, 2] = (string)ds.Tables[0].Rows[i].ItemArray[12];
}
return(ret);
}
public static AtributosConsultaCod[] TodasAsConsultas(ConexaoBD conexaoBD)
{
DataSet dataSet = conexaoBD.ExecuteSelect("select codConsulta, proposito, horario, umaHora, observacoes, status, " +
"emailMedico, emailPac, satisfacao, comentario, horarioSatisfacao, medicoJahViuSatisfacao from consulta " +
"order by horario desc");
if (dataSet.Tables[0].Rows.Count <= 0)
{
return(null);
}
AtributosConsultaCod[] atributos = new AtributosConsultaCod[dataSet.Tables[0].Rows.Count];
for (int i = 0; i < atributos.Length; i++)
{
atributos[i] = Consulta.AtributosConsultaFromDataSet(dataSet, i, conexaoBD);
}
return(atributos);
}
public static AtributosConsultaCod[] ConsultasDe(string email, bool ehMedico, bool ordenarPorSatisfacao, ConexaoBD conexaoBD)
{
DataSet dataSet = conexaoBD.ExecuteSelect("select codConsulta, proposito, horario, umaHora, observacoes, status, " +
"emailMedico, emailPac, satisfacao, comentario, horarioSatisfacao, medicoJahViuSatisfacao from consulta " +
"where " + (ehMedico?"emailMedico":"emailPac") + " = '" + email + "' order by "
+ (ordenarPorSatisfacao? "horarioSatisfacao" : "horario") + " desc");
if (dataSet.Tables[0].Rows.Count <= 0)
{
return(null);
}
AtributosConsultaCod[] atributos = new AtributosConsultaCod[dataSet.Tables[0].Rows.Count];
for (int i = 0; i < atributos.Length; i++)
{
atributos[i] = Consulta.AtributosConsultaFromDataSet(dataSet, i, conexaoBD);
}
return(atributos);
}
