public ActionResult DeleteConfirmed(long id)
        {
            tblVariety tblvariety = db.tblVarieties.Find(id);

            db.tblVarieties.Remove(tblvariety);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "varietyId,name,sampleNumber,repUser,testDate,releaseStatus,resistance,storability,poundability,species,uniformity,stability,distinctness,value,activityId,locationId,userId,createdBy,createdDate,updatedBy,updatedDate")] tblVariety tblvariety)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tblvariety).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.activityId = new SelectList(db.tblActivities, "activityId", "name", tblvariety.activityId);
     return(View(tblvariety));
 }
        // GET: /Variety/Details/5
        public ActionResult Details(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblVariety tblvariety = db.tblVarieties.Find(id);

            if (tblvariety == null)
            {
                return(HttpNotFound());
            }
            return(View(tblvariety));
        }
        // GET: /Variety/Edit/5
        public ActionResult Edit(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblVariety tblvariety = db.tblVarieties.Find(id);

            if (tblvariety == null)
            {
                return(HttpNotFound());
            }
            ViewBag.activityId = new SelectList(db.tblActivities, "activityId", "name", tblvariety.activityId);
            return(View(tblvariety));
        }
Esempio n. 5
0
        private void SyncIncomingRecords(ChileMaterialsReceived received, tblLot tblLot, ICollection <tblVariety> varieties)
        {
            foreach (var incoming in tblLot.tblIncomings.ToList())
            {
                OldContext.tblIncomings.DeleteObject(incoming);
            }

            var treatment = OldContextHelper.GetTreatment(received);
            var varietyId = varieties.Select(v => v.VarietyID).DefaultIfEmpty(0).Max() + 1;

            foreach (var item in received.Items)
            {
                var packaging = OldContextHelper.GetPackaging(item.PackagingProduct);

                var variety = varieties.FirstOrDefault(v => v.Variety == item.ChileVariety);
                if (variety == null)
                {
                    variety = new tblVariety
                    {
                        VarietyID = varietyId++,
                        Variety   = item.ChileVariety,
                        EntryDate = DateTime.Now,
                        InActive  = false,
                        SortOrder = varietyId.ToString()
                    };
                    OldContextHelper.OldContext.tblVarieties.AddObject(variety);
                    varieties.Add(variety);
                }

                tblLot.tblIncomings.Add(new tblIncoming
                {
                    EmployeeID = tblLot.EmployeeID,
                    EntryDate  = tblLot.EntryDate.Value,

                    TTypeID    = (int?)(received.ChileMaterialsReceivedType == ChileMaterialsReceivedType.Dehydrated ? TransType.DeHy : TransType.Other),
                    Quantity   = item.Quantity,
                    TrtmtID    = treatment.TrtmtID,
                    Tote       = item.ToteKey,
                    VarietyID  = variety.VarietyID,
                    Company_IA = tblLot.Company_IA,
                    LocID      = item.Location.LocID.Value,
                    DehyLocale = item.GrowerCode,
                    PkgID      = packaging.PkgID,
                    NetWgt     = packaging.NetWgt,
                    TtlWgt     = item.Quantity * packaging.NetWgt
                });
            }
        }