public PartMasterModel GetPartMasterModel()
{
PartMasterDataContext dbParts = new PartMasterDataContext();
//Part List
var partList = (from p in dbParts.Parts orderby p.supplier ascending select p).ToList();
//Part Filters
var filterSupplierList = (from s in partList
group s by new { s.suppliercode, s.supplier } into grp
select new Supplier(grp.Key.suppliercode.Trim(), grp.Key.supplier.Trim())).OrderBy(c => c.Name).ToList();
var filterTrimList = (from t in partList group t by new { t.trimcodeid, t.trim } into grp
select new Trim(int.Parse(grp.Key.trimcodeid.ToString()), grp.Key.trim.ToString().Trim())).OrderBy(c => c.Name).ToList();
var filterSideList = (from s in partList group s by new { s.sidecodeid, s.side } into grp
select new Side(int.Parse(grp.Key.sidecodeid.ToString()), grp.Key.side.Trim().ToString().Trim())).OrderBy(c => c.Name).ToList();
var filterBoundList = (from b in partList group b by new { b.boundcodeid, b.bound } into grp
select new Bound(int.Parse(grp.Key.boundcodeid.ToString()), grp.Key.bound.Trim().ToString().Trim())).OrderBy(c => c.Name).ToList();
var filterColourList = (from c in partList group c by new { c.colourcodeid, c.colour } into grp
select new Colour(int.Parse(grp.Key.colourcodeid.ToString()), grp.Key.colour.Trim().ToString().Trim())).OrderBy(c => c.Name).ToList();
var filterSeatRowList = (from r in partList group r by new { r.seatrowcodeid, r.seatrow } into grp
select new SeatRow(int.Parse(grp.Key.seatrowcodeid.ToString()), grp.Key.seatrow.Trim().ToString().Trim())).OrderBy(c => c.Name).ToList();
var filterProgramList = (from p in partList group p by new { p.program } into grp
select new Program(grp.Key.program.Trim().ToString().Trim())).OrderBy(c => c.Name).ToList();
DispositionFactory factory = new DispositionFactory();
var dispositionOptions = factory.GetDispositionOptions();
PartMasterModel model = new PartMasterModel
{
DispositionOptions = dispositionOptions,
Parts = partList,
Suppliers = filterSupplierList,
Trims = filterTrimList,
Sides = filterSideList,
Bounds = filterBoundList,
Colours = filterColourList,
SeatRows = filterSeatRowList,
Programs = filterProgramList,
};
return model;
}
public void InsertScrapTransactionBuffer(IEnumerable<DispositionTag> tags)
{
PartMasterDataContext dbPart = new PartMasterDataContext();
DispositionLabelMaker labelMaker = new DispositionLabelMaker();
foreach (var tag in tags)
{
string fromLocation = "WAREASSM";
string toLocation = "";
if (tag.Disposition.Transaction.Trim() == "TRANSFER")
toLocation = "HOLDASSM";
string reason = labelMaker.GetTrans4mReasonCode(tag);
dbPart.InsertTransactionBuffer(tag.Part.partno.Trim(), (short)tag.Disposition.Qty, tag.Disposition.Transaction.Trim(), reason.Trim(),
fromLocation, toLocation, "");
}
}
