Example #1
0
        public bool Insert(WAMS_REQUISITION_MASTER entity, List<WAMS_REQUISITION_DETAILS> entityDetails)
        {
            _repository.Add(entity);
            _unitOfWork.CommitChanges();

            foreach (var detail in entityDetails)
            {
                var detailEntity = new WAMS_REQUISITION_DETAILS
                {
                    vMRF = entity.Id,
                    vStockID = detail.vStockID,
                    fQuantity = detail.fQuantity,
                    fTobePurchased = detail.fTobePurchased,
                    Remark = detail.Remark,
                    iFollowUpRequired = 1,
                    iPurchased = 0,
                    iSent = 0,
                    vStatus = "Open",
                    iEnable = true,
                    dDateAssign = entity.dCreated,
                    dCreated = entity.dCreated,
                    iCreated = entity.iCreated
                };
                _repositoryDetail.Add(detailEntity);
            }

            _unitOfWork.CommitChanges();
            return true;
        }
        public ActionResult Create(int? id)
        {
            var userName = System.Web.HttpContext.Current.User.Identity.Name;
            var user = _systemService.GetUserAndRole(0, userName);
            if (user == null)
            {
                return RedirectToAction("Index", "Login");
            }

            if (user.RequisitionR == 0)
            {
                return RedirectToAction("Index", "Home");
            }

            var item = new WAMS_REQUISITION_MASTER();
            if (id.HasValue)
            {
                item = _service.GetByKey(id.Value);
            }
            else
            {
                item.vMRF =
                    (Convert.ToInt32(_service.GetCodeLastest()) + 1).ToString(CultureInfo.InvariantCulture);
            }

            var model = new RequisitionViewModel
            {
                Id = item.Id,
                vMRF = item.vMRF,
                vFrom = item.vFrom,
                iStore = item.iStore,
                vDeliverLocation = item.vDeliverLocation,
                vProjectID = item.vProjectID,
                Timestamp = item.Timestamp,
                UserLogin = user,
                Stores = new SelectList(_systemService.StoreList(), "Id", "Name"),
                Projects = new SelectList(_systemService.ProjectList(), "Id", "vProjectID"),
                ProjectNames = new SelectList(_systemService.ProjectList(), "Id", "vProjectName")
            };

            if (id.HasValue)
            {
                var temp = _service.ListConditionDetail(id.Value, "1");
                model.GetRequisitionDetailsVResults = temp;
                model.TotalRecords = temp.Count;
            }
            if (item.dDeliverDate.HasValue)
            {
                model.DeliverDateTemp = item.dDeliverDate.Value.ToString("dd/MM/yyyy");
            }

            return View(model);
        }
Example #3
0
        public bool Update(WAMS_REQUISITION_MASTER entity, List<WAMS_REQUISITION_DETAILS> entityDetails, string LstDeleteDetailItem)
        {
            _repository.Update(entity);
            foreach (var detail in entityDetails)
            {
                if (detail.ID != 0)
                {
                    var detailEntity = _repositoryDetail.GetByKey(detail.ID);
                    detailEntity.vStockID = detail.vStockID;
                    detailEntity.fQuantity = detail.fQuantity;
                    detailEntity.fTobePurchased = detail.fTobePurchased;
                    detailEntity.Remark = detail.Remark;
                    detailEntity.dModified = DateTime.Now;
                    detailEntity.iModified = entity.iModified;
                    _repositoryDetail.Update(detailEntity);
                }
                else
                {
                    var detailEntity = new WAMS_REQUISITION_DETAILS
                    {
                        vMRF = entity.Id,
                        vStockID = detail.vStockID,
                        fQuantity = detail.fQuantity,
                        fTobePurchased = detail.fTobePurchased,
                        Remark = detail.Remark,
                        iFollowUpRequired = 1,
                        iPurchased = 0,
                        iSent = 0,
                        vStatus = "Open",
                        iEnable = true,
                        dDateAssign = entity.dCreated,
                        dCreated = entity.dCreated,
                        iCreated = entity.iCreated
                    };
                    _repositoryDetail.Add(detailEntity);
                }
            }

            if (!string.IsNullOrEmpty(LstDeleteDetailItem))
            {
                var listStrLineElements = LstDeleteDetailItem.Split(';').ToList();
                foreach (var itemDetail in listStrLineElements)
                {
                    _customRepository.DeleteDetail(Convert.ToInt32(itemDetail));
                }
            }

            _unitOfWork.CommitChanges();
            return true;
        }