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