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); }