public void Add(CurrentRawMaterialDTO dto)
 {
     try
     {
         using (var context = new TPOMVCApplicationEntities())
         {
             var newEntity = new TPOCurrentRawMaterial();
             newEntity.RawMaterialReceivedID = dto.RawMaterialReceivedId;
             newEntity.LineID              = dto.LineId;
             newEntity.PlantID             = dto.PlantId;
             newEntity.DateEntered         = dto.DateEntered;
             newEntity.EnteredBy           = dto.EnteredBy;
             newEntity.ModifiedBy          = dto.ModifiedBy;
             newEntity.LastModified        = dto.LastModified;
             newEntity.Plant               = context.Plants.Where(p => p.ID == dto.PlantId).FirstOrDefault();
             newEntity.RawMaterialReceived =
                 context.RawMaterialReceiveds.Where(m => m.ID == dto.RawMaterialReceivedId).FirstOrDefault();
             context.TPOCurrentRawMaterials.Add(newEntity);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
Exemplo n.º 2
0
        public ActionResult Scrim()
        {
            TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();

            ViewBag.RawMaterial = new SelectList(db.ScrimRolls, "ID", "Code");
            return(View());
        }
 public CurrentRawMaterialDTO GetById(int id)
 {
     using (var context = new TPOMVCApplicationEntities())
     {
         var thisItem = (from a in context.TPOCurrentRawMaterials
                         where a.ID == id
                         select a);
         return(thisItem.Any() ? MapToDTO(thisItem.FirstOrDefault()) : null);
     }
 }
 public RawMaterialQCRedHoldDTO GetByQCID(int id)
 {
     using (var context = new TPOMVCApplicationEntities())
     {
         var thisItem = (from a in context.RawMaterialQCRedHolds
                         where a.RawMaterialQCID == id
                         select a);
         return(thisItem.Any() ? MapToDTO(thisItem.FirstOrDefault()) : null);
     }
 }
        public List <CurrentRawMaterialDTO> GetAll()
        {
            using (var context = new TPOMVCApplicationEntities())
            {
                var allItems = (from a in context.TPOCurrentRawMaterials
                                select a);

                return(CreateList(allItems));
            }
        }
        public List <CurrentRawMaterialDTO> GetAll(int plantId, string lineId)
        {
            using (var context = new TPOMVCApplicationEntities())
            {
                var allItems = (from a in context.TPOCurrentRawMaterials
                                where a.PlantID == plantId &&
                                a.LineID == lineId
                                select a);

                return(CreateList(allItems));
            }
        }
        public int Add(RawMaterialQCRedHoldDTO dto)
        {
            int returnID = -1;

            try
            {
                using (var context = new TPOMVCApplicationEntities())
                {
                    var newEntity = new TPO.DL.Models.RawMaterialQCRedHold();
                    newEntity.RawMaterialQCID       = dto.RawMaterialQCID;
                    newEntity.PlantID               = dto.PlantID;
                    newEntity.RawMaterialReceivedID = dto.RawMaterialReceivedID;
                    newEntity.QCTechID              = dto.QCTechID;
                    newEntity.SupervisorID          = dto.SupervisorID;
                    newEntity.LeadOperatorID        = dto.LeadOperatorID;
                    newEntity.RedDate               = dto.RedDate;
                    newEntity.FailPropertyID        = dto.FailPropertyID;
                    newEntity.Zone                = dto.Zone;
                    newEntity.RedComments         = dto.RedComments;
                    newEntity.RedCorrectionAction = dto.RedCorrectionAction;
                    newEntity.HoldDate            = dto.HoldDate;
                    newEntity.HoldLotNumber       = dto.HoldLotNumber;
                    newEntity.HoldComments        = dto.HoldComments;
                    newEntity.ManagerID           = dto.ManagerID;
                    newEntity.ManagerDate         = dto.ManagerDate;
                    newEntity.ManagerComments     = dto.ManagerComments;
                    newEntity.PrimeBoxCar         = dto.PrimeBoxCar;
                    newEntity.PrimeUOM            = dto.PrimeUOM;
                    newEntity.ReworkBoxCar        = dto.ReworkBoxCar;
                    newEntity.ReworkUOM           = dto.ReworkUOM;
                    newEntity.ScrapBoxCar         = dto.ScrapBoxCar;
                    newEntity.ScrapUOM            = dto.ScrapUOM;
                    newEntity.DateEntered         = dto.DateEntered ?? DateTime.Now;
                    newEntity.EnteredBy           = dto.EnteredBy;
                    newEntity.LastModified        = dto.LastModified ?? DateTime.Now;
                    newEntity.ModifiedBy          = dto.ModifiedBy;
                    context.RawMaterialQCRedHolds.Add(newEntity);
                    context.SaveChanges();
                    //need to return the new record id
                    //easy to do once we update to stored procs
                    returnID = newEntity.ID;
                }
            }
            catch (DbEntityValidationException ex)
            {
                throw;
            }
            return(returnID);
        }
 public void Delete(int id)
 {
     try {
         using (var context = new TPOMVCApplicationEntities())
         {
             var toDelete = context.RawMaterialQCRedHolds.Find(id);
             context.RawMaterialQCRedHolds.Remove(toDelete);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
Exemplo n.º 9
0
        public void Update(RawMaterialQCSpecificGravityDTO dto)
        {
            try
            {
                using (var context = new TPOMVCApplicationEntities())
                {
                    // Save Specific gravity
                    var toUpdate = context.RawMaterialSpecificGravities.Find(dto.ID);
                    toUpdate.RawMaterialQCID = dto.RawMaterialQCID;
                    toUpdate.LabTechUserID   = dto.LabTechUserID;
                    toUpdate.DenIso          = dto.DenIso;

                    toUpdate.DateEntered = dto.DateEntered ?? DateTime.Now;
                    toUpdate.EnteredBy   = dto.EnteredBy;

                    toUpdate.ModifiedBy   = dto.ModifiedBy;
                    toUpdate.LastModified = DateTime.Now;

                    context.Entry(toUpdate).State = EntityState.Modified;

                    foreach (var detail in toUpdate.RawMaterialSpecificGravityDetails)
                    {
                        var dtoDetail = dto.RawMaterialSpecificGravityDetails.Where(d => d.ID == detail.ID);
                        if (dtoDetail.Any())
                        {
                            detail.Value        = dtoDetail.First().Value;
                            detail.LastModified = DateTime.Now;
                        }
                    }

                    // TODO: Details

                    // Set Specific Gravity on Parent QC record.
                    RawMaterialQC toUpdateRawMaterialQC = context.RawMaterialQCs.Find(dto.RawMaterialQCID);
                    toUpdateRawMaterialQC.SpecGrav             = dto.AverageGravity;
                    context.Entry(toUpdateRawMaterialQC).State = EntityState.Modified;

                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
        // GET: /RawMaterialQC/LotID
        public ActionResult GetTestIDs(int ID)
        {
            TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();

            db.Configuration.ProxyCreationEnabled = false;

            var testRecords =
                db.RawMaterialQCs.Where(x => x.RawMaterialReceivedID == ID)
                .OrderByDescending(x => x.DateEntered)
                .ToList();


            List <TPO.DL.Models.RawMaterialQC> list = new List <TPO.DL.Models.RawMaterialQC>();

            list.AddRange(testRecords);

            return(Json(list));
        }
        //// GET: /RawMaterialQC/LotID
        //public ActionResult GetTestIDs(int ID)
        //{
        //    List<SelectListItem> testItems = new List<SelectListItem>();
        //    TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
        //    var testRecords =
        //        db.RawMaterialQCs.Where(x => x.RawMaterialReceivedID == ID)
        //            .OrderByDescending(x => x.DateEntered)
        //            .ToList();

        //    if (testRecords.Count > 0)
        //    {
        //        testItems.Add(new SelectListItem {Value = "", Text = "-- Select Test --"});
        //    }
        //    else
        //    {
        //        testItems.Add(new SelectListItem {Value = "", Text = "-- No Tests for Lot: " + ID + " --"});
        //    }
        //    foreach (var item in testRecords)
        //    {
        //        testItems.Add(new SelectListItem
        //        {
        //            Value = item.ID.ToString(),
        //            Text = item.DateEntered.ToString("MM/dd/yy hh:mm") + " | " + item.BoxCarTested
        //        });
        //    }
        //    return Json(testItems);
        //}

        public ActionResult Create(string rm = "", string lot = "")
        {
            TPO.BL.Security.User userBL = new TPO.BL.Security.User();
            ViewBag.QCTech = new SelectList(userBL.GetQCTechUsers(), "ID", "FullName");

            TPO.Model.RawMaterials.RawMaterialQCModel model = new TPO.Model.RawMaterials.RawMaterialQCModel();
            int tmpRawMaterialReceivedId = 0;

            if (!int.TryParse(lot, out tmpRawMaterialReceivedId))
            {
                tmpRawMaterialReceivedId = 0;
            }
            model.RawMaterialReceivedID = tmpRawMaterialReceivedId;
            TPO.DL.Models.RawMaterialReceived rawMaterialLookup =
                new TPOMVCApplicationEntities().RawMaterialQCs.Where(
                    w => w.RawMaterialReceivedID == tmpRawMaterialReceivedId).First().RawMaterialReceived;
            if (rawMaterialLookup == null)
            {
                TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord);
                //string.Format("Raw Material Test configuration not found for raw material {0}.", rm);
                TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError);
                return(RedirectToAction("Index"));
                //return HttpNotFound(string.Format("Raw Material Test configuration not found for raw material {0}.", rm));
            }
            model.RawMaterialCode = rawMaterialLookup.RawMaterial.Code;
            model.LotCode         = rawMaterialLookup.LotNumber;
            model.QCTechID        = CurrentUserID;
            TPO.BL.RawMaterials.RawMaterialTest rmtBL = new TPO.BL.RawMaterials.RawMaterialTest();
            model.QCConfiguration = rmtBL.GetQCConfigurationByRawMaterial(tmpRawMaterialReceivedId);
            if (model.QCConfiguration == null)
            {
                TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord);
                //string.Format("Raw Material Test configuration not found for raw material {0}.", rm);
                TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError);
                return(RedirectToAction("Index"));
                //return HttpNotFound(string.Format("Raw Material Test configuration not found for raw material {0}.", rm));
            }
            TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
            model = qcBL.InsertRawMaterialQCModel(model);
            model.LastModified = DateTime.Now;
            // return View(model);
            return(RedirectToAction("Edit", new { id = model.ID }));
        }
 public void Update(RawMaterialQCRedHoldDTO dto)
 {
     try
     {
         using (var context = new TPOMVCApplicationEntities())
         {
             var toUpdate = context.RawMaterialQCRedHolds.Find(dto.ID);
             toUpdate.RawMaterialQCID       = dto.RawMaterialQCID;
             toUpdate.PlantID               = dto.PlantID;
             toUpdate.RawMaterialReceivedID = dto.RawMaterialReceivedID;
             toUpdate.QCTechID              = dto.QCTechID;
             toUpdate.SupervisorID          = dto.SupervisorID;
             toUpdate.LeadOperatorID        = dto.LeadOperatorID;
             toUpdate.RedDate               = dto.RedDate;
             toUpdate.FailPropertyID        = dto.FailPropertyID;
             toUpdate.Zone                 = dto.Zone;
             toUpdate.RedComments          = dto.RedComments;
             toUpdate.RedCorrectionAction  = dto.RedCorrectionAction;
             toUpdate.HoldDate             = dto.HoldDate;
             toUpdate.HoldLotNumber        = dto.HoldLotNumber;
             toUpdate.HoldComments         = dto.HoldComments;
             toUpdate.ManagerID            = dto.ManagerID;
             toUpdate.ManagerDate          = dto.ManagerDate;
             toUpdate.ManagerComments      = dto.ManagerComments;
             toUpdate.PrimeBoxCar          = dto.PrimeBoxCar;
             toUpdate.PrimeUOM             = dto.PrimeUOM;
             toUpdate.ReworkBoxCar         = dto.ReworkBoxCar;
             toUpdate.ReworkUOM            = dto.ReworkUOM;
             toUpdate.ScrapBoxCar          = dto.ScrapBoxCar;
             toUpdate.ScrapUOM             = dto.ScrapUOM;
             toUpdate.DateEntered          = dto.DateEntered ?? DateTime.Now;
             toUpdate.EnteredBy            = dto.EnteredBy;
             toUpdate.LastModified         = dto.LastModified ?? DateTime.Now;
             toUpdate.ModifiedBy           = dto.ModifiedBy;
             context.Entry(toUpdate).State = EntityState.Modified;
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
        // GET: /RawMaterialQC/RawMaterialID
        public ActionResult GetLotIDs(int ID)
        {
            List <SelectListItem>     lotIds = new List <SelectListItem>();
            TPOMVCApplicationEntities db     = new TPOMVCApplicationEntities();
            var LotID = db.RawMaterialReceiveds.Where(s => s.RawMaterialID == ID).ToList();


            lotIds.Add(new SelectListItem {
                Value = "", Text = "-- Select Lot Number --"
            });
            foreach (var item in LotID)
            {
                lotIds.Add(new SelectListItem
                {
                    Value = item.ID.ToString(),
                    Text  = item.RawMaterialID.ToString() + " - " + item.LotNumber + " | " +
                            item.DateEntered.ToShortDateString()
                });
            }

            return(Json(new SelectList(lotIds, "Value", "Text")));
        }
Exemplo n.º 14
0
        public ActionResult Create()
        {
            TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();

            TPO.BL.RawMaterials.RawMaterial RawMatList = new TPO.BL.RawMaterials.RawMaterial();

            ViewBag.PlantId = CurrentPlantId;
            TPO.Model.RawMaterials.RawMaterialReceived model = new TPO.Model.RawMaterials.RawMaterialReceived();
            model.DateEntered  = DateTime.Now;
            model.Users        = new SelectList(this.UserRepo.GetAllUsers(), "UserName", "UserName");
            model.ModifiedBy   = CurrentUser;
            model.EnteredBy    = CurrentUser;
            model.RawMaterials = from s in RawMatList.GetRawMaterials()
                                 select new SelectListItem
            {
                Value = s.RawMaterialId.ToString(CultureInfo.InvariantCulture),
                Text  = (s.RawMaterialCode + " | " + s.RawMaterialName)
            };

            model.UrlReferrer = System.Web.HttpContext.Current.Request.UrlReferrer.LocalPath;
            return(View(model));
        }
        /// <summary>
        /// Gets a RawMaterialQCModel representing the RawMaterialQC record indicated by the provided ID.
        /// The RawMaterialQCModel returns also includes configuration data for the various test available.
        /// </summary>
        /// <param name="id">The ID of the RawMaterialQC record in the database.</param>
        /// <returns>A RawMaterialQCModel</returns>
        public RawMaterialQCModel GetRawMaterialQCModelByRawMaterialQCID(int id)
        {
            RawMaterialQCModel model = null;

            using (RawMaterialsRepository repo = new RawMaterialsRepository())
            {
                TPO.DL.Models.RawMaterialQC entity = repo.GetRawMaterialQCByID(id);
                if (entity != null)
                {
                    model = Bind(entity, new RawMaterialQCModel());
                    RawMaterialTest testBL   = new RawMaterialTest();
                    Int32           rawMatID = 0;

                    TPO.DL.Models.RawMaterialReceived rawMaterialReceived =
                        new TPOMVCApplicationEntities().RawMaterialReceiveds.Where(w => w.ID == model.RawMaterialReceivedID).First();

                    model.QCConfiguration = testBL.GetQCConfigurationByRawMaterial(rawMaterialReceived.RawMaterial.ID);
                }
            }

            return(model);
        }
        public void Update(CurrentRawMaterialDTO dto)
        {
            try
            {
                using (var context = new TPOMVCApplicationEntities())
                {
                    var toUpdate = context.TPOCurrentRawMaterials.Find(dto.Id);

                    toUpdate.LineID  = dto.LineId;
                    toUpdate.PlantID = dto.PlantId;
                    // do not allow edit to initial data
                    //toUpdate.DateEntered = dto.DateEntered;
                    //if (!string.IsNullOrWhiteSpace(dto.EnteredBy))
                    //{
                    //    toUpdate.EnteredBy = dto.EnteredBy;
                    //}
                    if (!string.IsNullOrWhiteSpace(dto.ModifiedBy))
                    {
                        toUpdate.ModifiedBy = dto.ModifiedBy;
                    }
                    toUpdate.LastModified = DateTime.Now;

                    toUpdate.Plant = context.Plants.Where(p => p.ID == dto.PlantId).FirstOrDefault();

                    toUpdate.RawMaterialReceivedID = dto.RawMaterialReceivedId;
                    toUpdate.RawMaterialReceived   =
                        context.RawMaterialReceiveds.Where(m => m.ID == dto.RawMaterialReceivedId).FirstOrDefault();

                    context.Entry(toUpdate).State = EntityState.Modified;
                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Exemplo n.º 17
0
        public void Add(RawMaterialQCSpecificGravityDTO dto)
        {
            try
            {
                using (var context = new TPOMVCApplicationEntities())
                {
                    var newEntity = new TPO.DL.Models.RawMaterialSpecificGravity();
                    newEntity.RawMaterialQCID = dto.RawMaterialQCID;


                    newEntity.DateEntered  = dto.DateEntered ?? DateTime.Now;
                    newEntity.EnteredBy    = dto.EnteredBy;
                    newEntity.LastModified = dto.LastModified ?? DateTime.Now;
                    newEntity.ModifiedBy   = dto.ModifiedBy;
                    context.RawMaterialSpecificGravities.Add(newEntity);
                    context.SaveChanges();
                    //need to return the new record id
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
        public ActionResult Edit_Post(TPO.Model.RawMaterials.RawMaterialQCModel qc, int id = 0)
        //TPO.Model.RawMaterials.RawMaterialQCModel model
        {
            //TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();
            //qcBL.UpdateRawMaterialQCModel(model);
            //return View(model);
            bool success = false;

            if (ModelState.IsValid)
            {
                TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
                ViewBag.RawMaterial = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID");
                qc.DateEntered      = Convert.ToDateTime(System.DateTime.Now);
                qc.EnteredBy        = CurrentUser;
                qc.LastModified     = Convert.ToDateTime(System.DateTime.Now);
                qc.ModifiedBy       = CurrentUser;

                TPO.BL.RawMaterials.RawMaterialQC layeredit = new TPO.BL.RawMaterials.RawMaterialQC();
                layeredit.UpdateRawMaterialQCModel(qc);
                success = true;
            }

            return(RedirectToAction("Edit", new { id = id, success = success }));
        }
        public JsonResult RawMaterialsGridByType(string typeID, int rows, int page)
        {
            var newTypeID = Convert.ToInt32(typeID);

            TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();

            db.Configuration.ProxyCreationEnabled = false;

            var testRecords =
                db.RawMaterialQCs.Where(x => x.RawMaterialReceivedID == newTypeID)
                .OrderByDescending(x => x.DateEntered)
                .ToList();


            //add logic for pagination
            //var z = testRecords.Skip((page - 1) * rows).Take(rows);

            //object[] results = new []
            //{

            //}

            return(Json(testRecords, JsonRequestBehavior.AllowGet));
        }
        //
        // GET: /RawMaterialQC/
        public ActionResult Index(int?id, bool unlocked = false)
        {
            TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
            //
            var RawMat = db.RawMaterialQCs.Where(s => s.RawMaterialReceivedID != null).ToList();

            TPO.BL.RawMaterials.RawMaterial RawMatList = new TPO.BL.RawMaterials.RawMaterial();
            ViewBag.RawMaterialQCList = RawMatList.GetRawMaterials();

            //TODO: Refactor after RawMaterialModel is completed to use intID
            List <RawMaterialModel> rawMatListFromBL = RawMatList.GetRawMaterials();
            var QCList = db.Users.Where(s => s.ID != null).ToList();


            IEnumerable <SelectListItem> rawMaterialSelectList = from s in rawMatListFromBL
                                                                 select new SelectListItem
            {
                Value = s.RawMaterialCode,
                Text  = (s.RawMaterialCode + " | " + s.RawMaterialName)
            };
            //IEnumerable<SelectListItem> selectList = from s in RawMat
            //                                         select new SelectListItem
            //                                         {
            //                                             Value = s.RawMaterialID,
            //                                             Text = s.RawMaterialID + " | " + s.RawMaterialLotID.ToString()
            //                                         };

            IEnumerable <SelectListItem> lotSelectList = from s in RawMaterialReceivedRepo.GetAll()
                                                         select new SelectListItem
            {
                Value = s.LotNumber,
                Text  = s.LotNumber + " | " + s.LastModified.ToShortDateString()
            };


            //IEnumerable<SelectListItem> lotSelectList = from s in RawMat
            //                                            select new SelectListItem
            //                                            {
            //                                                Value = s.RawMaterialLotID,
            //                                                Text = (s.RawMaterialLotID.Length != 11 ? s.RawMaterialLotID : s.RawMaterialLotID) + " | " +
            //                                                s.DateEntered.ToShortDateString() +
            //                                                " | " + s.LastModified.ToShortDateString()
            //                                            };

            IEnumerable <SelectListItem> lotTestList = from s in RawMat
                                                       select new SelectListItem
            {
                Value = s.ID.ToString(),
                Text  = s.DateEntered.ToShortDateString() + " | " + s.BoxCarTested
            };


            //new SelectList()
            ViewBag.RawMaterialQC             = new SelectList(rawMaterialSelectList, "Value", "Text");
            ViewBag.RawMaterialLotQC          = new SelectList(lotSelectList, "Value", "Text");
            ViewBag.RawMaterialQCLotTest      = new SelectList(lotTestList, "Value", "Text");
            ViewBag.RawMaterialQCLastModified = new SelectList(RawMat, "ID", "LastModified");
            ViewBag.RawMaterialEnteredBy      = new SelectList(QCList, "ID", "FullName");

            TPO.BL.RawMaterials.RawMaterialQC qcBL = new TPO.BL.RawMaterials.RawMaterialQC();

            //if (id != null)
            //{
            //    RawMaterialQCModel model = qcBL.GetRawMaterialQCModelByRawMaterialQCID(id ?? Convert.ToInt32(id));
            //}
            //else
            //{
            //    RawMaterialQCModel model = new RawMaterialQCModel();
            //}

            RawMaterialQCModel model = qcBL.GetRawMaterialQCModelByRawMaterialQCID(id ?? Convert.ToInt32(id));

            if (model == null)
            {
                model = new RawMaterialQCModel();
            }

            var tests = (from t in db.RawMaterialQCs
                         where t.RawMaterialReceived.ID == t.RawMaterialReceivedID
                         select t).ToList();

            ViewBag.QCItems = tests;

            return(View(model));
        }
 public RepositoryBase()
 {
     Entities = new TPOMVCApplicationEntities();
 }
Exemplo n.º 22
0
        public RawMaterialQCSpecificGravityDTO GetByQCID(int id)
        {
            using (var context = new TPOMVCApplicationEntities())
            {
                var thisItem = (from a in context.RawMaterialSpecificGravities
                                where a.RawMaterialQCID == id
                                select a);
                if (thisItem.Any())
                {
                    return(MapToDTO(thisItem.FirstOrDefault()));
                }

                var newEntity = new RawMaterialSpecificGravity
                {
                    RawMaterialQCID = id,
                    DenIso          = 0.7851,
                    DateEntered     = DateTime.Now,
                    EnteredBy       = "acorrington",
                    LastModified    = DateTime.Now,
                    ModifiedBy      = "acorrington"
                };
                newEntity.RawMaterialQC = (from a in context.RawMaterialQCs
                                           where a.ID == id
                                           select a).FirstOrDefault();
                for (int i = 0; i < 5; i++)
                {
                    var dry = new TPO.DL.Models.RawMaterialSpecificGravityDetail
                    {
                        Order        = (i + 1),
                        Submerged    = false,
                        DateEntered  = DateTime.Now,
                        EnteredBy    = "acorrington",
                        LastModified = DateTime.Now,
                        ModifiedBy   = "acorrington"
                    };
                    var submerged = new TPO.DL.Models.RawMaterialSpecificGravityDetail
                    {
                        Order        = (i + 1),
                        Submerged    = true,
                        DateEntered  = DateTime.Now,
                        EnteredBy    = "acorrington",
                        LastModified = DateTime.Now,
                        ModifiedBy   = "acorrington"
                    };
                    newEntity.RawMaterialSpecificGravityDetails.Add(dry);
                    newEntity.RawMaterialSpecificGravityDetails.Add(submerged);
                }

                context.RawMaterialSpecificGravities.Add(newEntity);
                context.SaveChanges();

                var createdItem = (from a in context.RawMaterialSpecificGravities
                                   where a.RawMaterialQCID == id
                                   select a);
                if (createdItem.Any())
                {
                    return(MapToDTO(createdItem.FirstOrDefault()));
                }
                throw new Exception("Error creating Specific Gravity record.");
            }
        }
Exemplo n.º 23
0
 public UserRepository()
 {
     _dbContext = new TPOMVCApplicationEntities();
 }
Exemplo n.º 24
0
 public UserRepository(TPOMVCApplicationEntities dbContext)
 {
     _dbContext = dbContext;
 }
        public ActionResult Index_Post(string Action, FormCollection formCollection, string RawMaterial, string LotID)
        {
            if (Action == "Lot Not In List")
            {
                return(RedirectToAction("Create", "RawMaterial"));
            }
            if (ModelState.IsValid)
            {
                TPOMVCApplicationEntities db = new TPOMVCApplicationEntities();
                ViewBag.RawMaterial = new SelectList(db.RawMaterialQCs, "ID", "RawMaterialID");

                if (Action == "New Test")
                {
                    TPO.DL.Models.RawMaterialQC rawmaterialqc = new TPO.DL.Models.RawMaterialQC();

                    //rawmaterialqc.RawMaterialID = RawMaterial;
                    rawmaterialqc.PlantID = CurrentPlantId;

                    string string1 = formCollection["RawMaterialQC"];
                    string string2 = formCollection["RawMaterialLotQC"];

                    /*
                     * if (!(string.IsNullOrEmpty(string1)))
                     * {
                     *  try
                     *  {
                     *      rawmaterialqc.RawMaterialReceived.RawMaterialID = int.Parse(string1);
                     *  }
                     *  catch
                     *  {
                     *
                     *  }
                     * }
                     */
                    if (!(string.IsNullOrEmpty(string2)))
                    {
                        try
                        {
                            rawmaterialqc.RawMaterialReceivedID = int.Parse(string2);
                        }

                        catch
                        {
                        }
                    }

                    rawmaterialqc.DateEntered  = Convert.ToDateTime(System.DateTime.Now);
                    rawmaterialqc.EnteredBy    = "";
                    rawmaterialqc.LastModified = Convert.ToDateTime(System.DateTime.Now);
                    rawmaterialqc.ModifiedBy   = "";


                    TryUpdateModel(rawmaterialqc);



                    TPO.BL.RawMaterials.RawMaterialQC layer1 = new TPO.BL.RawMaterials.RawMaterialQC();
                    string ID;

                    TryUpdateModel(rawmaterialqc);
                    if (ModelState.IsValid)
                    {
                        ID = layer1.AddRawMaterialTest(rawmaterialqc);



                        return(RedirectToAction("Edit", new { id = ID, isNew = true }));
                    }
                    else
                    {
                        return(RedirectToAction("index"));
                    }
                }
                else
                {
                    return(RedirectToAction("Index"));
                }
            }

            return(View());
        }