public List <RecieverPeople> GetallRecieverPeople()
        {
            string query = "SELECT RecieverId,RecieverName,RecieverArea,RecieverPhoneNo from RecieverPeopleTable ";
            List <RecieverPeople>   asamList = new List <RecieverPeople>();
            DatabaseConnectionClass dcc      = new DatabaseConnectionClass();

            dcc.ConnectWithDB();
            SqlDataReader sdr = dcc.GetData(query);

            while (sdr.Read())
            {
                RecieverPeople ba = new RecieverPeople();


                ba.RecieverId   = sdr["RecieverId"].ToString();
                ba.RecieverName = sdr["RecieverName"].ToString();

                ba.RecieverArea    = sdr["RecieverArea"].ToString();
                ba.RecieverPhoneNo = sdr["RecieverPhoneNo"].ToString();



                asamList.Add(ba);
            }
            return(asamList);
        }
        public List <RecieverPeople> searchRecieverPeople(string text)
        {
            string query13 = "SELECT RecieverId,RecieverName,RecieverArea,RecieverPhoneNo from RecieverPeopleTable WHERE RecieverId LIKE '%" + text + "%'  OR RecieverName LIKE '%" + text + "%'  OR RecieverArea LIKE '%" + text + "%' OR RecieverPhoneNo LIKE '%" + text + "%' ";
            List <RecieverPeople>   modifiedNewList = new List <RecieverPeople>();
            DatabaseConnectionClass dcc             = new DatabaseConnectionClass();

            dcc.ConnectWithDB();
            SqlDataReader sdr = dcc.GetData(query13);

            while (sdr.Read())
            {
                RecieverPeople obj = new RecieverPeople();
                obj.RecieverId      = sdr["RecieverId"].ToString();
                obj.RecieverName    = sdr["RecieverName"].ToString();
                obj.RecieverArea    = sdr["RecieverArea"].ToString();
                obj.RecieverPhoneNo = sdr["RecieverPhoneNo"].ToString();

                modifiedNewList.Add(obj);
            }
            return(modifiedNewList);
        }