private static void delete() { Console.WriteLine("1-Delete in Product\n2-Delete in Update\n"); var input = Convert.ToInt32(Console.ReadLine()); switch (input) { case 1: var db = new UpdateAndProduct(); Console.WriteLine("Enter the Id to be deleted.."); var id = Convert.ToInt32(Console.ReadLine()); var del = (from s in db.products_1 where s.Pid == id select s).FirstOrDefault(); if (del != null) { db.products_1.Attach(del); db.products_1.Remove(del); db.SaveChanges(); } else { Console.WriteLine("ooops You cant delete..."); } break; case 2: var db1 = new UpdateAndProduct(); Console.WriteLine("Enter the Id to be deleted.."); var id1 = Convert.ToInt32(Console.ReadLine()); var del1 = (from s in db1.updates where s.Id == id1 select s).FirstOrDefault(); if (del1 != null) { db1.updates.Attach(del1); db1.updates.Remove(del1); db1.SaveChanges(); } else { Console.WriteLine("ooops You cant delete..."); } break; } }
private static void add() { Console.WriteLine("1-Add in Product\n2-Add in Update\n"); var input = Convert.ToInt32(Console.ReadLine()); switch (input) { case 1: var db1 = new UpdateAndProduct(); Console.WriteLine("Enter the name.."); var name1 = Console.ReadLine(); Console.WriteLine("Enter Description.."); var description1 = Console.ReadLine(); Console.WriteLine("Enter HomePage Url.."); var Url1 = Console.ReadLine(); db1.products_1.Add(new ProductModel { Pname = name1, Pdescription = description1, HomePageUrl = Url1, }); db1.SaveChanges(); break; case 2: var db = new UpdateAndProduct(); Console.WriteLine("Enter the name.."); var name = Console.ReadLine(); Console.WriteLine("Enter Description.."); var description = Console.ReadLine(); Console.WriteLine("Enter Product Id.."); var pid = Convert.ToInt32(Console.ReadLine()); db.updates.Add(new UpdateModel { Name = name, Description = description, Pid = pid }); db.SaveChanges(); break; } }
private static void update() { Console.WriteLine("1-Update in Product\n2-Update in Update\n"); var input = Convert.ToInt32(Console.ReadLine()); switch (input) { case 1: var db1 = new UpdateAndProduct(); Console.WriteLine("Enter Id.."); var Id1 = Convert.ToInt32(Console.ReadLine()); var update1 = (from s in db1.products_1 where s.Pid == Id1 select s).FirstOrDefault(); if (update1 != null) { Console.WriteLine("Enter Field to be updated..Name,Description Or Home Url.."); Console.WriteLine("Enter new Name.."); var Name = Console.ReadLine(); Console.WriteLine("Enter New Description.."); var Description = Console.ReadLine(); Console.WriteLine("Enter new HomepageUrl.."); var HomeUrl = Console.ReadLine(); if (Name != "") { update1.Pname = Name; } if (Description != "") { update1.Pdescription = Description; } if (HomeUrl != "") { update1.HomePageUrl = HomeUrl; } db1.products_1.Update(update1); db1.SaveChanges(); } else { Console.WriteLine("No Record found..."); } break; case 2: var db = new UpdateAndProduct(); Console.WriteLine("Enter Product Id ..."); var Id = Convert.ToInt32(Console.ReadLine()); var update = (from s in db.updates where s.Pid == Id select s).FirstOrDefault(); if (update != null) { Console.WriteLine("Enter Field to be updated..Name,Description.."); Console.WriteLine("Enter new Name.."); var Name = Console.ReadLine(); Console.WriteLine("Enter New Description.."); var Description = Console.ReadLine(); Console.WriteLine("Enter new HomepageUrl.."); var HomeUrl = Console.ReadLine(); if (Name != "") { update.Name = Name; } if (Description != "") { update.Description = Description; } db.updates.Update(update); db.SaveChanges(); } else { Console.WriteLine("No Record found..."); } break; } }