public Job GetJobInfo(int jobid) { SqlConnection cn = new SqlConnection(cnstr); SqlCommand cmd = new SqlCommand ("Select * from jobs where job_id=" + jobid, cn); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); Job j = new Job(); if (dr.Read()) { j.Id = jobid; j.Description = dr["job_desc"].ToString(); j.minlvl = Convert.ToInt32(dr["min_lvl"]); j.maxlvl = Convert.ToInt32(dr["max_lvl"]); } else { j.Id = -1; } cn.Close(); return j; }
public void AddJob(Job j) { throw new NotImplementedException(); }