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 }; } }