public static List <JobOrder> GetPlacements()
{
SqlConnection conn = DB.DbWriteOnlyConnect();
conn.Open();
string queryString = "SELECT * FROM CRM_JobOrders j, CRM_Placements p WHERE j.id = p.jobId ORDER BY p.startDate DESC";
SqlCommand getPlacements = new SqlCommand(queryString, conn);
SqlDataReader jobsReader = getPlacements.ExecuteReader();
List <JobOrder> m_Jobs = new List <JobOrder>();
while (jobsReader.Read())
{
JobOrder m_Job = new JobOrder();
m_Job.Id = jobsReader.GetInt32(0);
m_Job.DateAquired = jobsReader.GetDateTime(1);
m_Job.CompanyId = jobsReader.GetInt32(2);
m_Job.PositionTitle = jobsReader.GetString(3);
m_Job.Salary = jobsReader.GetInt32(22);
m_Job.Education = jobsReader.GetString(5);
m_Job.RecruitmentFee = jobsReader.GetInt32(6);
if (!jobsReader.IsDBNull(19))
{
m_Job.DatePlaced = jobsReader.GetDateTime(19);
}
m_Job.KeyWords = jobsReader.GetString(9);
m_Job.Requirements = jobsReader.GetString(10);
m_Job.Duties = jobsReader.GetString(11);
m_Job.ContactId = jobsReader.GetInt32(12);
m_Job.ContactType = jobsReader.GetString(13);
Companies m_Comp = DBCompany.RetrieveOne(m_Job.CompanyId);
m_Job.CompanyName = m_Comp.Name;
m_Jobs.Add(m_Job);
}
conn.Close();
return(m_Jobs);
}
public static Candidate RetrieveOne(int id)
{
SqlConnection conn = DB.DbReadOnlyConnect();
conn.Open();
string queryString = "SELECT * FROM CRM_Candidates WHERE id = @id";
SqlCommand getCand = new SqlCommand(queryString, conn);
getCand.Parameters.AddWithValue("id", id);
SqlDataReader candReader = getCand.ExecuteReader();
Candidate m_Cand = new Candidate();
if (candReader.Read())
{
m_Cand.Id = candReader.GetInt32(0);
m_Cand.Date = candReader.GetDateTime(1);
m_Cand.LastName = candReader.GetString(2);
m_Cand.FirstName = candReader.GetString(3);
m_Cand.Email = candReader.GetString(4);
m_Cand.Resume = candReader.GetString(5);
m_Cand.Noncompete = (int)candReader.GetByte(6);
m_Cand.OptOut = (int)candReader.GetByte(7);
m_Cand.ResumeLastUpdate = candReader.GetDateTime(8);
m_Cand.ResumeBinary = candReader.GetSqlBytes(9).Buffer;
m_Cand.CompanyId = candReader.GetInt32(10);
Companies m_Company = DBCompany.RetrieveOne(m_Cand.CompanyId);
m_Cand.CompanyName = m_Company.Name;
m_Cand.FileType = candReader.GetString(11);
}
conn.Close();
return(m_Cand);
}
