Пример #1
0
        // GET: WoBuilds/Edit/5
        public ActionResult Edit(int?id)
        {
            ViewBag.ReturnUrl = Request.UrlReferrer;

            var wobuilds = db.WoBuilds.SingleOrDefault(c => c.WoBuildId == id);

            var contractors = db.Contractors.ToList();

            var viewModel = new WoBuildViewModel()
            {
                WoBuild     = wobuilds,
                Contractors = contractors
            };

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            WoBuild woBuild = db.WoBuilds.Find(id);

            if (woBuild == null)
            {
                return(HttpNotFound());
            }
            return(View("Edit", viewModel));
            //return View(woBuild);
        }
Пример #2
0
        public ActionResult DeleteConfirmed(int id)
        {
            WoBuild woBuild = db.WoBuilds.Find(id);

            db.WoBuilds.Remove(woBuild);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #3
0
 //public ActionResult Create([Bind(Include = "WoBuildId,WoEnterDateTime,WoNo,CustomerPn,Qty,Notes")] WoBuild woBuild)
 public ActionResult Create(WoBuild woBuild, string returnUrl)
 {
     if (ModelState.IsValid)
     {
         db.WoBuilds.Add(woBuild);
         db.SaveChanges();
         return(Redirect(returnUrl));
         //return RedirectToAction("Index");
     }
     return(View());
     //return View(woBuild);
 }
Пример #4
0
 //public ActionResult Edit([Bind(Include = "WoBuildId,WoEnterDateTime,WoNo,CustomerPn,Qty,Notes")] WoBuild woBuild)
 public ActionResult Edit(WoBuild woBuild, string returnUrl)
 {
     if (ModelState.IsValid)
     {
         db.Entry(woBuild).State = EntityState.Modified;
         db.SaveChanges();
         //return RedirectToAction("Index");
         return(Redirect(returnUrl));
     }
     //return View(woBuild);
     return(View());
 }
Пример #5
0
        // GET: WoBuilds/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            WoBuild woBuild = db.WoBuilds.Find(id);

            if (woBuild == null)
            {
                return(HttpNotFound());
            }
            return(View(woBuild));
        }
Пример #6
0
        // GET: WoBuilds/Delete/5
        public ActionResult Delete(int?id)
        {
            ViewBag.ReturnUrl = Request.UrlReferrer;
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            WoBuild woBuild = db.WoBuilds.Find(id);

            if (woBuild == null)
            {
                return(HttpNotFound());
            }
            return(View(woBuild));
        }
Пример #7
0
        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);
            }
        }