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");
}
