public static void UpdateCard(IDictionary <string, object> newValues)
{
using (var db = new CardContext())
{
int id = Convert.ToInt32(newValues["id"]);
Card myCard = db.Cards.FirstOrDefault(x => x.id == id);
myCard.name = newValues["name"].ToString();
if (newValues["description"] != null)
{
myCard.description = newValues["description"].ToString();
}
foreach (var item in newValues)
{
if (item.Key != "name" && item.Key != "id" && item.Key != "description" && item.Key.Length > 0)
{
Specifications spec = (Specifications)Enum.Parse(typeof(Specifications), item.Key);
if (myCard.cardParams.Any(x => x.key == spec))
{
if (item.Value != null)
{
myCard.cardParams.First(x => x.key == spec).value = Convert.ToInt32(item.Value);
}
else
{
db.Entry(myCard.cardParams.First(x => x.key == spec)).State = EntityState.Deleted;
}
}
else
{
if (item.Value != null)
{
db.CardParamses.Add(new CardParams()
{
card = myCard,
key = spec,
value = Convert.ToInt32(item.Value)
});
}
}
}
}
db.Entry(myCard).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void DeleteCard(string Id)
{
using (var db = new CardContext())
{
var myCard = new Card {
id = Convert.ToInt32(Id)
};
db.Cards.Attach(myCard);
db.Entry(myCard).State = EntityState.Deleted;
db.SaveChanges();
}
}
