public int Insert(PeopleAddRequest model) { int result = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { string cmdText = "Eddie_Dozier_Insert"; using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parm = new SqlParameter(); parm.ParameterName = "@Id"; parm.SqlDbType = System.Data.SqlDbType.Int; parm.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(parm); cmd.Parameters.AddWithValue("@FirstName", model.FirstName); cmd.Parameters.AddWithValue("@MiddleInitial", model.MiddleInitial); cmd.Parameters.AddWithValue("@LastName", model.LastName); cmd.Parameters.AddWithValue("@DOB", model.DOB); cmd.Parameters.AddWithValue("@ModifiedBy", model.ModifiedBy); conn.Open(); cmd.ExecuteNonQuery(); result = (int)cmd.Parameters["@Id"].Value; conn.Close(); } } return(result); }
public int Insert(PeopleAddRequest model) { int result = 0; cmd.CommandText = "People_Insert"; //out parameter from SQL SqlParameter param = new SqlParameter(); param.ParameterName = "@Id"; param.SqlDbType = System.Data.SqlDbType.Int; param.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@FirstName", model.FirstName); cmd.Parameters.AddWithValue("@MiddleInitial", model.MiddleInitial); cmd.Parameters.AddWithValue("@LastName", model.LastName); cmd.Parameters.AddWithValue("@DOB", model.DOB); cmd.Parameters.AddWithValue("@ModifiedBy", model.ModifiedBy); conn.Open(); cmd.ExecuteNonQuery(); //explicitly casting int with (int) in front of cmd bc know an int is being returned from SQL result = (int)cmd.Parameters["@Id"].Value; conn.Close(); return(result); }
public void Insert_Test() { PeopleAddRequest model = new PeopleAddRequest { FirstName = "Ronald", MiddleInitial = 'J', LastName = "McDonald", DOB = DateTime.Now.AddYears(-30), ModifiedBy = "Me" }; PeopleService svc = new PeopleService(); int result = svc.Insert(model); Assert.IsTrue(result > 0, "The insert Failed!"); }
public void Insert_Test() { //arrange PeopleAddRequest model = new PeopleAddRequest { FirstName = "Ronald", MiddleInitial = 'J', LastName = "McDonald", DOB = DateTime.Now.AddYears(-30), ModifiedBy = "DEM" }; //act int result = svc.Insert(model); //assert Assert.IsTrue(result > 0, "The Insert failed!"); }
public void Insert_Test() { // Assign PeopleAddRequest model = new PeopleAddRequest { FirstName = "Old", MiddleInitial = 'G', LastName = "Man", DOB = DateTime.Now.AddYears(-25), ModifiedBy = "me" }; // Act PeopleService svc = new PeopleService(); int result = svc.Insert(model); // Assert Assert.IsTrue(result > 0, "The insert failed!"); }
public IActionResult Post([FromBody] PeopleAddRequest model) { try { if (ModelState.IsValid) { model.ModifiedBy = "me"; PeopleService svc = new PeopleService(); ItemResponse <int> response = new ItemResponse <int>(); response.Item = svc.Insert(model); return(Ok(response)); } else { return(BadRequest(ModelState)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public HttpResponseMessage Post([FromBody] PeopleAddRequest model) { try { if (ModelState.IsValid) { model.ModifiedBy = "me"; PeopleService svc = new PeopleService(); ItemResponse <int> response = new ItemResponse <int>(); response.Item = svc.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage Post([FromBody] PeopleAddRequest model) { try { if (ModelState.IsValid) { //placeholder before authenticaction in place model.ModifiedBy = "me"; ItemResponse <int> response = new ItemResponse <int>(); response.Item = svc.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public void Delete_Test() { //arrange PeopleAddRequest test = new PeopleAddRequest { FirstName = "Test", LastName = "Test", DOB = DateTime.Now, ModifiedBy = "Test" }; int deleteTest = svc.Insert(test); //act svc.Delete(deleteTest); People getDeleted = svc.GetById(deleteTest); //assert Assert.IsNull(getDeleted.FirstName, "Delete has failed!"); Assert.IsNull(getDeleted.LastName, "Delete has failed!"); Assert.IsFalse(test.DOB == getDeleted.DOB, "Delete has failed"); Assert.IsNull(getDeleted.ModifiedBy, "Delete has failed!"); }