public CasseteAboutViewModel(int id) { SaveCommand = new RelayCommand(o => SaveButtonClick("SaveButton")); CancelCommand = new RelayCommand(o => CancelCommandClick("CancelButton")); ConnectToDB(); cat_id = id; if (database != null) { try { cassetes = database.Cassetes.Find(id); _title = cassetes.Title; _director = cassetes.Director; _departament = cassetes.Departament_Id; _cover = API.Image.ByteArrayToImage(cassetes.Cover); _price = cassetes.Price; } catch (Exception e) { MessageBox.Show(e.Message); } } else { MessageBox.Show("Запись не найдена."); } }
private void GetTotalInfo() { try { ReturnTotal.Clear(); rs = new Model.RentalShopEntities(); OrderInfo orderInfo; Model.Cassete_Rentals cassete_Rentals = rs.Cassete_Rentals.Find(int.Parse(OrderID)); if (cassete_Rentals != null) { Model.Cassetes cassete = rs.Cassete_Copies.Where(s => s.Copy_Id == cassete_Rentals.Copy_Id).FirstOrDefault <Model.Cassete_Copies>().Cassetes; if (rs.Cassete_Copies.Where(s => s.Copy_Id == cassete_Rentals.Copy_Id).FirstOrDefault <Model.Cassete_Copies>().Status == "busy") { Cover = API.Image.ByteArrayToImage(cassete.Cover); ReturnTotal.Add(new ReturnInfo { Title = "Клиент", Value = cassete_Rentals.Clients.First_Name + " " + cassete_Rentals.Clients.Second_Name }); ReturnTotal.Add(new ReturnInfo { Title = "Номер клиента", Value = cassete_Rentals.Clients.Client_Id.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Логин клиента", Value = cassete_Rentals.Clients.Login }); ReturnTotal.Add(new ReturnInfo { Title = "Номер копии", Value = cassete_Rentals.Copy_Id.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Кассета", Value = cassete.Title }); ReturnTotal.Add(new ReturnInfo { Title = "Номер кассеты", Value = cassete.Catalog_Id.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Дата получения", Value = cassete_Rentals.Give_Date.Date.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Дата возврата", Value = cassete_Rentals.Get_Date.Date.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Утеряна", Value = IsLose.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Номер отдела", Value = cassete_Rentals.Departament_Id.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Адрес отдела", Value = cassete_Rentals.Departaments.State + ", " + cassete_Rentals.Departaments.City + ", " + cassete_Rentals.Departaments.Street + ", " + cassete_Rentals.Departaments.Zip }); ReturnTotal.Add(new ReturnInfo { Title = "Цена за кассету в сутки", Value = cassete.Price.ToString() }); ReturnTotal.Add(new ReturnInfo { Title = "Цена по договору", Value = (((cassete_Rentals.Get_Date - cassete_Rentals.Give_Date).Days) * Convert.ToInt32(cassete.Price)).ToString() }); copy = rs.Cassete_Copies.Where(s => s.Copy_Id == cassete_Rentals.Copy_Id).FirstOrDefault <Model.Cassete_Copies>(); } else { MessageBox.Show("Заказ уже завершен"); ReturnTotal.Clear(); Cover = null; IsLose = false; } } else { MessageBox.Show("Заказ не найден"); Cover = null; IsLose = false; } } catch (Exception e) { MessageBox.Show(e.Message); } }