public int getUltimaPaginaRubros(List <Rubro> rubros)
{
string query = "SELECT [TheBigBangQuery].[getUltimaLineaFiltroRubro](@table, @fechaActual)";
try
{
SqlCommand com = new SqlCommand(query);
DataTable table = new DataTable();
table.Columns.Add("rub_id", typeof(decimal));
foreach (Rubro r in rubros)
{
table.Rows.Add(r.id);
}
SqlParameter param = new SqlParameter("@table", SqlDbType.Structured);
param.TypeName = "[TheBigBangQuery].[RubrosList]";
param.Value = table;
com.Parameters.Add(param);
com.Parameters.AddWithValue("@fechaActual", Generals.getFecha());
return(DatabaseConection.executeParamFunction <int>(com));
}
catch (Exception e)
{
throw e;
}
}
public bool usuarioHabilitado(string usuario)
{
string query = "SELECT [TheBigBangQuery].[UsuarioHabilitado](@usuario)";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("@usuario", usuario);
int habilitado = DatabaseConection.executeParamFunction <int>(command);
return(habilitado == 1);
}
public bool usuarioValido(string usuario)
{
string query = "SELECT TheBigBangQuery.ExisteUsuario(@usuario)";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("@usuario", usuario);
int existe = DatabaseConection.executeParamFunction <int>(command);
return(existe == 1);
}
public int getUltimaPaginaFacturasPorEmpresa(int emprId)
{
string query = "SELECT [TheBigBangQuery].[getLastPaginaFacturasPorEmpresa](@idEmpresa)";
try
{
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("@idEmpresa", emprId);
return(DatabaseConection.executeParamFunction <int>(command));
}
catch (Exception ex) {
throw new DataNotFoundException("No se ha podido cargar la ultima pagina de facturas");
}
}
public int getUltimaPaginaDesc(string desc)
{
string query = "SELECT [TheBigBangQuery].[getUltimaLineaFiltroDesc](@desc, @fechaActual)";
try
{
SqlCommand com = new SqlCommand(query);
com.Parameters.AddWithValue("@desc", desc);
com.Parameters.AddWithValue("@fechaActual", Generals.getFecha());
return(DatabaseConection.executeParamFunction <int>(com));
}
catch (Exception e) {
throw e;
}
}
public decimal gerIdUbiPubi(int ubiId, int publiId)
{
string function = "SELECT [TheBigBangQuery].[getIdPubluUbi]('" + ubiId + "', '" + publiId + "')";
try
{
SqlCommand command = new SqlCommand(function);
command.CommandText = function;
return(DatabaseConection.executeParamFunction <decimal>(command));
}
catch (Exception e) {
throw new DataNotFoundException("No se ha encontrado una ubicacion para esta publicacion");
}
}
public int getUltimaPaginaFecha(DateTime fechaI, DateTime fechaF)
{
string query = "SELECT [TheBigBangQuery].[getUltimaPagFiltroFecha](@fechaI, @fechaF)";
try
{
SqlCommand com = new SqlCommand(query);
com.Parameters.AddWithValue("@fechaI", fechaI);
com.Parameters.AddWithValue("@fechaF", fechaF);
return(DatabaseConection.executeParamFunction <int>(com));
}
catch (Exception e) {
throw e;
}
}
public int getLastPaginaComprasCliente(int clieId)
{
string function = "SELECT [TheBigBangQuery].[getLastPaginaCompras](@clieId)";
try
{
SqlCommand command = new SqlCommand(function);
command.CommandText = function;
command.Parameters.AddWithValue("clieId", clieId);
return(DatabaseConection.executeParamFunction <int>(command));
}
catch (Exception e) {
throw new DataNotFoundException("No se ha podido encontrar la ultima pagina de compras");
}
}
public int getUlitimaPaginaNoFiltro(Nullable <int> empresaId = null)
{
string function = "SELECT [TheBigBangQuery].[getLastPaginaPublicacionesSinFiltro](@empresa,@fechaActual)";
try
{
SqlCommand command = new SqlCommand(function);
if (empresaId == null)
{
command.Parameters.AddWithValue("@empresa", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@empresa", (int)empresaId);
}
command.Parameters.AddWithValue("@fechaActual", Generals.getFecha());
return(DatabaseConection.executeParamFunction <int>(command));
}
catch (Exception e)
{
throw e;
}
}