public void SetParameterIntoUpdateSQL(SqlCommand cmd, int Id, Kage kage) { cmd.Parameters.AddWithValue("@OriginalName", Id); cmd.Parameters.AddWithValue("@Name", kage.Name); cmd.Parameters.AddWithValue("@Price", kage.Price); cmd.Parameters.AddWithValue("@Pieces", kage.NoOfPieces); }
public Kage DeleteKage(Kage kage) { Kage kageToBeDeleted = _kager.Find(k => k.Id == kage.Id); _kager.Remove(kageToBeDeleted); return(kageToBeDeleted); }
public bool Opret(Kage kage) { bool ok = false; // forbindelse til database using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); // sql kald using (SqlCommand cmd = new SqlCommand(INSERT_SQL, conn)) { cmd.Parameters.AddWithValue("@Name", kage.Name); cmd.Parameters.AddWithValue("@Price", kage.Price); cmd.Parameters.AddWithValue("@Pieces", kage.NoOfPieces); try { int rows = cmd.ExecuteNonQuery(); ok = rows == 1; } catch (Exception ex) { ok = false; } } } return(ok); }
public IHttpActionResult PutKage(int id, Kage kage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != kage.Id) { return(BadRequest()); } db.Entry(kage).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!KageExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private Kage ReadNextKage(SqlDataReader reader) { Kage kage = new Kage(); kage.Name = reader.GetString(0); kage.Price = reader.GetDouble(1); kage.NoOfPieces = reader.GetInt32(2); return(kage); }
public IHttpActionResult GetKage(int id) { Kage kage = db.Kages.Find(id); if (kage == null) { return(NotFound()); } return(Ok(kage)); }
public Kage DeleteKage(Kage kage) { Kage fundetkage = _cacheKager.Find(k => k.Id == kage.Id); if (fundetkage != null) { _cacheKager.Remove(fundetkage); SaveKager(_cacheKager); } return(kage); }
public IHttpActionResult PostKage(Kage kage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Kages.Add(kage); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = kage.Id }, kage)); }
public async void Start() { IList <Kage> kager = await HentAlleKager(); foreach (Kage kage in kager) { Console.WriteLine(kage); } Kage k = new Kage("rumkugle", 45, 5); bool erOprettet = await OpretKager(k); Console.WriteLine("Rumkugle er oprettet " + erOprettet); }
public IHttpActionResult DeleteKage(int id) { Kage kage = db.Kages.Find(id); if (kage == null) { return(NotFound()); } db.Kages.Remove(kage); db.SaveChanges(); return(Ok(kage)); }
public bool UpdateKage(Kage kage) { Kage kageToBeUpdated = _kager.Find(k => k.Id == kage.Id); if (kageToBeUpdated == null) { return(false); } kageToBeUpdated.Name = kage.Name; kageToBeUpdated.Price = kage.Price; kageToBeUpdated.NoOfPieces = kage.NoOfPieces; return(true); }
public bool UpdateKage(Kage kage) { Kage fundetkage = _cacheKager.Find(k => k.Id == kage.Id); if (fundetkage != null) { fundetkage.Name = kage.Name; fundetkage.Price = kage.Price; fundetkage.NoOfPieces = kage.NoOfPieces; SaveKager(_cacheKager); return(true); } return(false); }
public Kage Delete(string name) { Kage kage = HentEn(name); // forbindelse til database using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); // sql kald using (SqlCommand cmd = new SqlCommand(DELETE_SQL, conn)) { cmd.Parameters.AddWithValue("@Name", name); cmd.ExecuteNonQuery(); } } return(kage); }
public MainVM() { _kager = new ObservableCollection <Kage>(); _selectedKage = new Kage(); _kageToBeCreated = new Kage(); // commands _load = new RelayCommand(LoadMethod); _save = new RelayCommand(SaveMethod); _updateOne = new RelayCommand(UpdateKage); _deleteOne = new RelayCommand(DeleteKage); _createOne = new RelayCommand(CreateKage); _clearCreateOne = new RelayCommand(ClearCreate); // helping _persitence = PersitenceFactory.GetPersistency(PersistenceType.Database); LoadMethod(); // initilize kager }
private async Task <bool> OpretKager(Kage kage) { bool ok = false; using (HttpClient client = new HttpClient()) { // lave Body String jString = JsonConvert.SerializeObject(kage); StringContent content = new StringContent(jString, Encoding.UTF8, "application/json"); HttpResponseMessage result = await client.PostAsync(URI, content); if (result.IsSuccessStatusCode) { string okRes = await result.Content.ReadAsStringAsync(); ok = JsonConvert.DeserializeObject <bool>(okRes); } } return(ok); }
public Kage HentEn(string name) { Kage kage = new Kage(); // forbindelse til database using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); // sql kald using (SqlCommand cmd = new SqlCommand(GET_ONE_SQL, conn)) { cmd.Parameters.AddWithValue("@Name", name); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { kage = ReadNextKage(reader); } } } return(kage); }
public void SetParameterIntoInsertSQL(SqlCommand cmd, Kage kage) { cmd.Parameters.AddWithValue("@Name", kage.Name); cmd.Parameters.AddWithValue("@Price", kage.Price); cmd.Parameters.AddWithValue("@Pieces", kage.NoOfPieces); }
public Kage DeleteKage(Kage kage) { throw new NotImplementedException(); }
public bool CreateKage(Kage kage) { throw new NotImplementedException(); }
public bool CreateKage(Kage kage) { _cacheKager.Add(kage); SaveKager(_cacheKager); return(true); }
public bool Put(string key, [FromBody] Kage value) { return(mgr.Update(key, value)); }
public bool CreateKage(Kage kage) { _kager.Add(kage); return(true); }
// PUT: api/Kager2/5 public bool Put(int id, [FromBody] Kage value) { return(mgr.Update(id, value)); }
public bool Post([FromBody] Kage value) { return(mgr.Opret(value)); }