public void GetQualifiedCandidates(int JobPostingID)
{
List <User> AllQualifiedCandidates = new List <User>();
SqlConnection con;
con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["key"].ConnectionString;
SqlCommand GetQualifiedCandidatesCommand;
GetQualifiedCandidatesCommand = new SqlCommand("");
GetQualifiedCandidatesCommand.CommandType = CommandType.StoredProcedure;
GetQualifiedCandidatesCommand.Connection = con;
GetQualifiedCandidatesCommand.CommandText = "JobMatch";
SqlParameter JobPostingIdParameter;
JobPostingIdParameter = new SqlParameter();
JobPostingIdParameter.ParameterName = "@JobID";
JobPostingIdParameter.SqlDbType = SqlDbType.Int;
JobPostingIdParameter.Direction = ParameterDirection.Input;
JobPostingIdParameter.Value = JobPostingID;
GetQualifiedCandidatesCommand.Parameters.Add(JobPostingIdParameter);
con.Open();
SqlDataReader QualifiedCandidatesReader;
QualifiedCandidatesReader = GetQualifiedCandidatesCommand.ExecuteReader();
while (QualifiedCandidatesReader.Read())
{
User QualifiedCandidates = new User();
QualifiedCandidates.UserID = Convert.ToInt32(QualifiedCandidatesReader["UserID"]);
QualifiedCandidates.FirstName = QualifiedCandidatesReader["FirstName"].ToString();
QualifiedCandidates.LastName = QualifiedCandidatesReader["LastName"].ToString();
QualifiedCandidates.Phone = QualifiedCandidatesReader["Phone"].ToString();
QualifiedCandidates.UserEmail = QualifiedCandidatesReader["Email"].ToString();
QualifiedCandidates.Profession = QualifiedCandidatesReader["Profession"].ToString();
QualifiedCandidates.Region = QualifiedCandidatesReader["Region"].ToString();
QualifiedCandidates.CoverLetter = QualifiedCandidatesReader["CoverLetter"].ToString();
QualifiedCandidates.Resume = QualifiedCandidatesReader["Resume"].ToString();
AllQualifiedCandidates.Add(QualifiedCandidates);
}
QualifiedCandidatesReader.Close();
con.Close();
var js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(AllQualifiedCandidates));
}
public void AllCandidates()
{
List <User> AllQualifiedCandidates = new List <User>();
SqlConnection con;
con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["key"].ConnectionString;
SqlCommand GetQualifiedCandidatesCommand;
GetQualifiedCandidatesCommand = new SqlCommand("");
GetQualifiedCandidatesCommand.CommandType = CommandType.StoredProcedure;
GetQualifiedCandidatesCommand.Connection = con;
GetQualifiedCandidatesCommand.CommandText = "GetAllCandidates";
con.Open();
SqlDataReader QualifiedCandidatesReader;
QualifiedCandidatesReader = GetQualifiedCandidatesCommand.ExecuteReader();
while (QualifiedCandidatesReader.Read())
{
User QualifiedCandidate = new User();
//Check if the row is unqiue
if (Convert.ToInt32(QualifiedCandidatesReader["UserID"]) != QualifiedCandidate2.UserID)
{
if (QualifiedCandidate2.UserID != 0)
{
AllQualifiedCandidates.Add(QualifiedCandidate2);
}
QualifiedCandidate.UserID = Convert.ToInt32(QualifiedCandidatesReader["UserID"]);
QualifiedCandidate.FirstName = QualifiedCandidatesReader["FirstName"].ToString();
QualifiedCandidate.LastName = QualifiedCandidatesReader["LastName"].ToString();
QualifiedCandidate.Phone = QualifiedCandidatesReader["Phone"].ToString();
QualifiedCandidate.UserEmail = QualifiedCandidatesReader["Email"].ToString();
QualifiedCandidate.Profession = QualifiedCandidatesReader["Profession"].ToString();
QualifiedCandidate.Region = QualifiedCandidatesReader["Region"].ToString();
QualifiedCandidate.Skillset = QualifiedCandidatesReader["Skillset"].ToString();
QualifiedCandidate.CoverLetter = QualifiedCandidatesReader["CoverLetter"].ToString();
QualifiedCandidate.Resume = QualifiedCandidatesReader["Resume"].ToString();
QualifiedCandidate2 = QualifiedCandidate;
}
//Same user row
else
{
if (!QualifiedCandidate2.Profession.Contains(QualifiedCandidatesReader["Profession"].ToString()))
{
QualifiedCandidate2.Profession = QualifiedCandidate2.Profession + ", " + QualifiedCandidatesReader["Profession"].ToString();
}
if (!QualifiedCandidate2.Region.Contains(QualifiedCandidatesReader["Region"].ToString()))
{
QualifiedCandidate2.Region = QualifiedCandidate2.Region + ", " + QualifiedCandidatesReader["Region"].ToString();
}
if (!QualifiedCandidate2.Skillset.Contains(QualifiedCandidatesReader["Skillset"].ToString()))
{
QualifiedCandidate2.Skillset = QualifiedCandidate2.Skillset + ", " + QualifiedCandidatesReader["Skillset"].ToString();
}
}
}
AllQualifiedCandidates.Add(QualifiedCandidate2);
QualifiedCandidatesReader.Close();
con.Close();
var js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(AllQualifiedCandidates));
}
