public bool HasWebField()
{
var existField = false;
using (var ctx = new FisiotesContext())
{
// Chekeamos si existen los campos
var connection = ctx.Database.Connection;
var sql = @"SELECT * from medicamentos LIMIT 0,1;";
var command = connection.CreateCommand();
command.CommandText = sql;
connection.Open();
var reader = command.ExecuteReader();
var schemaTable = reader.GetSchemaTable();
foreach (DataRow row in schemaTable.Rows)
{
if (row[schemaTable.Columns["ColumnName"]].ToString()
.Equals("web", StringComparison.CurrentCultureIgnoreCase))
{
existField = true;
break;
}
}
connection.Close();
}
return(existField);
}
protected void CheckAndCreateFieldsTemplate(string sqlTable, string[] fields, string[] sqlAlter)
{
// Por defecto todos false
var existsFields = new bool[fields.Length];
using (var ctx = new FisiotesContext())
{
// Chekeamos si existen los campos
var connection = ctx.Database.Connection;
var sql = sqlTable;
var command = connection.CreateCommand();
command.CommandText = sql;
connection.Open();
var reader = command.ExecuteReader();
var schemaTable = reader.GetSchemaTable();
foreach (DataRow row in schemaTable.Rows)
{
// Verifcamos los campos en el schema
for (var i = 0; i < fields.Length; i++)
{
if (row[schemaTable.Columns["ColumnName"]].ToString().Equals(fields[i]))
{
existsFields[i] = true;
}
}
if (existsFields.All(x => x))
{
break;
}
}
connection.Close();
for (var i = 0; i < existsFields.Length; i++)
{
if (!existsFields[i])
{
ctx.Database.ExecuteSqlCommand(sqlAlter[i]);
}
}
}
}
public FaltasRepository(FisiotesContext ctx) : base(ctx)
{
}
public EncargosRepository(FisiotesContext ctx) : base(ctx)
{
}
public CategoriasRepository(FisiotesContext ctx) : base(ctx)
{
}
public ListasRepository(FisiotesContext ctx) : base(ctx)
{
DeArticulos = new ListasArticulosRepository(ctx);
}
public ClientesRepository(FisiotesContext ctx) : base(ctx)
{
}
public ListasArticulosRepository(FisiotesContext ctx) : base(ctx)
{
}
public EntregasRepository(FisiotesContext ctx) : base(ctx)
{
}
public PedidosRepository(FisiotesContext ctx) : base(ctx)
{
}
public HuecosRepository(FisiotesContext ctx) : base(ctx)
{
}
public PuntosPendientesRepository(FisiotesContext ctx) : base(ctx)
{
}
public MedicamentosRepository(FisiotesContext ctx) : base(ctx)
{
}
public FisiotesRepository(FisiotesContext ctx)
{
_ctx = ctx;
}
public SinonimosRepository(FisiotesContext ctx) : base(ctx)
{
}
public ConfiguracionesRepository(FisiotesContext ctx) : base(ctx)
{
}
