public async Task <string> SavePepperAsync(PepperModel model) { SqlCommand insert = new SqlCommand("insert into Peppers values(@id, @name);", conn); insert.Parameters.AddWithValue("@id", model.ID); insert.Parameters.AddWithValue("@name", model.Name); conn.Open(); try { SqlDataAdapter dataAdapter = new SqlDataAdapter(); dataAdapter.InsertCommand = insert; await dataAdapter.InsertCommand.ExecuteNonQueryAsync(); conn.Close(); return("Ok"); } catch (Exception e) { conn.Close(); return(e.ToString()); } }
public async Task <HttpResponseMessage> UpdatePepperAsync(PepperModel model) { int response = await _service.UpdatePepperAsync(model); if (response == 200) { return(Request.CreateResponse(HttpStatusCode.OK, "Successfully updated database.")); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Unsuccessful!")); } }
public async Task <HttpResponseMessage> SavePepperAsync(PepperModel model) { string response = await _service.SavePepperAsync(model); if (response == "Ok") { return(Request.CreateResponse(HttpStatusCode.OK, "Successfully updated database.")); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, response)); } }
public async Task <int> UpdatePepperAsync(PepperModel model) { SqlCommand update = new SqlCommand("update Peppers set PepperName = @name where PepperID = @id;", conn);; update.Parameters.AddWithValue("@id", model.ID); update.Parameters.AddWithValue("@name", model.Name); conn.Open(); try { await update.ExecuteNonQueryAsync(); conn.Close(); return(200); } catch (Exception) { conn.Close(); return(400); } }
public async Task <List <PepperModel> > GetAllPeppersAsync() { SqlCommand show = new SqlCommand("select * from Peppers;", conn); List <PepperModel> peppers = new List <PepperModel>(); conn.Open(); SqlDataReader reader = await show.ExecuteReaderAsync(); try { string name = ""; int id; if (reader.HasRows) { while (await reader.ReadAsync()) { id = reader.GetInt32(0); name = reader.GetString(1); PepperModel pepper = new PepperModel(); pepper.ID = id; pepper.Name = name; peppers.Add(pepper); } } reader.Close(); conn.Close(); return(peppers); } catch (Exception) { conn.Close(); return(null); } }
public async Task <int> UpdatePepperAsync(PepperModel model) { return(await Repository.UpdatePepperAsync(model)); }
public async Task <string> SavePepperAsync(PepperModel model) { return(await Repository.SavePepperAsync(model)); }