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