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