public int Create(LocationAddRequest model, int userId)
{
int id = 0;
string procName = "[dbo].[Locations_Insert]";
_data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col)
{
AddCommonParams(model, col);
col.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
}, returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
int.TryParse(oId.ToString(), out id);
Console.WriteLine("");
});
return(id);
}
public ActionResult <ItemResponse <int> > Create(LocationAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int>()
{
Item = id
};
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}
//post
public int Insert(LocationAddRequest model)
{
int id = 0;
Adapter.ExecuteQuery(new DbCmdDef
{
DbCommandText = "dbo.Location_Insert",
DbCommandType = System.Data.CommandType.StoredProcedure,
DbParameters = new[]
{
SqlDbParameter.Instance.BuildParameter("@LocationName", model.LocationName, System.Data.SqlDbType.NVarChar, 50),
SqlDbParameter.Instance.BuildParameter("@LocationDescription", model.LocationDescription, System.Data.SqlDbType.NVarChar, 300),
SqlDbParameter.Instance.BuildParameter("@StreetAddress", model.StreetAddress, System.Data.SqlDbType.NVarChar, 50),
SqlDbParameter.Instance.BuildParameter("@City", model.City, System.Data.SqlDbType.NVarChar, 50),
SqlDbParameter.Instance.BuildParameter("@State", model.State, System.Data.SqlDbType.NVarChar, 50),
SqlDbParameter.Instance.BuildParameter("@PostalCode", model.PostalCode, System.Data.SqlDbType.NVarChar, 50),
SqlDbParameter.Instance.BuildParameter("@LocationUrl", model.LocationUrl, System.Data.SqlDbType.NVarChar, 200),
SqlDbParameter.Instance.BuildParameter("@Id", id, System.Data.SqlDbType.Int, paramDirection : ParameterDirection.Output),
}
},
delegate(IDataParameterCollection param)
{
Int32.TryParse(param["@Id"].ToString(), out id);
});
return(id);
}
public bool Add(LocationAddRequest location)
{
try
{
return(_locationRepository.Add(location));
}
catch (Exception ex)
{
throw ex;
}
}
private static void AddCommonParams(LocationAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@LocationTypeId", model.LocationTypeId);
col.AddWithValue("@LineOne", model.LineOne);
col.AddWithValue("@LineTwo", model.LineTwo);
col.AddWithValue("@City", model.City);
col.AddWithValue("@Zip", model.Zip);
col.AddWithValue("@StateId", model.StateId);
col.AddWithValue("@Latitude", model.Latitude);
col.AddWithValue("@Longitude", model.Longitude);
}
public IActionResult Add([FromBody] LocationAddRequest location)
{
try
{
return(Ok(_locationService.Add(location)));
}
catch (Exception ex)
{
message = ex.Message;
_log.LogError(message);
return(StatusCode(StatusCodes.Status500InternalServerError, message));
}
}
private static void InputCommonParams(LocationAddRequest request, SqlParameterCollection col)
{
col.AddWithValue("@LocationTypeId", request.LocationTypeId);
col.AddWithValue("@LineOne", request.LineOne);
if (request.LineTwo != null)
{
col.AddWithValue("@LineTwo", request.LineTwo);
}
else
{
col.AddWithValue("@LineTwo", DBNull.Value);
}
col.AddWithValue("@City", request.City);
col.AddWithValue("@Zip", request.Zip);
col.AddWithValue("@StateId", request.StateId);
col.AddWithValue("@Latitude", request.Latitude);
col.AddWithValue("@Longitude", request.Longitude);
}
public bool Add(LocationAddRequest location)
{
try
{
SqlConnection sqlconn = new SqlConnection(connectionString);
SqlCommand sqlComm = new SqlCommand("newLocation");
sqlconn.Open();
sqlComm.Connection = sqlconn;
sqlComm.CommandType = CommandType.StoredProcedure;
sqlComm.Parameters.AddWithValue("@location", location.Location);
sqlComm.ExecuteNonQuery();
sqlconn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage PostLocation(LocationAddRequest model)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
//ItemResponse<int> response = new ItemResponse<int>();
//response.Item = _organicLocation.Insert(model);
int locations = _locationService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, locations));
}
catch (Exception ex)
{
//logError(MethodBase.GetCurrentMethod().Name, ex);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public int Add(LocationAddRequest request, int currentUserId)
{
int id = 0;
string procName = "[dbo].[Locations_Insert_V2]";
_data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col)
{
InputCommonParams(request, col);
col.AddWithValue("@CreatedBy", currentUserId);
SqlParameter idOutPut = new SqlParameter("@Id", SqlDbType.Int);
idOutPut.Direction = ParameterDirection.Output;
col.Add(idOutPut);
}, returnParameters : delegate(SqlParameterCollection returnCol)
{
object objectId = returnCol["@Id"].Value;
int.TryParse(objectId.ToString(), out id);
});
return(id);
}
