public ActionResult DeleteConfirmed(int id) { BomLevel1 bomLevel1 = db.BomLevel1s.Find(id); db.BomLevel1s.Remove(bomLevel1); db.SaveChanges(); return(RedirectToAction("Search")); }
public ActionResult Edit([Bind(Include = "BomLevel1Id,BomNo,UnitNo,DetailPn,Description,QtyPer,Qoh")] BomLevel1 bomLevel1) { if (ModelState.IsValid) { db.Entry(bomLevel1).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Search")); } return(View(bomLevel1)); }
public ActionResult Create([Bind(Include = "BomLevel1Id,BomNo,UnitNo,DetailPn,Description,QtyPer,Qoh")] BomLevel1 bomLevel1) { if (ModelState.IsValid) { db.BomLevel1s.Add(bomLevel1); db.SaveChanges(); return(RedirectToAction("Search")); } return(View("Search", bomLevel1)); //return View(bomLevel1); }
// GET: BomLevel1/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BomLevel1 bomLevel1 = db.BomLevel1s.Find(id); if (bomLevel1 == null) { return(HttpNotFound()); } return(View(bomLevel1)); }
public ActionResult ProcessBuild(DateTime builddate, int buildqty, string Pn, string WoNo, byte contractor) { //Initial boms to hold all current parts in bom table List <BomLevel1> boms = new List <BomLevel1>(); //put all parts in current bom table into an in memory list boms = db.BomLevel1s.ToList(); List <BomLevel1> selectboms = new List <BomLevel1>(); BomLevel1 dpn = new BomLevel1(); //create a list of parts in bom foreach (BomLevel1 a in boms) { if (a.UnitNo == Pn) { dpn.BomNo = a.BomNo; dpn.UnitNo = a.UnitNo; dpn.DetailPn = a.DetailPn; dpn.Description = a.Description; dpn.PurchaseMake = a.PurchaseMake; dpn.PartType = a.PartType; dpn.PartTypeDetail = a.PartTypeDetail; dpn.QtyPer = a.QtyPer; selectboms.Add(dpn); } } //Initialize build table to add built part into WoBuilds WoBuild build = new WoBuild(); //Initialize build table to subtract out level 1 parts in WoBuilds WoBuild takeout = new WoBuild(); //build the part and add it to WoBuilds if (boms.Any(i => i.UnitNo == Pn)) { //add the built part to be assembled //build.WoEnterDateTime = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time")); build.WoEnterDateTime = builddate; build.ContractorId = contractor; build.WoNo = WoNo; build.CustomerPn = Pn; build.Qty = buildqty; build.Notes = null; db.WoBuilds.Add(build); db.SaveChanges(); //take out parts that were used to build assembly foreach (BomLevel1 b in boms) { if (b.UnitNo == Pn) { //takeout.WoEnterDateTime = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time")); takeout.WoEnterDateTime = builddate; takeout.ContractorId = contractor; takeout.WoNo = WoNo; takeout.CustomerPn = b.DetailPn; takeout.Qty = (b.QtyPer * -buildqty); takeout.Notes = null; db.WoBuilds.Add(takeout); db.SaveChanges(); } } /* * //Initialize build table to subtract out level 2 (or other sublevel) parts in WoBuilds * WoBuild takeout1 = new WoBuild(); * * //take out sub part numbers * foreach (BomLevel1 c in boms) * { * * foreach (BomLevel1 d in selectboms) * { * * if (c.UnitNo == d.DetailPn) * { * //takeout1.WoEnterDateTime = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time")); * takeout1.WoEnterDateTime = builddate; * takeout1.ContractorId = contractor; * takeout1.WoNo = WoNo; * takeout1.CustomerPn = c.DetailPn; * takeout1.Qty = (c.QtyPer * -buildqty); * takeout1.Notes = null; * * db.WoBuilds.Add(takeout1); * db.SaveChanges(); * } * * } * }*/ return(null); } else { ViewBag.Message = "BOM does not exist. Please create."; return(null); } }