private static int GetNextQuestionSetId()
{
var qSets = SqlManager.GetAllQuestionSets(-1, "");
var nextId = 0;
if (qSets != null)
{
foreach (var qSet in qSets)
{
if (qSet.UniqueID > nextId)
{
nextId = qSet.UniqueID;
}
}
}
nextId += 1;
return(nextId);
}
private int GetNextViolationID()
{
List <Violation> violations = SqlManager.GetAllViolations();
int nextID = 0;
if (violations != null)
{
foreach (Violation violation in violations)
{
if (violation.ViolationUID > nextID)
{
nextID = violation.ViolationUID;
}
}
}
nextID = nextID + 1;
return(nextID);
}
private int GetNextViolationID()
{
var violations = SqlManager.GetAllViolations();
var nextId = 0;
if (violations != null)
{
foreach (var violation in violations)
{
if (violation.ViolationUid > nextId)
{
nextId = violation.ViolationUid;
}
}
}
nextId += 1;
return(nextId);
}
public bool AddQuestion(string qText, int qSetID)
{
QuestionSet qSet = SqlManager.FindQuestionSet(qSetID);
if (qSet != null)
{
Question question = new Question();
question.QuestionText = qText;
question.QuestionID = GetNextQuestionID(qSet);
qSet.Questions.Add(question);
qSet.Status = "UPDATED";
bool passed = SqlManager.AddQuestion(qSet, question);
SqlManager.ModifyQuestionSet(qSet);
return(passed);
}
else
{
return(false);
}
}
public bool CreateQuestionSet(int departmentID, int priority, DateTime dueDate, string question, string category)
{
QuestionSet qSet = new QuestionSet();
//TODO: Getassigned department ID from a string parmaneter
qSet.AssignedDepartment = departmentID;
qSet.Priority = priority;
qSet.DueDate = dueDate;
qSet.Category = category;
qSet.UniqueID = GetNextQuestionSetID();
qSet.Status = "CREATED";
Question newQuestion = new Question();
newQuestion.QuestionText = question;
newQuestion.QuestionID = GetNextQuestionID(qSet);
qSet.Questions.Add(newQuestion);
bool result = SqlManager.CreateNewQuestionSet(qSet);
return(result);
}
public bool ModifyQuestion(string qText, int qSetID, int qID)
{
var qSet = SqlManager.FindQuestionSet(qSetID);
if (qSet != null)
{
foreach (var q in qSet.Questions)
{
if (q.QuestionId == qID)
{
q.QuestionText = qText;
var passed = SqlManager.ModifyQuestion(q, qSetID);
qSet.Status = "UPDATED";
SqlManager.ModifyQuestionSet(qSet);
return(passed);
}
}
return(false);
}
return(false);
}
public List <QuestionSet> GetQuestionSetsForDepartment(int departmentID)
{
List <QuestionSet> qSets = SqlManager.GetAllDepartmentQuestionSets(departmentID);
return(qSets);
}
public QuestionSet GetQuestionSet(int id)
{
QuestionSet qSet = SqlManager.FindQuestionSet(id);
return(qSet);
}
public List <QuestionSet> GetStenerList()
{
List <QuestionSet> steners = SqlManager.GetAllQuestionSets();
return(steners);
}
public void DeleteQuestion(int qSetID, int qID)
{
SqlManager.RemoveQuestion(qID, qSetID);
}
public void RemoveViolation(int violationUID)
{
SqlManager.RemoveViolation(violationUID);
}
public UserData FindUser(int x)
{
UserData tempUserData = SqlManager.FindUser(x);
return(tempUserData);
}
public void DeleteUser(int UUID)
{
UserData user = SqlManager.FindUser(UUID);
SqlManager.RemoveUser(UUID);
}
public List <UserData> GetUserList()
{
List <UserData> usersData = SqlManager.GetAllUsers();
return(usersData);
}
public Department GetDepartmentByName(string departmentName)
{
Department department = SqlManager.FindDepartmentByName(departmentName);
return(department);
}
public void DeleteQuestion(int qSetId, int qId)
{
SqlManager.RemoveQuestion(qId, qSetId);
}
public List <QuestionSet> GetStenerList()
{
var steners = SqlManager.GetAllQuestionSets(-1, "");
return(steners);
}
public List <QuestionSet> GetSubmittedQuestionSets()
{
List <QuestionSet> qSets = SqlManager.GetAllQuestionSetsOfStatus("SUBMITTED");
return(qSets);
}
// Remove the specified user from the database
public void DeleteUser(int uuid)
{
SqlManager.RemoveUser(uuid);
}
public void DeleteQuesitonSet(int id)
{
SqlManager.RemoveQuestionSet(id);
}
public UserData Login(string username, string password)
{
UserData user = SqlManager.AuthenticateCredentials(username, ComputeSha256Hash(password));
return(user);
}
public List <QuestionSet> GetSubmittedQuestionSets()
{
var qSets = SqlManager.GetAllQuestionSets(-1, "SUBMITTED");
return(qSets);
}
