public void EKanbanDevices() { using (var context = new EKanbanTaskContext(Database)) { if (context.Database.Exists()) { return; } context.Database.Create(); for (int i = 1; i <= 40; i++) { context.EKanbanDevices.Add(new EKanbanDevice { Name = $"Cart{i}", Building_Id = 1, PropductionLine_Id = i / 5 + 1, }); context.SaveChanges(); } try { context.Database.ExecuteSqlCommand("DROP TABLE [__MigrationHistory]"); context.SaveChanges(); } catch { } } }
public EKanbanDevice GetEKanbanDevice(string _ekanbanDeviceName) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanDevices.Where(i => i.Name == _ekanbanDeviceName).First()); } } catch { return(null); } }
public EKanbanDevice GetEKanbanDevice(int _ekanbanDeviceId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanDevices.Find(_ekanbanDeviceId)); } } catch { return(null); } }
public bool AddNewEKanbanLoading(EKanbanLoading _ekanbanLoading) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { EKanbanTaskContext.EKanbanLoadings.Add(_ekanbanLoading); EKanbanTaskContext.SaveChanges(); } return(true); } catch { return(false); } }
public ICollection <EKanbanLoading> GetEKanbanLoadingByPo(int _originalPoId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanLoadings .Where(i => i.OriginalPo_Id == _originalPoId) .ToList()); } } catch { return(null); } }
public EKanbanLoading GetEKanbanLoadingBySequence(int _originalSequenceId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanLoadings .Where(i => i.OriginalSequence_Id == _originalSequenceId) .First()); } } catch { return(null); } }
public ICollection <EKanbanDevice> GetEKanbanDevicesByBuilding(int _buildingId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanDevices .Where(i => i.Building_Id == _buildingId) .ToList()); } } catch { return(null); } }
public ICollection <EKanbanDevice> GetEKanbanDevicesByProductionLine(int _productionLineId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanDevices .Where(i => i.PropductionLine_Id == _productionLineId) .ToList()); } } catch { return(null); } }
public bool UpdateEKanbanLoading(EKanbanLoading _ekanbanLoading) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { EKanbanTaskContext.Entry(_ekanbanLoading).State = EntityState.Modified; EKanbanTaskContext.SaveChanges(); } return(true); } catch { return(false); } }
public bool AddNewEKanbanComponent(EKanbanComponent _ekanbanComponent) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { EKanbanTaskContext.EkanbanComponents.Add(_ekanbanComponent); EKanbanTaskContext.SaveChanges(); } return(true); } catch { return(false); } }
public ICollection <EKanbanInterface> GetEKanbanInterfaces(int _ekanbanDeviceId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanInterfaces .Where(i => i.EKanbanDevice_Id == _ekanbanDeviceId) .ToList()); } } catch { return(null); } }
public EKanbanLoading GetEKanbanLoading(int _ekanbanLoadingId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanLoadings .Where(i => i.id == _ekanbanLoadingId) .First()); } } catch { return(null); } }
public bool DeleteEKanbanInterface(EKanbanInterface _ekanbanInterface) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { var EKanban = EKanbanTaskContext.EKanbanInterfaces.Find(_ekanbanInterface.id); EKanbanTaskContext.Entry(EKanban).State = EntityState.Deleted; EKanbanTaskContext.SaveChanges(); return(true); } } catch { return(false); } }
public bool DeleteEKanbanLoading(EKanbanLoading _ekanbanLoading) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { EKanbanTaskContext.EKanbanLoadings.Attach(_ekanbanLoading); EKanbanTaskContext.Entry(_ekanbanLoading).State = EntityState.Deleted; EKanbanTaskContext.SaveChanges(); return(true); } } catch { return(false); } }
public EKanbanInterface GetEKanbanInterface(int _ekanbanInterfaceId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { return(EKanbanTaskContext.EKanbanInterfaces .Include("EKanbanLoadings") .Include("EkanbanComponents") .Where(i => i.id == _ekanbanInterfaceId) .First()); } } catch { return(null); } }
public ICollection <EKanbanComponent> GetEKanbanComponent(int _ekanbanInterfaceId) { try { using (EKanbanTaskContext = new EKanbanTaskContext(database)) { var ekanbanInterface = EKanbanTaskContext.EKanbanInterfaces. Include("") .Where(i => i.id == _ekanbanInterfaceId) .First(); return(ekanbanInterface.EkanbanComponents); } } catch { return(null); } }