public ActionResult SubmitERProposal(string appid) { string[] userdata = Session["UserData"] as string[]; string userid = userdata[0]; ViewBag.Title = "Submit Proposal"; ViewBag.RefId = Guid.NewGuid().ToString(); OperatorERProposalViewModel viewModel = new OperatorERProposalViewModel(); if (!string.IsNullOrEmpty(appid)) { ERApplication erapp = ERApplicationContext.Collection().Where(x => x.AppId == appid).FirstOrDefault(); viewModel.ERApplications = erapp; if (!string.IsNullOrEmpty(erapp.ERScreeningDetailId)) { ViewBag.ERFiles = UploadFileContext.Collection() .Where(y => y.FIleRef == erapp.ERScreeningDetail.ReportDocumentPath).ToList(); } else { ViewBag.ERFiles = null; } } else { viewModel.ERApplications = new ERApplication(); viewModel.ERApplications.Organisation = UserAccountContext.Collection().Where(x => x.Id == userid).FirstOrDefault().Organisation; viewModel.ERApplications.OrganisationId = viewModel.ERApplications.Organisation.Id; } viewModel.FieldTypes = FieldTypeContext.Collection().ToList(); viewModel.UHCProductionMethods = UHCProductionMethodContext.Collection().ToList(); viewModel.eRTechniques = ERTechniquesContext.Collection().ToList(); viewModel.eRScreeningInstitutes = ERScreeningInstituteContext.Collection().ToList(); //viewModel.UploadFiles = UploadFileContext.Collection(); return(View(viewModel)); }
public ActionResult SubmitERProposal(OperatorERProposalViewModel _ERApplication, string FileRef) { ViewBag.Title = "Submit Proposal"; string[] userdata = Session["UserData"] as string[]; string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss").Replace("/", "").Replace(":", "").Replace(" ", ""); _ERApplication.ERApplications.AppId = "ERAPPID" + dt; _ERApplication.ERApplications.ERScreeningDetail.ReportDocumentPath = FileRef; if (!string.IsNullOrEmpty(_ERApplication.EGRTechniqueId)) { _ERApplication.ERApplications.ERTechniquesId = _ERApplication.EGRTechniqueId; } else if (!string.IsNullOrEmpty(_ERApplication.EORTechniqueId)) { _ERApplication.ERApplications.ERTechniquesId = _ERApplication.EORTechniqueId; } else { _ERApplication.ERApplications.ERTechniquesId = null; } _ERApplication.ERApplications.MassiveFracking = MassiveUHC.AcidFracking; if (!TryValidateModel(_ERApplication.ERApplications)) { ViewBag.RefId = FileRef; _ERApplication.FieldTypes = FieldTypeContext.Collection().ToList(); _ERApplication.UHCProductionMethods = UHCProductionMethodContext.Collection().ToList(); _ERApplication.eRScreeningInstitutes = ERScreeningInstituteContext.Collection().ToList(); _ERApplication.eRTechniques = ERTechniquesContext.Collection().ToList(); return(View(_ERApplication)); } ERApplicationContext.Insert(_ERApplication.ERApplications); string auditstatus = StatusMasterContext.Collection().Where(status => status.Status == "Application Submitted").FirstOrDefault().CustStatusId; string CERuserrole = UserRoleType.ConsultantEnhancedRecovery.GetDisplayName(); string CER = UserAccountContext.Collection().Where(x => x.UserRole == CERuserrole).FirstOrDefault().Id; AuditTrails auditTrails = new AuditTrails() { ERApplicationId = _ERApplication.ERApplications.Id, FileRefId = FileRef, StatusId = auditstatus, SenderId = userdata[0], //ReceiverId = CER, // Consultant Enhanced Recovery Is_Active = true, }; List <string> lst = new List <string>() { userdata[0], CER // Consultant Enhanced Recovery }; foreach (string x in lst) { ERAppActiveUsers eRAppActiveUsers = new ERAppActiveUsers() { ERApplicationId = _ERApplication.ERApplications.Id, UserAccountId = x, Dept_Id = null, Is_Active = true, Status = null }; ERAppActiveUsersContext.Insert(eRAppActiveUsers); } AuditTrailContext.Insert(auditTrails); using (TransactionScope scope = new TransactionScope()) { ERApplicationContext.Commit(); ERAppActiveUsersContext.Commit(); AuditTrailContext.Commit(); scope.Complete(); } return(Json("Application Ref. No :" + _ERApplication.ERApplications.AppId, JsonRequestBehavior.AllowGet)); }