public IActionResult Delete_InterviewSchemeAndQuestions(InterviewSchemeVM vm)
{
_interviewScheme = new InterviewScheme();
_interviewScheme.DeleteInterviewScheme(vm.Id);
return(RedirectToAction("Get_All_InterviewScheme"));
}
public IActionResult Delete_InterviewScheme_Question(string id, string schemeid)
{
_interviewScheme = new InterviewScheme();
_interviewScheme.RemoveQuestion(Guid.Parse(id));
return(RedirectToAction("Get_Specific_Interview", new { id = schemeid }));
}
public IActionResult Save_Changes_InterviewSchemeAndQuestions(InterviewSchemeVM vm)
{
_interviewScheme = new InterviewScheme();
_interviewScheme.UpdateInterviewScheme(vm);
return(RedirectToAction("Get_Specific_Interview", new { id = vm.Id }));
}
public IActionResult Pass_Edited_InterviewScheme_Question(QuestionVM model)
{
_interviewScheme = new InterviewScheme();
_interviewScheme.UpdateQuestion(model);
return(RedirectToAction("Get_Specific_Interview", new { id = model.InterviewSchemeId }));
}
public IActionResult Pass_InterviewScheme_Question(InterviewSchemeVM model)
{
_interviewScheme = new InterviewScheme();
_nationality = new Nationality();
_studyField = new StudyField();
model.Question.InterviewSchemeId = model.Id;
var countquestions = _interviewScheme.GetQuestions(model.Id);
if (countquestions.Count == 0)
{
model.Question.Order = 1;
}
else
{
countquestions = countquestions.OrderBy(x => x.Order).ToList();
var last = countquestions.LastOrDefault();
model.Question.Order = last.Order + 1;
}
_interviewScheme.AddQuestionToInterview(model.Question);
var nationalities = _nationality.GetAllNationalities();
var studyfields = _studyField.GetAllStudyFields();
foreach (var country in nationalities)
{
model.Countries.Add(new SelectListItem()
{
Text = country.Name, Value = country.Id.ToString()
});
}
foreach (var study in studyfields)
{
model.Studyfields.Add(new SelectListItem()
{
Text = study.FieldName, Value = study.Id.ToString()
});
}
var questions = _interviewScheme.GetQuestions(model.Id);
foreach (var quest in questions)
{
model.Questions.Add(new QuestionVM()
{
Id = quest.Id, Order = quest.Order, Answer = quest.Answer, InterviewSchemeId = quest.InterviewSchemeId, Quest = quest.Quest
});
}
model.Questions = model.Questions.OrderBy(x => x.Order).ToList();
return(View("../Administration/CreateQuestionToInterview", model));
}
public int CreateNewInterviewScheme(InterviewScheme interview)
{
string query = "INSERT INTO UCL_InterviewScheme(Name, Comment) VALUES (@Name, @Comment)";
string query2 = "INSERT INTO UCL_InterviewSchemeForCountry(Id, Country, InterviewScheme) VALUES (@Guid, @CountryId, @InterviewScheme)";
string query3 = "INSERT INTO UCL_InterviewSchemeForStudyField(Id, StudyField, InterviewScheme) VALUES (@Guid, @StudyId, @InterviewScheme)";
string SchemeName = "@Name";
string param1 = "@Comment";
string param2 = "@CountryId";
string param3 = "@InterviewScheme";
string param4 = "@StudyId";
string param5 = "@Guid";
return(ExecuteTrans(query, query2, query3, _db.SetParameterWithValue(param1, interview.Comment), _db.SetParameterWithValue(SchemeName, interview.Name), param2, param3, param4, param5, interview));
}
public IActionResult Get_Applicant_Modal(string id)
{
_applicant = new Applicant();
ApplicantVM vm = new ApplicantVM();
vm = _applicant.GetApplicant(id);
_studyField = new StudyField();
_nationality = new Nationality();
_interviewer = new Interviewer();
_interviewScheme = new InterviewScheme();
var studyfields = _studyField.GetAllStudyFields();
var nationalities = _nationality.GetAllNationalities();
var interviewers = _interviewer.GetAllInterviewers();
var schemes = _interviewScheme.GetSpecificInterviewSchemes(id);
foreach (var sf in studyfields)
{
vm.StudyFields.Add(new SelectListItem()
{
Text = sf.FieldName, Value = sf.Id.ToString()
});
}
foreach (var na in nationalities)
{
vm.Nationalities.Add(new SelectListItem()
{
Text = na.Name, Value = na.Id.ToString()
});
}
foreach (var inn in interviewers)
{
vm.Interviewers.Add(new SelectListItem()
{
Text = inn.Firstname + " " + inn.Lastname, Value = inn.Id.ToString()
});
}
foreach (var sch in schemes)
{
vm.InterviewSchemes.Add(new SelectListItem()
{
Text = sch.Name, Value = sch.Id.ToString()
});
}
return(PartialView("../Administration/Partials/_PopulateModalWithApplicant", vm));
}
public IActionResult Get_All_InterviewScheme()
{
_interviewScheme = new InterviewScheme();
List <InterviewSchemeVM> listvm = new List <InterviewSchemeVM>();
var list = _interviewScheme.GetAllInterviewSchemes();
foreach (var item in list)
{
listvm.Add(item);
}
return(View("../Administration/Get_All_InterviewSchemes_And_Questions", listvm));
}
private List <InterviewScheme> ExecuteReaderListScheme(string query)
{
_db.Get_Connection();
InterviewScheme scheme;
List <InterviewScheme> list = new List <InterviewScheme>();
using (cmd.Connection = _db.conn)
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
scheme = new InterviewScheme();
scheme.Id = reader.GetInt32(0);
scheme.CreatedDate = reader.GetDateTime(1);
scheme.EditedDate = reader.GetDateTime(2);
scheme.Name = reader.GetString(3).ToString();
if (reader.GetValue(4) != DBNull.Value)
{
scheme.Comment = reader.GetString(4);
}
list.Add(scheme);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (_db.conn.State == System.Data.ConnectionState.Open)
{
cmd.Connection.Close();
}
}
}
return(list);
}
public void UpdateInterviewScheme(InterviewScheme model)
{
string query = "UPDATE UCL_InterviewScheme SET Name = @Name, Comment = @Comment WHERE Id = @Id";
string id = "@Id";
string name = "@Name";
string comment = "@Comment";
List <string> tempP = new List <string>()
{
id, name, comment
};
List <object> tempV = new List <object>()
{
model.Id, model.Name, model.Comment
};
_question.ExecuteCmd(query, _question.SetParametersList(tempP, tempV));
}
public IActionResult Get_Specific_Interview(int?id)
{
_interviewScheme = new InterviewScheme();
_nationality = new Nationality();
_studyField = new StudyField();
InterviewSchemeVM vm = new InterviewSchemeVM();
var model = _interviewScheme.GetInterviewSchemeAndQuestions(id);
vm = model;
var nationalities = _nationality.GetAllNationalities();
var studyfields = _studyField.GetAllStudyFields();
foreach (var country in nationalities)
{
vm.Countries.Add(new SelectListItem()
{
Text = country.Name, Value = country.Id.ToString()
});
}
foreach (var study in studyfields)
{
vm.Studyfields.Add(new SelectListItem()
{
Text = study.FieldName, Value = study.Id.ToString()
});
}
foreach (var quest in model.Questions)
{
vm.Questions.Add(new QuestionVM()
{
Id = quest.Id, Order = quest.Order, InterviewSchemeId = quest.InterviewSchemeId, Quest = quest.Quest
});
}
vm.Questions = vm.Questions.OrderBy(x => x.Order).ToList();
return(View("../Administration/Specific_Interview_And_Questions", vm));
}
public IActionResult Get_Interview_Modal(string id)
{
Models.ApplicantVM app = new Models.ApplicantVM();
Applicant temp = new Applicant();
app = temp.GetApplicant(id);
InterviewScheme _interviewScheme = new InterviewScheme();
var quest = _interviewScheme.GetInterviewSchemeAndQuestions(app.InterviewScheme.Id);
foreach (var item in quest.Questions)
{
app.InterviewScheme.Questions.Add(new Models.QuestionVM()
{
Id = item.Id, Order = item.Order, Answer = item.Answer, InterviewSchemeId = item.InterviewSchemeId, Quest = item.Quest
});
}
app.InterviewScheme.Questions.OrderBy(x => x.Order).ToList();
return(PartialView("../Interviewer/Partials/DoInterview", app));
}
public IActionResult Pass_InterviewScheme(InterviewSchemeVM model)
{
_interviewScheme = new InterviewScheme();
_nationality = new Nationality();
_studyField = new StudyField();
var id = _interviewScheme.AddInterviewSchema(model);
var nationalities = _nationality.GetAllNationalities();
var studyfields = _studyField.GetAllStudyFields();
foreach (var country in nationalities)
{
model.Countries.Add(new SelectListItem()
{
Text = country.Name, Value = country.Id.ToString()
});
}
foreach (var study in studyfields)
{
model.Studyfields.Add(new SelectListItem()
{
Text = study.FieldName, Value = study.Id.ToString()
});
}
model.Id = id;
var questions = _interviewScheme.GetQuestions(model.Id);
foreach (var quest in questions)
{
model.Questions.Add(new QuestionVM()
{
Id = quest.Id, Answer = quest.Answer, InterviewSchemeId = quest.InterviewSchemeId, Quest = quest.Quest
});
}
return(View("../Administration/CreateQuestionToInterview", model));
}
public IActionResult Get_InterviewScheme_Modal(string id)
{
InterviewScheme _interviewScheme = new InterviewScheme();
var schemes = _interviewScheme.GetSpecificInterviewSchemes(id);
List <SelectListItem> list = new List <SelectListItem>();
foreach (var sch in schemes)
{
list.Add(new SelectListItem()
{
Text = sch.Name, Value = sch.Id.ToString()
});
}
Models.ApplicantVM vm = new Models.ApplicantVM()
{
Id = Guid.Parse(id),
InterviewSchemes = list
};
return(PartialView("../Interviewer/Partials/Add_InterviewScheme", vm));
}
public IActionResult Pass_new_Question(InterviewSchemeVM model)
{
_interviewScheme = new InterviewScheme();
model.Question.InterviewSchemeId = model.Id;
var countquestions = _interviewScheme.GetQuestions(model.Id);
if (countquestions.Count == 0)
{
model.Question.Order = 1;
}
else
{
countquestions = countquestions.OrderBy(x => x.Order).ToList();
var last = countquestions.LastOrDefault();
model.Question.Order = last.Order + 1;
}
_interviewScheme.AddQuestionToInterview(model.Question);
return(RedirectToAction("Get_Specific_Interview", new { id = model.Id }));
}
private InterviewScheme ExecuteReaderSchemeAndQuestions(string query, string query2, string query3, string query4, string id, int?value)
{
_db.Get_Connection();
InterviewScheme temp = new InterviewScheme();
using (cmd.Connection = _db.conn)
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.Clear();
cmd.Parameters.Add(_db.SetParameterWithValue(id, value));
try
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
InterviewScheme ivs;
while (reader.Read())
{
ivs = new InterviewScheme();
ivs.Id = reader.GetInt32(0);
ivs.CreatedDate = reader.GetDateTime(1);
ivs.EditedDate = reader.GetDateTime(2);
ivs.Name = reader.GetString(3);
if (reader.GetValue(4) != DBNull.Value)
{
ivs.Comment = reader.GetString(4);
}
temp = ivs;
}
}
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query2;
cmd.Parameters.Clear();
cmd.Parameters.Add(_db.SetParameterWithValue(id, value));
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
temp.Questions.Add(new Question()
{
Id = reader.GetGuid(0),
Order = reader.GetInt32(1),
Quest = reader.GetString(2).ToString(),
InterviewSchemeId = reader.GetInt32(4)
});
}
}
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query3;
//cmd.Parameters.Clear();
//cmd.Parameters.Add(_db.SetParameterWithValue(id, value));
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
temp.CountryId.Add(reader.GetInt32(2));
}
}
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query4;
//cmd.Parameters.Clear();
//cmd.Parameters.Add(_db.SetParameterWithValue(id, value));
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
temp.StudyFieldId.Add(reader.GetInt32(2));
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (_db.conn.State == System.Data.ConnectionState.Open)
{
cmd.Connection.Close();
}
}
}
return(temp);
}
