public static void ProductChangeName(int x, string newname) { using (var db = new ProductBaseSet()) { var singleBaseItem = db.MyBase .Single(b => b.ProductDefinitionId == x); singleBaseItem.ProductName = newname; db.SaveChanges(); } }
public static void ProductRemove(int x) { using (var db = new ProductBaseSet()) { var singleBaseItem = db.MyBase .Single(b => b.ProductDefinitionId == x); db.MyBase.Remove(singleBaseItem); db.SaveChanges(); } }
public static void DisplayBase() { using (var db = new ProductBaseSet()) { var products = db.MyBase.ToList(); foreach (var n in products) { Console.WriteLine($"|NumerID: {n.ProductDefinitionId,-2}|Tytuł: {n.ProductName,-30}| rok produkcji: {n.YearOfProduction,-8}|"); } } }
public void AddBase() { using (var db = new ProductBaseSet()) { db.MyBase.Add( new ProductDefinition { ProductName = Name, ProductDescription = Description, YearOfProduction = Yearofproduction, ActualPrice = Price } ); db.SaveChanges();//Zmienić plik konfiguracyjny } }
public static void BaseClean() { using (var db = new ProductBaseSet()) { List <int> numery = new List <int>(); var lista = db.MyBase.ToList(); foreach (var n in lista) { numery.Add(n.ProductDefinitionId); } foreach (var n in numery) { var singleBaseItem = db.MyBase .Single(b => b.ProductDefinitionId == n); db.MyBase.Remove(singleBaseItem); db.SaveChanges(); } } }