public static void Login(object value1, object value2)
{
table = Executar.Reader("usp_buscar_{c}_login".Replace("{c}", Classe), value1, value2);
if (!table.Rows.Count.Equals(0))
{
ID = Convert.ToInt32(table.Rows[0]["id"]);
}
else
{
ID = 0;
}
}
public static DataTable All()
{
return(Executar.Reader("usp_listar_mensagens", Buscar.Usuario.ID, Buscar.Editor.ID));
}
public static DataTable Contatos()
{
return(Executar.Reader("usp_listar_mensagens_contatos", Buscar.Usuario.ID, Buscar.Usuario.Classe));
}
public static DataTable Finalizados()
{
return(Executar.Reader("usp_listar_agendamentos_finalizados", Buscar.Editor.CPF));
}
public static DataTable Datas()
{
return(Executar.Reader("usp_listar_agendamentos_datas", Buscar.Usuario.IsTecnico ? Buscar.Usuario.ID : 0));
}
public static DataTable PorCliente(int value1)
{
return(Executar.Reader("usp_listar_agendamentos_cliente", value1));
}
public static DataTable PorDia(object value1)
{
return(Executar.Reader("usp_listar_agendamentos", value1, (Buscar.Usuario.IsTecnico ? Buscar.Usuario.ID : 0)));
}
public static DataTable Tecnicos()
{
return(Executar.Reader("usp_listar_funcionarios_tecnicos", Buscar.Estabelecimento.CargoTecnico));
}
public static DataTable PorNome(object value1)
{
return(Executar.Reader("usp_listar_funcionarios", value1));
}
public static DataTable PorNome(object value1 = null)
{
return(Executar.Reader("usp_listar_clientes", value1));
}
public static DataTable Conversa(object value1)
{
return(Executar.Reader("usp_listar_mensagens", value1, Usuario.ID));
}
public static bool Overbooking(List <object> list, int id = 0, int startAt = 0)
{
table = Executar.Reader("usp_buscar_agendamento_overbook", list[startAt++], list[startAt++], list[startAt++], id);
return(table.Rows.Count.Equals(0));
}