Esempio n. 1
0
        public ActionResult Edit(string prdkey)
        {
            ViewData["Product"] = _searchFacade.FindRfpProduct(prdkey);
            var rfq = _rfpFacade.GetRFQDetails(CurrentUser.User.org_key.ToString(), prdkey);

            if (rfq == null)
            {
                rfq = new RfpRequest()
                {
                    rfp_key = Guid.NewGuid()
                };
            }
            else
            {
                rfq.RACIContactList = _contactFacade.GetRACIContacts(new RACIFilter {
                    Org_key = CurrentUser.User.org_key, rfp_key = rfq.rfp_key.ToString()
                });

                var files = _rfpAttachmentFacade.GetWhere($"rfa_key in (select axr_rfa_key from attachment_x_request where axr_rfp_key='{rfq.rfp_key.ToString()}')");

                if (files != null && files.Where(p => p.rfa_type == "QA").Count() > 0)
                {
                    rfq.QuestionnaireFiles = string.Join(",", files.Where(p => p.rfa_type == "QA").Select(p => p.rfa_key));
                }

                if (files != null && files.Where(p => p.rfa_type == "AA").Count() > 0)
                {
                    rfq.RfpAttachments = string.Join(",", files.Where(p => p.rfa_type == "AA").Select(p => p.rfa_key));
                }
            }

            return(View(rfq));
        }