private void SaveChange(int id, IDictionary <int, Models.Devices.Device> device) { TeleVision tv = dbconnect.TeleVision.Find(id); tv.State = ((Models.Devices.TeleVision)device[0]).State; tv.Mode = ((Models.Devices.TeleVision)device[0]).Mode; tv.Volume = ((Models.Devices.TeleVision)device[0]).Volume; tv.CurrentChanel = ((Models.Devices.TeleVision)device[0]).Chanel.ToString(); tv.Brightness = ((Models.Devices.TeleVision)device[0]).Brightness; dbconnect.SaveChanges(); }
public void Delete(int id) { try { TeleVision tv = dbconnect.TeleVision.Include(p => p.DVDs).Where(p => p.Id == id).FirstOrDefault(); dbconnect.TeleVision.Remove(tv); dbconnect.SaveChanges(); IDictionary <int, Models.Devices.Device> filtrDevice = new SortedDictionary <int, Models.Devices.Device>(); } catch { IDictionary <int, Models.Devices.Device> filtrDevice = new SortedDictionary <int, Models.Devices.Device>(); } }
protected override void Seed(DevicesContext context) { Device d1 = new Device { Type = "tv", img = "~/Content/Images/MainScreen/tv.jpg" }; Device d2 = new Device { Type = "lamp", img = "~/Content/Images/MainScreen/lamp.jpg" }; Device d3 = new Device { Type = "tr", img = "~/Content/Images/MainScreen/TR.jpg" }; Device d4 = new Device { Type = "kettle", img = "~/Content/Images/MainScreen/kettle.jpg" }; Device d5 = new Device { Type = "fridge", img = "~/Content/Images/MainScreen/fridge.jpg" }; Device d6 = new Device { Type = "cond", img = "~/Content/Images/MainScreen/cond.jpg" }; context.Device.Add(d1); context.Device.Add(d2); context.Device.Add(d3); context.Device.Add(d4); context.Device.Add(d5); context.Device.Add(d6); TeleVision tv = new TeleVision { Name = "Телевизор", State = false, CurrentChanel = "ICTV", Volume = 20, Brightness = 30, Mode = false, Device = d1 }; context.TeleVision.Add(tv); Conditioner c = new Conditioner { Name = "Кондиционер", State = false, Programm = 2, Device = d6 }; DVD d = new DVD { State = false, IsDiskboxOpen = false, IsPlay = false, TeleVision = tv }; Fridge f = new Fridge { Name = "Холодильник", State = false, StateFrize = false, Programm = 1, Device = d5 }; Kettle k = new Kettle { Name = "Чайник", State = false, Device = d4 }; TapRecoder tr = new TapRecoder { Name = "Музыкальный центр", State = false, Mode = false, Volume = 20, Device = d3 }; Lamp l = new Lamp { Name = "Лампа", State = false, Brightness = 20, CurrentColor = 1, Device = d2 }; context.Conditioner.Add(c); context.DVD.Add(d); context.Fridge.Add(f); context.Kettle.Add(k); context.TapeReoder.Add(tr); context.Lamp.Add(l); context.SaveChanges(); }
private void SaveChange(int id, string type, IDictionary <int, Models.Devices.Device> device) { switch (type) { case "cond": Conditioner cond = dbconnect.Conditioner.Find(id); cond.Programm = ((Models.Devices.Conditioner)device[0]).Programm; cond.State = ((Models.Devices.Conditioner)device[0]).State; dbconnect.SaveChanges(); break; case "tr": TapRecoder tr = dbconnect.TapeReoder.Find(id); tr.State = ((Models.Devices.TapRecoder)device[0]).State; tr.Mode = ((Models.Devices.TapRecoder)device[0]).Mode; tr.Volume = ((Models.Devices.TapRecoder)device[0]).Volume; dbconnect.SaveChanges(); break; case "lamp": Lamp lamp = dbconnect.Lamp.Find(id); lamp.State = ((Models.Devices.Lamp)device[0]).State; lamp.CurrentColor = ((Models.Devices.Lamp)device[0]).currentcolor; lamp.Brightness = ((Models.Devices.Lamp)device[0]).Brightness; dbconnect.SaveChanges(); break; case "fridge": Fridge fridge = dbconnect.Fridge.Find(id); fridge.Programm = ((Models.Devices.Fridge)device[0]).Programm; fridge.State = ((Models.Devices.Fridge)device[0]).State; fridge.StateFrize = ((Models.Devices.Fridge)device[0]).StateFrize; dbconnect.SaveChanges(); break; case "kettle": Kettle kettle = dbconnect.Kettle.Find(id); kettle.State = ((Models.Devices.Kettle)device[0]).State; dbconnect.SaveChanges(); break; case "tv": TeleVision tv = dbconnect.TeleVision.Find(id); tv.State = ((Models.Devices.TeleVision)device[0]).State; tv.Mode = ((Models.Devices.TeleVision)device[0]).Mode; tv.Volume = ((Models.Devices.TeleVision)device[0]).Volume; tv.CurrentChanel = ((Models.Devices.TeleVision)device[0]).Chanel.ToString(); tv.Brightness = ((Models.Devices.TeleVision)device[0]).Brightness; dbconnect.SaveChanges(); break; } }
public ActionResult Del(int id, string chanel) { try { switch (chanel) { case "cond": Conditioner c = dbconnect.Conditioner.Find(id); dbconnect.Conditioner.Remove(c); dbconnect.SaveChanges(); break; case "tr": TapRecoder tr = dbconnect.TapeReoder.Find(id); dbconnect.TapeReoder.Remove(tr); dbconnect.SaveChanges(); break; case "lamp": Lamp l = dbconnect.Lamp.Find(id); dbconnect.Lamp.Remove(l); dbconnect.SaveChanges(); break; case "fridge": Fridge f = dbconnect.Fridge.Find(id); dbconnect.Fridge.Remove(f); dbconnect.SaveChanges(); break; case "kettle": Kettle k = dbconnect.Kettle.Find(id); dbconnect.Kettle.Remove(k); dbconnect.SaveChanges(); break; case "tv": TeleVision tv = dbconnect.TeleVision.Include(p => p.DVDs).Where(p => p.Id == id).FirstOrDefault(); dbconnect.TeleVision.Remove(tv); dbconnect.SaveChanges(); break; } IDictionary <int, Models.Devices.Device> filtrDevice = new SortedDictionary <int, Models.Devices.Device>(); return(View("Index", filtrDevice)); } catch { IDictionary <int, Models.Devices.Device> filtrDevice = new SortedDictionary <int, Models.Devices.Device>(); return(View("Index", filtrDevice)); } }
public ActionResult Add(string type, string Namedevice) { switch (type) { case "cond": Device d = new Device { Type = "cond", img = "~/Content/Images/MainScreen/cond.jpg" }; Conditioner c = new Conditioner { Name = Namedevice, State = false, Programm = 2, Device = d }; Session["Filtr"] = type; dbconnect.Conditioner.Add(c); dbconnect.SaveChanges(); break; case "tr": Device d1 = new Device { Type = "tr", img = "~/Content/Images/MainScreen/TR.jpg" }; TapRecoder tr = new TapRecoder { Name = Namedevice, State = false, Mode = false, Volume = 20, Device = d1 }; Session["Filtr"] = type; dbconnect.TapeReoder.Add(tr); dbconnect.SaveChanges(); break; case "lamp": Device d2 = new Device { Type = "lamp", img = "~/Content/Images/MainScreen/lamp.jpg" }; Lamp l = new Lamp { Name = Namedevice, State = false, Brightness = 20, CurrentColor = 1, Device = d2 }; Session["Filtr"] = type; dbconnect.Lamp.Add(l); dbconnect.SaveChanges(); break; case "fridge": Device d3 = new Device { Type = "fridge", img = "~/Content/Images/MainScreen/fridge.jpg" }; Fridge f = new Fridge { Name = Namedevice, State = false, StateFrize = false, Programm = 1, Device = d3 }; Session["Filtr"] = type; dbconnect.Fridge.Add(f); dbconnect.SaveChanges(); break; case "kettle": Device d4 = new Device { Type = "kettle", img = "~/Content/Images/MainScreen/kettle.jpg" }; Kettle k = new Kettle { Name = Namedevice, State = false, Device = d4 }; Session["Filtr"] = type; dbconnect.Kettle.Add(k); dbconnect.SaveChanges(); break; case "tv": Device d5 = new Device { Type = "tv", img = "~/Content/Images/MainScreen/tv.jpg" }; TeleVision tv = new TeleVision { Name = Namedevice, State = false, CurrentChanel = "ICTV", Volume = 20, Brightness = 30, Mode = false, Device = d5 }; DVD dvd = new DVD { State = false, IsDiskboxOpen = false, IsPlay = false, TeleVision = tv }; Session["Filtr"] = type; dbconnect.TeleVision.Add(tv); dbconnect.DVD.Add(dvd); dbconnect.SaveChanges(); break; } IDictionary <int, Models.Devices.Device> filtrDevice = new SortedDictionary <int, Models.Devices.Device>(); return(View("Index", filtrDevice)); }