public IEnumerable<TempBuffer> GetSequencingBuffer(SequencingStation station)
{
PartSequencingDataContext dbSeq = new PartSequencingDataContext();
MesDataContext dbMes = new MesDataContext();
SequencingDatabase db = new SequencingDatabase();
List<TempBuffer> lineBuffer = null;
string groupLine = station.SequencingLocation.LineGroup.Trim();
int lineId = station.Line.Id;
int locationId = station.SequencingLocation.Id;
if (station.SequencingLocation.ParentId == null)
{
lineBuffer = (from s in dbMes.IWS_SP_GetSequencingBufferByLineId(station.Line.Id)
select new TempBuffer
{
Group = groupLine,
ItemNumber = s.ItemNumber.Trim(),
ItemType = s.ItemType.Trim(),
JobId = (int)s.JobId,
OrderId = (int)s.OrderId,
OrderStatus = (int)s.OrderStatus,
Region = s.Region.Trim(),
LineId = (int)s.LineId,
OrderNumber = s.OrderNumber,
BuildDTM = s.BuildDTM == null ? "" : s.BuildDTM.Value.ToString("mm/dd/yyyy hh:mm:ss tt")
}).ToList();
}
else
{
lineBuffer = (from s in dbSeq.IWS_GetSequencingStationQueueByLocationId(locationId)
select new TempBuffer
{
ScheduleNum = (int)s.ScheduleNum,
BoxNum = (int)s.BoxNum,
OrderNumber = s.OrderNumber == null ? "" : s.OrderNumber.Trim(),
Group = groupLine,
ItemNumber = s.ItemNumber.Trim(),
ItemType = s.ItemType.Trim(),
JobId = (int)s.JobId,
OrderId = (int)s.OrderId,
OrderStatus = (int)s.OrderStatus,
Region = s.Region.Trim(),
LineId = lineId
}).ToList();
}
return lineBuffer;
}
public void DeleteMessageToken(int id)
{
SequencingDatabase db = new SequencingDatabase();
db.DeleteMessageTokenById(id);
}
public IEnumerable<SideBySide> SequencingTracking2StationsByLineId(int lineId, int seqId1, int seqId2)
{
SequencingDatabase db = new SequencingDatabase();
return db.GetSequencingTracking2StationsByLineId(lineId, seqId1, seqId2);
}
public void UpdateMessageToken([FromBody]MessageToken token)
{
SequencingDatabase db = new SequencingDatabase();
db.UpdateMessageToken(token);
}
public IEnumerable<MessageToken> MessageTokensByLineId(int id)
{
SequencingDatabase db = new SequencingDatabase();
var tokens = db.GetMessageTokensByLineId(id);
return tokens;
}
public IEnumerable<SequencingLocation> SequencingLocations()
{
SequencingDatabase db = new SequencingDatabase();
return db.GetSequencingLocations();
}
public IEnumerable<SequencingLocation> SequencingLocationsByType(string type)
{
SequencingDatabase db = new SequencingDatabase();
return db.GetSequencingLocationsByType(type);
}
public IEnumerable<Line> Lines()
{
SequencingDatabase db = new SequencingDatabase();
var lines = db.GetLines();
return lines;
}