private void btn_Finish_Click(object sender, EventArgs e)
{
panel_ConductSurvey.Visible = false;
panel_ConductSurvey.Enabled = false;
panel_Finish.Visible = true;
panel_Finish.Enabled = true;
using (SurveyController surveyController = new SurveyController())
using (ResultController resultController = new ResultController())
{
string SurveyName = surveyController.Get(SurveyID).SurveyName;
string DateNow = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
FinalResult.Date = DateNow;
resultController.Add(FinalResult);
}
foreach (ResultDefinition resultDefinition in Results)
{
resultDefinition.ResultID = FinalResult.ResultID;
}
using (ResultDefinitionController resultDefinitionController = new ResultDefinitionController())
resultDefinitionController.Add(Results);
}
public long Import(string DatabaseImportPath)
{
// Copy data from Export Database to Current Database.
using (Database DBRestore = new Database(DatabaseImportPath))
{
// Checking if there are same Users.
List <UserModelDataTransferObject> RestoreUsers, CurrentUsers;
using (UserController UserController = new UserController(DatabaseImportPath))
RestoreUsers = UserController.GetUsers().OrderBy(u => u.UserID).ToList();
using (UserController UserController = new UserController())
CurrentUsers = UserController.GetUsers().OrderBy(u => u.UserID).ToList();
if (CurrentUsers.Count != RestoreUsers.Count)
{
throw new Exception("Selected database does not have the same Users.");
}
for (int UserIndex = 0; UserIndex <= RestoreUsers.Count - 1; ++UserIndex)
{
if (CurrentUsers[UserIndex] != RestoreUsers[UserIndex])
{
throw new Exception("Selected database does not have the same Users.");
}
}
// Check if there are the same Questions
List <Question> RestoreQuestions, CurrentQuestions;
using (QuestionController QuestionControllerRestore = new QuestionController(DatabaseImportPath))
RestoreQuestions = QuestionControllerRestore.GetAll();
using (QuestionController QuestionControllerCurrent = new QuestionController())
CurrentQuestions = QuestionControllerCurrent.GetAll();
if (CurrentQuestions.Count != RestoreQuestions.Count)
{
throw new Exception("Selected database does not have the same Questions.");
}
foreach (Question CurrentQuestion in CurrentQuestions)
{
if (!RestoreQuestions.Any(q => q.QuestionID == CurrentQuestion.QuestionID &&
q.Question1 == CurrentQuestion.Question1))
{
throw new Exception("Selected database does not have the same Questions.");
}
}
// Check if there are the same Surveys
List <Survey> RestoreSurveys, CurrentSurveys;
using (SurveyController SurveyControllerRestore = new SurveyController(DatabaseImportPath))
RestoreSurveys = SurveyControllerRestore.GetAll();
using (SurveyController SurveyControllerCurrent = new SurveyController())
CurrentSurveys = SurveyControllerCurrent.GetAll();
if (CurrentSurveys.Count != RestoreSurveys.Count)
{
throw new Exception("Selected database does not have the same Surveys.");
}
foreach (Survey CurrentSurvey in CurrentSurveys)
{
if (!RestoreSurveys.Any(s => s.SurveyID == CurrentSurvey.SurveyID &&
s.SurveyName == CurrentSurvey.SurveyName))
{
throw new Exception("Selected database does not have the same Surveys.");
}
}
// Check if there are the same Survey Definitions
List <SurveyDefinition> RestoreSurveyDefinitions, CurrentSurveyDefinitions;
using (SurveyDefinitionController AttitudeDefinitionControllerRestore = new SurveyDefinitionController(DatabaseImportPath))
RestoreSurveyDefinitions = AttitudeDefinitionControllerRestore.Get();
using (SurveyDefinitionController AttitudeDefinitionControllerCurrent = new SurveyDefinitionController())
CurrentSurveyDefinitions = AttitudeDefinitionControllerCurrent.Get();
if (CurrentSurveyDefinitions.Count != RestoreSurveyDefinitions.Count)
{
throw new Exception("Selected database does not have the same Survey Definitions.");
}
foreach (SurveyDefinition CurrentSurveyDefinition in CurrentSurveyDefinitions)
{
if (!RestoreSurveyDefinitions.Any(sd => sd.SurveyDefinitionID == CurrentSurveyDefinition.SurveyDefinitionID &&
sd.QuestionID == CurrentSurveyDefinition.QuestionID &&
sd.SurveyID == CurrentSurveyDefinition.SurveyID))
{
throw new Exception("Selected database does not have the same Survey Definitions.");
}
}
// Check if there are the same Attitudes
List <Attitude> RestoreAttitudes, CurrentAttitudes;
using (AttitudeController AttitudeControllerRestore = new AttitudeController(DatabaseImportPath))
RestoreAttitudes = AttitudeControllerRestore.GetAttitudes();
using (AttitudeController AttitudeControllerCurrent = new AttitudeController())
CurrentAttitudes = AttitudeControllerCurrent.GetAttitudes();
if (CurrentAttitudes.Count != RestoreAttitudes.Count)
{
throw new Exception("Selected database does not have the same Attitudes.");
}
foreach (Attitude CurrentAttitude in CurrentAttitudes)
{
if (!RestoreAttitudes.Any(a => a.AttitudeID == CurrentAttitude.AttitudeID &&
a.AttitudeName == CurrentAttitude.AttitudeName))
{
throw new Exception("Selected database does not have the same Attitudes.");
}
}
// Check if there are the same Attitudes Definitions
List <AttitudeDefinition> RestoreAttitudeDefinitions, CurrentAttitudeDefinitions;
using (AttitudeDefinitionController AttitudeDefinitionControllerRestore = new AttitudeDefinitionController(DatabaseImportPath))
RestoreAttitudeDefinitions = AttitudeDefinitionControllerRestore.Get();
using (AttitudeDefinitionController AttitudeDefinitionControllerCurrent = new AttitudeDefinitionController())
CurrentAttitudeDefinitions = AttitudeDefinitionControllerCurrent.Get();
if (CurrentAttitudeDefinitions.Count != RestoreAttitudeDefinitions.Count)
{
throw new Exception("Selected database does not have the same Attitude Definitions.");
}
foreach (AttitudeDefinition CurrentAttitudeDefinition in CurrentAttitudeDefinitions)
{
if (!RestoreAttitudeDefinitions.Any(ad => ad.AttitudeDefinitionID == CurrentAttitudeDefinition.AttitudeDefinitionID &&
ad.AttitudeID == CurrentAttitudeDefinition.AttitudeID &&
ad.QuestionID == CurrentAttitudeDefinition.QuestionID))
{
throw new Exception("Selected database does not have the same Attitude Definitions.");
}
}
// Actually import new data from Result Table
long ImportedResultCount = 0;
using (ResultController resultControllerRestore = new ResultController(DatabaseImportPath))
using (ResultController resultControllerCurrent = new ResultController())
{
List <Result> RestoreResults = resultControllerRestore.Get();
List <Result> CurrentResults = resultControllerCurrent.Get();
foreach (Result RestoreResult in RestoreResults)
{
if (!CurrentResults.Any(r => r.SurveyID == RestoreResult.SurveyID &&
r.Date == RestoreResult.Date &&
r.UserID == RestoreResult.UserID))
{
// Add to result table
long OldResultID = RestoreResult.ResultID;
resultControllerCurrent.Add(RestoreResult); // ID may change during adding.
long NewResultID = RestoreResult.ResultID;
++ImportedResultCount;
// Get all Result definitions
using (ResultDefinitionController resultDefinitionControllerRestore = new ResultDefinitionController(DatabaseImportPath))
using (ResultDefinitionController resultDefinitionControllerCurrent = new ResultDefinitionController())
{
List <ResultDefinition> RestoreResultDefinitions = resultDefinitionControllerRestore.Get(OldResultID);
RestoreResultDefinitions.ForEach(rd => rd.ResultID = NewResultID); // Update with new ResultID
resultDefinitionControllerCurrent.Add(RestoreResultDefinitions);
}
}
}
}
return(ImportedResultCount);
}
}
private void cmb_SelectUserReport_SelectedIndexChanged(object sender, EventArgs e)
{
string Username = cmb_SelectUserReport.Text;
int SelectedIndex = cmb_SelectUserReport.SelectedIndex;
listView_UserReports.Items.Clear();
listView_AttitudeReports.Items.Clear();
if (Username == "*" || SelectedIndex == -1)
{
return;
}
UserModelDataTransferObject SelectedUser;
using (UserController userController = new UserController())
SelectedUser = userController.GetUserByName(Username);
long UserID = SelectedUser.UserID;
List <Result> UserResults;
using (ResultController resultController = new ResultController())
UserResults = resultController.GetForUser(UserID);
UserResults = UserResults.OrderBy(r => r.SurveyID).ThenByDescending(r => r.Date).ToList();
SurveyController surveyController = new SurveyController();
foreach (Result result in UserResults)
{
string SurveyName = surveyController.Get(result.SurveyID).SurveyName;
listView_UserReports.Items.Add(new ListViewItem(listView_UserReports.Groups["default"])
{
Text = result.ToString(), Tag = result.ResultID
});
}
//Get list of lastest User Reports
List <long> UsedSurveyID = new List <long>();
List <Result> LastUserReports = new List <Result>();
foreach (Result result in UserResults)
{
if (!UsedSurveyID.Contains(result.SurveyID))
{
UsedSurveyID.Add(result.SurveyID);
LastUserReports.Add(result);
}
}
UsedSurveyID = null;
//Calculate Attitude Score
using (AttitudeController attitudeController = new AttitudeController())
using (AttitudeDefinitionController attitudeDefinitionController = new AttitudeDefinitionController())
using (ResultDefinitionController resultDefinitionController = new ResultDefinitionController())
{
List <Attitude> attitudes = attitudeController.GetAttitudes();
listView_AttitudeReports.Items.Clear();
foreach (Attitude attitude in attitudes)
{
long AttitudeSum = 0;
bool Found = false;
List <AttitudeDefinition> attitudeDefinitions = attitudeDefinitionController.GetRelation(attitude.AttitudeID);
foreach (AttitudeDefinition attitudeDefinition in attitudeDefinitions)
{
long QuestionID = attitudeDefinition.QuestionID;
foreach (Result result in LastUserReports)
{
List <ResultDefinition> resultDefinitions = resultDefinitionController.Get(result.ResultID);
Found = false;
foreach (ResultDefinition resultDefinition in resultDefinitions)
{
if (resultDefinition.QuestionID == QuestionID)
{
AttitudeSum += resultDefinition.ResultAnswer;
Found = true;
break;
}
}
if (Found)
{
break;
}
}
string SurveyName = surveyController.GetByQuestion(QuestionID).SurveyName;
if (!Found)
{
listView_AttitudeReports.Items.Add(
new ListViewItem(listView_AttitudeReports.Groups["default"])
{
ForeColor = Color.Red,
Text = attitude.AttitudeName + " - requires '" + SurveyName + "'",
Tag = attitude.AttitudeID
});
break;
}
}
if (Found)
{
listView_AttitudeReports.Items.Add(
new ListViewItem(listView_AttitudeReports.Groups["default"])
{
Text = attitude.AttitudeName + " - " + AttitudeSum,
Tag = attitude.AttitudeID
});
}
}
}
}
