Esempio n. 1
0
        public bool UpdateList(PrayerDAO PD)
        {
            bool success = false;

            try
            {
                using (SqlConnection _connection = new SqlConnection(connectionstring))
                {
                    using (SqlCommand _command = new SqlCommand("sp_UpdateList", _connection))
                    {
                        _command.CommandType = CommandType.StoredProcedure;
                        _command.Parameters.AddWithValue("@ListID", PD.ListID);
                        _command.Parameters.AddWithValue("@Firstname", PD.Firstname);
                        _command.Parameters.AddWithValue("@Lastname", PD.Lastname);
                        _command.Parameters.AddWithValue("@DateAdded", PD.DateAdded);
                        _command.Parameters.AddWithValue("@Situation", PD.Situation);
                        _command.Parameters.AddWithValue("@AddedBy", PD.AddedBy);
                        _connection.Open();
                        _command.ExecuteNonQuery();
                        success = true;
                        _connection.Close();
                    }
                }
            }
            catch (Exception error)
            {
                Errorlog Problem = new Errorlog();
                Problem.LogError(error);
            }

            return(success);
        }
Esempio n. 2
0
        public PrayerDAO Map(Prayer _prayertomap)
        {
            PrayerDAO _prayertoview = new PrayerDAO();

            _prayertoview.ListID    = _prayertomap.ListID;
            _prayertoview.Firstname = _prayertomap.Firstname;
            _prayertoview.Lastname  = _prayertomap.Lastname;
            _prayertoview.DateAdded = _prayertomap.DateAdded;
            _prayertoview.Situation = _prayertomap.Situation;
            _prayertoview.AddedBy   = _prayertomap.AddedBy;
            _prayertoview.Username  = _prayertomap.Username;
            return(_prayertoview);
        }
Esempio n. 3
0
        public List <PrayerDAO> GetPList()
        {
            //Create List Variables named plist.
            List <PrayerDAO> _Plist = new List <PrayerDAO>();

            try
            {
                //connect to database.
                using (SqlConnection _connection = new SqlConnection(connectionstring))
                {
                    using (SqlCommand _command = new SqlCommand("sp_ViewList", _connection))
                    {
                        _command.CommandType = CommandType.StoredProcedure;
                        _connection.Open();
                        using (SqlDataReader _reader = _command.ExecuteReader())
                        {
                            while (_reader.Read())
                            {
                                DateTime  datetime;
                                PrayerDAO _prayertoList = new PrayerDAO();
                                _prayertoList.ListID    = _reader.GetInt32(0);
                                _prayertoList.Firstname = _reader.GetString(1);
                                _prayertoList.Lastname  = _reader.GetString(2);
                                _prayertoList.DateAdded = _reader.GetDateTime(3);
                                datetime = _prayertoList.DateAdded;
                                string date = datetime.ToString("MM/dd/yyyy");
                                _prayertoList.date      = date;
                                _prayertoList.Situation = _reader.GetString(4);
                                _prayertoList.AddedBy   = _reader.GetInt32(5);
                                _prayertoList.Username  = _reader.GetString(6);
                                _Plist.Add(_prayertoList);
                            }
                        }
                    }
                }
            }
            catch (Exception error)
            {
                Errorlog Problem = new Errorlog();
                Problem.LogError(error);
            }

            return(_Plist);
        }