public ActionResult Create(CreateModel m) { if (ModelState.IsValid) { //var user = BenefitsAllocation.Core.Domain.User.GetByLoginId(Repository, User.Identity.Name); var user = Models.User.FindByLoginId(System.Web.HttpContext.Current.User.Identity.Name); var unit = user.Units.FirstOrDefault(); var orgId = string.Empty; var transDocOriginCode = string.Empty; using (var context = new FISDataMartEntities()) { var schoolCodeParameter = new SqlParameter("schoolCode", unit.SchoolCode); orgId = context.Database.SqlQuery<string>( "SELECT dbo.udf_GetOrgIdForSchoolCode(@schoolCode)", schoolCodeParameter).FirstOrDefault(); var orgIdParameter = new SqlParameter("orgId", orgId); transDocOriginCode = context.Database.SqlQuery<string>( "SELECT dbo.udf_GetTransDocOriginCodeForOrg(@orgId)", orgIdParameter).FirstOrDefault(); } //var filename = _dataExtractionService.CreateFile(m.FiscalYear, m.FiscalPeriod, m.TransDescription, m.OrgDocNumber, m.OrgRefId, m.TransDocNumberSequence); var useDaFIS = (m.UseDaFIS == CreateModel.YesNo.Yes); var filename = _dataExtractionService.CreateFile(m.FiscalYear, m.FiscalPeriod.Period, m.TransDescription, m.OrgDocNumber, m.OrgRefId, m.TransDocNumberSequence, orgId, transDocOriginCode, useDaFIS); //var user = BenefitsAllocation.Core.Domain.User.GetByLoginId(Repository, User.Identity.Name); //var unit = user.Units.FirstOrDefault(); Message = "No file was created. There was no benefits data available."; if (!string.IsNullOrWhiteSpace(filename)) { var unitFile = new UnitFile() { Filename = filename, SchoolCode = unit.DeansOfficeSchoolCode, UnitId = unit.UnitID, Created = DateTime.Now, CreatedBy = User.Identity.Name }; _unitFileRepository.EnsurePersistent(unitFile); Message = String.Format("File \"{0}\" has been created.", filename); } return RedirectToAction("Index"); } return View(m); }
public ActionResult Create() { var model = new CreateModel() { UseDaFIS = CreateModel.YesNo.Yes, EnableUseDaFisSelection = false }; //var unit = BenefitsAllocation.Core.Domain.User.GetByLoginId(Repository, User.Identity.Name).Units.FirstOrDefault(); var unit = Models.User.FindByLoginId(System.Web.HttpContext.Current.User.Identity.Name).Units.FirstOrDefault(); if (unit != null) { var schoolCode = unit.SchoolCode; if (!string.IsNullOrEmpty(schoolCode) && schoolCode.Equals("01")) { model.UseDaFIS = CreateModel.YesNo.No; model.EnableUseDaFisSelection = true; } } ViewBag.Message = "Create a New Upload File"; return View(model); }