public int Insert(ConcernAddRequest model)
{
int returnVal = 0;
_dataProvider.ExecuteNonQuery("concern_insert",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@Id";
parm.SqlDbType = System.Data.SqlDbType.Int;
parm.Direction = System.Data.ParameterDirection.Output;
paramCol.Add(parm);
paramCol.AddWithValue("@CityDepartment", model.CityDepartment);
if (model.FileReference == null)
{
paramCol.AddWithValue("@FileReference", System.DBNull.Value);
}
else
{
paramCol.AddWithValue("@FileReference", model.FileReference);
}
paramCol.AddWithValue("@ConcernTitle", model.ConcernTitle);
paramCol.AddWithValue("@ConcernDescription", model.ConcernDescription);
paramCol.AddWithValue("@ConcernLevel", 1);
paramCol.AddWithValue("@Status", "Reported");
paramCol.AddWithValue("@Address", model.Address);
paramCol.AddWithValue("@City", model.City);
paramCol.AddWithValue("@State", model.State);
paramCol.AddWithValue("@Zip", model.Zip);
if (model.Longitude == null)
{
paramCol.AddWithValue("@Longitude", System.DBNull.Value);
}
else
{
paramCol.AddWithValue("@Longitude", model.Longitude);
}
if (model.Latitude == null)
{
paramCol.AddWithValue("@Latitude", System.DBNull.Value);
}
else
{
paramCol.AddWithValue("@Latitude", model.Latitude);
}
},
returnParameters : delegate(SqlParameterCollection paramCol)
{
returnVal = (int)paramCol["@Id"].Value;
}
);
return(returnVal);
}
public HttpResponseMessage Insert(ConcernAddRequest model)
{
try
{
if (ModelState.IsValid)
{
ItemResponse <int> resp = new ItemResponse <int>();
resp.Item = _concernService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
