protected virtual void Dispose(bool disposing)
{
if (!_disposed)
{
if (disposing)
{
_context.Dispose();
}
}
_disposed = true;
}
public void Dispose()
{
if (Context != null)
{
try
{
Context.Dispose();
}
catch { }
}
}
public int GetAllMaterialesCount()
{
int list = 0;
WarehouseEntities data = new WarehouseEntities();
try
{
var query = (from m in data.materiales select m).Count();
list = query;
data.Dispose();
}
catch (Exception e)
{
Console.Write("Excepción mientras se consultaban los materiales: " + e);
}
return(list);
}
public List <materiales> GetAllMateriales()
{
List <materiales> list = new List <materiales>();
WarehouseEntities data = new WarehouseEntities();
try
{
var query = data.materiales;
list = query.ToList();
data.Dispose();
}
catch (Exception e)
{
Console.Write("Excepción mientras se consultaban los materiales: " + e);
}
return(list);
}
public DateTime[] GetMinAndMaxDate()
{
DateTime[] list = new DateTime[2];
WarehouseEntities data = new WarehouseEntities();
try
{
var query = data.materiales;
list[0] = query.Max(x => x.fecha_salida);
list[1] = query.Min(x => x.fecha_salida);
data.Dispose();
}
catch (Exception e)
{
Console.Write("Excepción mientras se consultaban los materiales: " + e);
}
return(list);
}