Esempio n. 1
0
        //for load data in "new SabDiv" mode
        private void PreviosDataLoad()
        {
            DivRecords.Clear();
            using (DBConteiner db = new DBConteiner())
            {
                try
                {
                    var list = db.SubDivisions.ToList <SubDivision>();

                    foreach (var item in list)
                    {
                        DivRecords.Add(
                            new SubDivision
                        {
                            SubDivisionId = item.SubDivisionId,
                            SubDivName    = item.SubDivName,
                            ParentIdent   = item.ParentIdent,
                            CollapsDate   = item.CollapsDate,
                            CreateDate    = item.CreateDate
                        });
                    }
                }
                catch (ArgumentNullException ex)
                {
                    MessageBox.Show(ex.Message);
                }
                catch (OverflowException ex)
                {
                    MessageBox.Show(ex.Message);
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                    MessageBox.Show(ex.Message);
                }
                catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
                {
                    MessageBox.Show(ex.Message);
                }
                catch (System.Data.Entity.Core.EntityException ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }