public Basecamp Edit(Basecamp basecamp)
{
try
{
connection.Open();
var cmd = connection.CreateCommand() as SqlCommand;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Basecamp_Edit";
cmd.Parameters.Add(new SqlParameter("@basecampid", basecamp.Id));
cmd.Parameters.Add(new SqlParameter("@longitude", basecamp.Longitude));
cmd.Parameters.Add(new SqlParameter("@latitude", basecamp.Latitude));
cmd.Parameters.Add(new SqlParameter("@probability", basecamp.Probability));
cmd.Parameters.Add(new SqlParameter("@name", basecamp.DetailName));
cmd.Parameters.Add(new SqlParameter("@shortText", basecamp.ShortText));
cmd.Parameters.Add(new SqlParameter("@id", basecamp.IdDb));
cmd.ExecuteNonQuery();
connection.Close();
return basecamp;
}
catch (Exception ex)
{
throw ex;
}
}
public Basecamp Insert(Basecamp basecamp)
{
try
{
connection.Open();
var cmd = connection.CreateCommand() as SqlCommand;
//cmd.CommandText = "INSERT INTO BasecampDetails (BasecampId, Location, Probability, Name) values(@basecampid, geography::STPointFromText('POINT(' + CAST(@longitude AS VARCHAR(20)) + ' ' + CAST(@latitude AS VARCHAR(20)) + ')', 4326), @probability, @name) SET @ID = SCOPE_IDENTITY()";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Basecamp_Insert";
cmd.Parameters.Add(new SqlParameter("@basecampid", basecamp.Id));
cmd.Parameters.Add(new SqlParameter("@longitude", basecamp.Longitude));
cmd.Parameters.Add(new SqlParameter("@latitude", basecamp.Latitude));
cmd.Parameters.Add(new SqlParameter("@probability", basecamp.Probability));
cmd.Parameters.Add(new SqlParameter("@name", basecamp.DetailName));
cmd.Parameters.Add(new SqlParameter("@shortText", basecamp.ShortText));
var idParameter = new SqlParameter("@ID", SqlDbType.Int) { Direction = ParameterDirection.Output };
cmd.Parameters.Add(idParameter);
cmd.ExecuteNonQuery();
//var id = (int)idParameter.Value;
//basecamp.Id = id;
connection.Close();
return basecamp;
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage<Basecamp> Post(Basecamp basecamp, HttpRequestMessage<Basecamp> request)
{
if (basecamp != null)
{
var basecampDb = basecampRepository.Insert(basecamp);
var response = new HttpResponseMessage<Basecamp>(basecampDb) { StatusCode = HttpStatusCode.Created };
return response;
}
return new HttpResponseMessage<Basecamp>(null) { StatusCode = HttpStatusCode.NotFound, };
}
public Basecamp Insert(Basecamp basecamp)
{
try
{
connection.Open();
var cmd = connection.CreateCommand() as SqlCommand;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Basecamp_Insert";
cmd.Parameters.Add(new SqlParameter("@longitude", basecamp.Longitude));
cmd.Parameters.Add(new SqlParameter("@latitude", basecamp.Latitude));
cmd.Parameters.Add(new SqlParameter("@hpLongitude", basecamp.HotPointLong));
cmd.Parameters.Add(new SqlParameter("@hpLatitude", basecamp.HotPointLat));
cmd.Parameters.Add(new SqlParameter("@probability", basecamp.Probability));
cmd.Parameters.Add(new SqlParameter("@name", basecamp.DetailName));
cmd.Parameters.Add(new SqlParameter("@shortText", basecamp.ShortText));
cmd.Parameters.Add(new SqlParameter("@region", basecamp.RegionId));
cmd.Parameters.Add(new SqlParameter("@show", basecamp.Show));
var idParameter = new SqlParameter("@ID", SqlDbType.Int) { Direction = ParameterDirection.Output };
cmd.Parameters.Add(idParameter);
cmd.ExecuteNonQuery();
connection.Close();
return basecamp;
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage Recalculate(Basecamp basecamp, HttpRequestMessage<Basecamp> request)
{
try
{
if(basecamp.Id != 0)
{
basecampRepository.RecalculateDistance(basecamp.Id, false);
}
else
{
basecampRepository.RecalculateDistance(basecamp.RegionId, true);
}
return new HttpResponseMessage { StatusCode = HttpStatusCode.OK };
}
catch
{
return new HttpResponseMessage { StatusCode = HttpStatusCode.InternalServerError };
}
}
