// GET api/<controller> public IEnumerable<Recruiter> Get() { try{ List<SqlParameter> sqlParameters = new List<SqlParameter>(); DataTable dt = dp.ExecuteReader("dbo.usp_ReadRecruiters", sqlParameters.ToArray()); List<Recruiter> recruiters = new List<Recruiter>(); foreach (DataRow dr in dt.Rows) { Recruiter rt = new Recruiter(); rt.Id = (int)dr["Id"]; rt.Name = (string)dr["Name"]; recruiters.Add(rt); } return recruiters; } catch (Exception ex) { //Log somewhere this exception throw new Exception("Server Error"); } }
// POST api/<controller> public Recruiter Post(Recruiter recruiter) { String name = recruiter.Name; if (String.IsNullOrEmpty(name)) { throw new Exception("Empty Name"); } try { List<SqlParameter> sqlParams = new List<SqlParameter>(); sqlParams.Add(new SqlParameter("name", name)); DataTable dt = dp.ExecuteReader("dbo.usp_CreateRecruiter", sqlParams.ToArray()); int Id = Int32.Parse(dt.Rows[0]["ID"].ToString()); recruiter.Id = Id; return recruiter; } catch (Exception ex) { //Log somewhere this exception throw new Exception("Server Error"); } }
// PUT api/<controller>/5 public HttpResponseMessage Put(int id,Recruiter recruiter) { string name = recruiter.Name; if (String.IsNullOrEmpty(name) || id <= 0) { return Request.CreateResponse(HttpStatusCode.BadRequest); } try { List<SqlParameter> sqlParams = new List<SqlParameter>(); sqlParams.Add(new SqlParameter("id", id)); sqlParams.Add(new SqlParameter("name", name)); dp.ExecuteCrud("dbo.usp_UpdateRecruiter", sqlParams.ToArray()); return Request.CreateResponse(HttpStatusCode.OK); } catch (Exception ex) { //Log somewhere this exception throw new Exception("Server Error"); } }