public void BeamCutDevices()
{
using (var context = new BeamCutContext(Database))
{
if (context.Database.Exists())
{
Console.WriteLine("BeamCutContext is existing");
return;
}
context.Database.Create();
Console.WriteLine("BeamCutContext is created successfully");
for (int i = 1; i <= 10; i++)
{
context.BeamCutDevices.Add(new BeamCutDevice
{
Building_Id = 1,
Name = $"BC{i}",
});
context.SaveChanges();
}
try
{
context.Database.ExecuteSqlCommand("DROP TABLE [__MigrationHistory]");
context.SaveChanges();
}
catch { }
}
}
public ICollection <BDeviceOrder> MoveOrder(BDeviceOrder _order, int moveType = 1)// 2 : move down
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var order = BeamCutContext.BDeviceOrders.Find(_order.id);
int oldPlace = ShareFuncs.GetInt(order.Place);
BDeviceOrder changeOrder = new BDeviceOrder();
switch (moveType)
{
case 2: //move down
var porder1 = BeamCutContext.BDeviceOrders.Where(i => i.Place == oldPlace + 1);
if (porder1.Count() > 0)
{
changeOrder = porder1.First();
}
else
{
return(null);
}
break;
default: // move up
int place = oldPlace >= 0 ? oldPlace - 1 : 0;
if (place < 0)
{
place = 0;
}
var porder2 = BeamCutContext.BDeviceOrders.Where(i => i.Place == place);
if (porder2.Count() > 0)
{
changeOrder = porder2.First();
}
else
{
return(null);
}
break;
}
order.Place = changeOrder.Place;
BeamCutContext.Entry(order).State = System.Data.Entity.EntityState.Modified;
BeamCutContext.SaveChanges();
changeOrder.Place = oldPlace;
BeamCutContext.Entry(changeOrder).State = System.Data.Entity.EntityState.Modified;
BeamCutContext.SaveChanges();
string date = DateTime.Now.ToString("dd/MM/yyyy");
return(BeamCutContext.BDeviceOrders.Where(i => i.Date == date).OrderBy(i => i.Place).ToList());
}
}
catch { return(null); }
}
public ICollection <BDeviceOrder> AddNewOrder(BDeviceOrder BDeviceOrder)
{
try
{
var orders = GetBDeviceOrders(ShareFuncs.GetInt(BDeviceOrder.BeamCutDevice_Id));
int place = 0;
if (orders != null)
{
var temp = orders.OrderByDescending(i => i.Place);
if (temp.Count() > 0)
{
place = ShareFuncs.GetInt(temp.First().Place) + 1;
}
else
{
place = 0;
}
}
else
{
place = 0;
}
BDeviceOrder.Place = place;
using (BeamCutContext = new BeamCutContext(database))
{
BeamCutContext.BDeviceOrders.Add(BDeviceOrder);
BeamCutContext.SaveChanges();
}
return(GetBDeviceOrders(ShareFuncs.GetInt(BDeviceOrder.BeamCutDevice_Id)));
}
catch { return(null); }
}
public bool UpdateBeamSize(BeamCutSize beamCutSize)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
BeamCutContext.Entry(beamCutSize).State = EntityState.Modified;
BeamCutContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public BeamCutInterface AddNewBeamCutInterface(BeamCutInterface binterface)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutInterfaces.Add(binterface);
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public ICollection <BDeviceOrder> DeleteOrder(BDeviceOrder _order)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
string date = _order.Date;
var order = BeamCutContext.BDeviceOrders.Find(_order.id);
BeamCutContext.BDeviceOrders.Remove(order);
BeamCutContext.SaveChanges();
return(BeamCutContext.BDeviceOrders.Where(i => i.Date == date).ToList());
}
}
catch { return(null); }
}
public bool UpdateBStatistic(BMachineStatistic statistic)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var current = BeamCutContext.BMachineStatistices.Find(statistic.id);
current.TotalCutQty = statistic.TotalCutQty;
current.TotalCuttime = statistic.TotalCuttime;
BeamCutContext.Entry(current).State = EntityState.Modified;
BeamCutContext.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public BeamCutPo AddNewBeamCutPo(int originalPoId, int componentId)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutPos.Add(new BeamCutPo
{
OriginalPo_Id = originalPoId,
Component_Id = componentId
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public BMachineStatistic AddNewBcutStatistic(int bmachineId, DateTime date)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BMachineStatistices.Add(new BMachineStatistic
{
BeamCutDevice_Id = bmachineId,
Date = date.ToString("dd/MM/yyyy"),
TotalCutQty = 0,
TotalCuttime = 0,
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public BeamCutSeq AddNewBeamSeq(OriginalPOsequence originalPOsequence, int componentId, int BeamCutPoId)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutSeqs.Add(new BeamCutSeq
{
OriginalPo_Id = originalPOsequence.OriginalPO_Id,
Component_Id = componentId,
BeamCutPo_Id = BeamCutPoId,
SequenceNo = originalPOsequence.SequenceNo,
SequenceQty = originalPOsequence.Quantity,
Finish = false,
CutQty = 0,
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public BeamCutSize AddNewBeamSize(OriginalSize size, int beamCutSeqId, int seqNo, int componentId, int beamCutPoId)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutSizes.Add(new BeamCutSize
{
BeamCutPo_Id = beamCutPoId,
Component_Id = componentId,
BeamCutSeq_Id = beamCutSeqId,
CutQty = 0,
SequenceNo = seqNo,
Finished = false,
SizeId = size.SizeId,
SizeQty = size.Quantity,
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public BeamCutPo AddNewBeamCutPo(OriginalPO originalPo, ShoeComponent shoeComponent)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
var result = BeamCutContext.BeamCutPos.Add(new BeamCutPo
{
OriginalPo_Id = originalPo.id,
PoNumber = originalPo.PoNumber,
PoQuantity = ShareFuncs.GetInt(originalPo.Quantity),
ProductionLine_Id = ShareFuncs.GetInt(originalPo.ProductionLine_Id),
Finish = false,
CuttingQuantity = 0,
ComponentRef = shoeComponent.Reference,
Component_Id = shoeComponent.Id
});
BeamCutContext.SaveChanges();
return(result);
}
}
catch { return(null); }
}
public bool AddNewBCutTimeRecord(BDeviceCutTimeRecord record)
{
try
{
using (BeamCutContext = new BeamCutContext(database))
{
string datetime = DateTime.Now.ToString("dd/MM/yyyy");
var statistic = BeamCutContext.BMachineStatistices
.Where(i => i.BeamCutDevice_Id == record.BeamCutDevice_Id && i.Date == datetime)
.First();
if (statistic == null)
{
return(false);
}
statistic.BDeviceCutTimeRecords = new List <BDeviceCutTimeRecord>(new BDeviceCutTimeRecord[]
{
new BDeviceCutTimeRecord
{
BeamCutDevice_Id = record.BeamCutDevice_Id,
BMachineStatistic_Id = statistic.id,
TotalCutTime = record.TotalCutTime,
ConfirmQuantity = record.ConfirmQuantity,
}
});
statistic.TotalCuttime += record.TotalCutTime;
statistic.StopTime = DateTime.Now;
BeamCutContext.BMachineStatistices.Attach(statistic);
BeamCutContext.Entry(statistic).State = EntityState.Modified;
BeamCutContext.SaveChanges();
return(true);
}
}
catch (Exception e)
{ return(false); }
}
