public IHttpActionResult Put(Sermon sermon)
{
var sermonToUpdate = sermons.FirstOrDefault(p => p.Talk.id == sermon.Talk.id);
var index = sermons.IndexOf(sermonToUpdate);
sermons[index] = sermon;
return Ok(sermon);
}
public IHttpActionResult Delete(Sermon sermon)
{
var sermonToDelete = sermons.FirstOrDefault(p => p.Talk.id == sermon.Talk.id);
var index = sermons.IndexOf(sermonToDelete);
sermons.RemoveAt(index);
return Ok();
}
public IHttpActionResult Post(Sermon sermon)
{
var nextId = sermons.Count + 1;
sermon.Talk.id = nextId;
sermons.Add(sermon);
try
{
using (var conn = new SqlConnection(connectionString))
using (var command = new SqlCommand("CreateTalk", conn)
{
CommandType = CommandType.StoredProcedure
})
{
conn.Open();
command.Parameters.AddWithValue("@id", sermon.id);
command.Parameters.AddWithValue("@talk_id", sermon.Talk.id);
command.Parameters.AddWithValue("@talk_code", sermon.Talk.code);
command.Parameters.AddWithValue("@Talktype", sermon.Talktype);
command.Parameters.AddWithValue("@Title", sermon.Title);
command.Parameters.AddWithValue("@refStart_book", sermon.refStart.Book);
command.Parameters.AddWithValue("@refStart_chapter", sermon.refStart.Chapter);
command.Parameters.AddWithValue("@refStart_verse", sermon.refStart.Verse);
command.Parameters.AddWithValue("@refEnd_book", sermon.refEnd.Book);
command.Parameters.AddWithValue("@refEnd_chapter", sermon.refEnd.Chapter);
command.Parameters.AddWithValue("@refEnd_verse", sermon.refEnd.Verse);
//command.Parameters.AddWithValue("@Date", sermon.DateTime.Date);
command.Parameters.AddWithValue("@series_id", sermon.Series.id);
command.Parameters.AddWithValue("@Series_title", sermon.Series.Title);
command.Parameters.AddWithValue("@mp3_location", sermon.mp3.location);
command.Parameters.AddWithValue("@video_location", sermon.Video.location);
command.Parameters.AddWithValue("@Speaker", sermon.Speaker);
command.Parameters.AddWithValue("@Thumbnail", sermon.Thumbnail);
command.ExecuteNonQuery();
conn.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return CreatedAtRoute("Default", new { id = nextId }, sermon);
}
