public List <Job> GetAllJobs() { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlWrapper().Wrapper("Jobs_getall", con); using (SqlDataReader reader = cmd.ExecuteReader()) { List <Job> jobs = null; while (reader.Read()) { Job job = new Job(); job.Id = reader.GetInt32(0); job.JobId = reader.GetString(1); job.Title = reader.GetString(2); job.Url = reader.GetString(3); job.Company = reader.GetString(4); job.Description = reader.GetString(5); job.Location = reader.GetString(6); job.DateApplied = reader["date_applied"] is DBNull ? (DateTime?)null : (DateTime?)reader["date_applied"]; job.Archived = reader.GetBoolean(8); job.QuickApply = reader.GetBoolean(9); job.DateCreated = reader.GetDateTime(10); job.DateModified = reader.GetDateTime(11); if (jobs == null) { jobs = new List <Job>(); } jobs.Add(job); } return(jobs); } } }
public Job GetById(int id) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlWrapper().Wrapper("jobs_getbyid", con); cmd.Parameters.AddWithValue("@id", id); using (SqlDataReader reader = cmd.ExecuteReader()) { Job job = new Job(); reader.Read(); job.Id = reader.GetInt32(0); job.JobId = reader.GetString(1); job.Title = reader.GetString(2); job.Url = reader.GetString(3); job.Company = reader.GetString(4); job.Description = reader.GetString(5); job.Location = reader.GetString(6); job.DateApplied = reader["date_applied"] is DBNull ? (DateTime?)null : (DateTime?)reader["date_applied"]; job.Archived = reader.GetBoolean(8); job.QuickApply = reader.GetBoolean(9); job.DateCreated = reader.GetDateTime(10); job.DateModified = reader.GetDateTime(11); return(job); } } }
public object GetUserByLogin <T>(string spName, SqlParameter[] parameters, Func <SqlDataReader, T> callback) { var result = SqlWrapper.ExecuteReader(CommandType.StoredProcedure, spName, parameters, callback); return((IEnumerable <T>)result); }
public IEnumerable <LinkEntity> ExecuteReader(string spName, Func <SqlDataReader, LinkEntity> callback = null, SqlParameter[] parameters = null) { return((IEnumerable <LinkEntity>)_wrapper.ExecuteReader(CommandType.StoredProcedure, spName, parameters, callback)); }