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 Upload(string id) { if (string.IsNullOrWhiteSpace(id)) { TempData["Message"] = "Unable to upload file. No file was selected. Please select a file and try again."; return RedirectToAction("Index"); } var file = GetNamedFile(id); string filename = file.FileName; //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 schoolCode = unit.DeansOfficeSchoolCode; _sftpService.UploadFile(filename, schoolCode); var unitFile = _unitFileRepository.Queryable.FirstOrDefault(x => x.Filename == filename); if (unitFile == null) { //var user = BenefitsAllocation.Core.Domain.User.GetByLoginId(Repository, User.Identity.Name); //var unit = user.Units.FirstOrDefault(); unitFile = new UnitFile() { Filename = filename, SchoolCode = unit.DeansOfficeSchoolCode, UnitId = unit.UnitID }; } unitFile.Uploaded = DateTime.Now; unitFile.UploadedBy = User.Identity.Name; _unitFileRepository.EnsurePersistent(unitFile); Message = String.Format("File \"{0}\" has been uploaded.", filename); return RedirectToAction("Index"); }