public ActionResult Save_File_Data(string project, string fileName)
// Save transferred File to database
{
// Use ADO instead of EF due to performance issues
string ADOcon = ConfigurationManager.ConnectionStrings["ADOLucroAnalyzer"].ConnectionString;
SqlConnection DbConnection = new SqlConnection(ADOcon);
DbConnection.Open();
DB_Context db = new DB_Context();
CSVFile myData = new CSVFile();
myData = UploadToObject(project, fileName);
var projectList = db.Project.ToList();
// Get the ProjectId for the Project Name given.
int myProjectId = (from projItem in projectList
where projItem.ProjectName == project && projItem.UserId == User.Identity.GetUserId()
select projItem.ProjectId).FirstOrDefault();
// Save the Properties and DataNames in the database and return their corresponding Id's (key values9 from the database model
List <List <int> > myIDList = FillNames(myProjectId, myData.NameList, myData.TypeList);
ProjectData myProject = new ProjectData();
// SHow that the project is in the update status (used to show a text in the project list oin the View)
myProject.SetProjectstatus(myProjectId, "U");
// Fill all values for properties and datanames in the database
myProject.FillValues(ADOcon, context: db, myProjectID: myProjectId, myIDList: myIDList, myTypeList: myData.TypeList, myValueList: myData.ValueList);
db.SaveChanges();
db.Dispose();
DbConnection.Close();
// Show project List
return(RedirectToAction("../Projects/ProjectList"));
}