Ejemplo n.º 1
0
        private void FillList()
        {
            DBConnection.cmd.CommandType = CommandType.StoredProcedure;

            if (Properties.Settings.Default.nameBranch == Properties.Settings.Default.nameOffice)
            {
                DBConnection.cmd.CommandText = "sp_displayFollowUPBranch";
                DBConnection.cmd.Parameters.Add(new SqlParameter("@Branch", SqlDbType.Int));
                DBConnection.cmd.Parameters["@Branch"].Value = Properties.Settings.Default.Branch;
            }
            else
            {
                DBConnection.cmd.CommandText = "sp_displayFollowUPOffice";
                DBConnection.cmd.Parameters.Add(new SqlParameter("@Office", SqlDbType.Int));
                DBConnection.cmd.Parameters["@Office"].Value = Properties.Settings.Default.Office;
            }

            DBConnection.cmd.Parameters.Add(new SqlParameter("@Success", SqlDbType.Int));

            DBConnection.cmd.Parameters["@Success"].Direction = ParameterDirection.Output;

            Follow_up TR;

            try
            {
                list.Clear();

                DBConnection.OpenConnection();

                DBConnection.reader = DBConnection.cmd.ExecuteReader();

                while (DBConnection.reader.Read())
                {
                    TR              = new Follow_up();
                    TR.DecisionNO   = DBConnection.reader.GetInt64(0).ToString();
                    TR.fullname     = DBConnection.reader.GetString(1);
                    TR.ReceivedDate = DBConnection.reader.GetDateTime(2);
                    TR.VisitDate2   = DBConnection.reader.GetString(3);
                    TR.DeliverDate2 = DBConnection.reader.GetString(4);
                    TR.Distance2    = DBConnection.reader.GetString(5);
                    TR.FStatus2     = DBConnection.reader.GetString(6);
                    TR.Scribe_ssn2  = DBConnection.reader.GetString(7);
                    TR.Observer_ssn = DBConnection.reader.GetString(8);


                    list.Add(TR);
                }
                _list2.Clear();
                _list2.AddRange(list.ToList <Follow_up>());
            }
            catch (Exception ex)
            {
                MessageBox.Show("خطا في عرض البيانات" + Environment.NewLine + ex.Message.ToString(), "", MessageBoxButton.OK, MessageBoxImage.Error,
                                MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
            }
            finally
            {
                DBConnection.CloseConnection();
            }
        }
        private void FillList()
        {
            DBConnection.cmd.CommandType = CommandType.StoredProcedure;

            if (Properties.Settings.Default.nameBranch == Properties.Settings.Default.nameOffice)
            {
                DBConnection.cmd.CommandText = "sp_displayFollowUPObserverBranch";
                DBConnection.cmd.Parameters.Add(new SqlParameter("@Branch", SqlDbType.Int));
                DBConnection.cmd.Parameters["@Branch"].Value = Properties.Settings.Default.Branch;
            }
            else
            {
                DBConnection.cmd.CommandText = "sp_displayFollowUPObserverOffice";
                DBConnection.cmd.Parameters.Add(new SqlParameter("@Office", SqlDbType.Int));
                DBConnection.cmd.Parameters["@Office"].Value = Properties.Settings.Default.Office;
            }

            DBConnection.cmd.Parameters.Add(new SqlParameter("@Observer_ssn", SqlDbType.BigInt));
            DBConnection.cmd.Parameters.Add(new SqlParameter("@Success", SqlDbType.Int));

            DBConnection.cmd.Parameters["@Observer_ssn"].Value = Properties.Settings.Default.EmpNo;
            DBConnection.cmd.Parameters["@Success"].Direction  = ParameterDirection.Output;

            Follow_up TR;

            try
            {
                List.Clear();

                DBConnection.OpenConnection();

                DBConnection.reader = DBConnection.cmd.ExecuteReader();

                while (DBConnection.reader.Read())
                {
                    TR = new Follow_up
                    {
                        DecisionNO      = DBConnection.reader.GetInt64(0).ToString(),
                        fullname        = DBConnection.reader.GetString(1),
                        Phone           = DBConnection.reader.GetString(2),
                        Office          = DBConnection.reader.GetString(3),
                        LastConnection2 = DBConnection.reader.GetString(4),
                        Notice          = DBConnection.reader.GetString(5),
                        Comment         = DBConnection.reader.GetString(6)
                    };


                    List.Add(TR);
                }
                _list2.Clear();
                _list2.AddRange(List.ToList <Follow_up>());
            }
            catch (Exception ex)
            {
                MessageBox.Show("خطا في عرض البيانات" + Environment.NewLine + ex.Message.ToString(), "", MessageBoxButton.OK, MessageBoxImage.Error,
                                MessageBoxResult.OK, MessageBoxOptions.RightAlign | MessageBoxOptions.RtlReading);
            }
            finally
            {
                DBConnection.CloseConnection();
            }
        }