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); }