Esempio n. 1
0
        //===================THIS METHOD IS FOR DELETE RECORDS IN DIRECTIONS TABLE==============
        public void DeleteDir()
        {
            using (StudentuConteiner db = new StudentuConteiner())
            {
                try
                {
                    var res = db.Orderlines;

                    if (Dir.DirectionName != "---" && !CheckRecordBeforDelete(Dir))
                    {
                        if (dialogService.YesNoDialog("Точно нужно удалить эту запись?") == true)
                        {
                            //changing DB
                            //we find all the records in which we have the desired Id and make a replacement
                            foreach (OrderLine order in res)
                            {
                                if (order.Direction.DirectionId == Dir.DirectionId)
                                {
                                    order.Direction = db.Directions.Find(new Direction()
                                    {
                                        DirectionId = 1
                                    }.DirectionId);
                                }
                            }
                            db.Directions.Remove(db.Directions.Find(Dir.DirectionId));
                            db.SaveChanges();

                            //changing collection
                            AuthorDirections.Remove(Dir);
                            DirRecords.Remove(Dir);

                            Dir          = DirRecords[0];
                            SelectedDir2 = Dir;
                        }
                    }
                    else
                    {
                        dialogService.ShowMessage("Нельзя удалить эту запись");
                    }
                }
                catch (ArgumentNullException ex)
                {
                    dialogService.ShowMessage(ex.Message);
                }
                catch (OverflowException ex)
                {
                    dialogService.ShowMessage(ex.Message);
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                    dialogService.ShowMessage(ex.Message);
                }
                catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
                {
                    dialogService.ShowMessage(ex.Message);
                }
                catch (System.Data.Entity.Core.EntityException ex)
                {
                    dialogService.ShowMessage(ex.Message);
                }
            }
        }