public void Update(Volunteer obj)
        {
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = UPDATEVolunteer;

            #region [Parameters]
            SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
            parameterID.Value = obj.ID;
            parameterID.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterID);
            SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
            parameterName.Value = obj.Name;
            parameterName.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterName);
            SqlParameter parameterEmail = new SqlParameter(PN_EMAIL, SqlDbType.NVarChar);
            parameterEmail.Value = obj.Email;
            parameterEmail.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterEmail);
            SqlParameter parameterCV = new SqlParameter(PN_CV, SqlDbType.NVarChar);
            parameterCV.Value = obj.CV;
            parameterCV.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterCV);
            SqlParameter parameterMessage = new SqlParameter(PN_MESSAGE, SqlDbType.NVarChar);
            parameterMessage.Value = obj.Message;
            parameterMessage.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterMessage);
            #endregion;

            _connection.Open();
            _command.ExecuteNonQuery();
            _connection.Close();
        }
Exemple #2
0
 public void PopulateVolunteer(SqlDataReader _dtr, Volunteer obj)
 {
     int columnIndex = 0;
     columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_ID);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.ID = _dtr.GetInt32((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_NAME);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.Name = _dtr.GetString((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_EMAIL);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.Email = _dtr.GetString((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_CV);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.CV = _dtr.GetString((columnIndex));
     }
     columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_MESSAGE);
     if (!_dtr.IsDBNull(columnIndex))
     {
         obj.Message = _dtr.GetString((columnIndex));
     }
 }
 public Volunteer GetVolunteer(SqlDataReader _dtr, IList<Volunteer> colobj)
 {
     Volunteer obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
     if (null == obj)
     {
         obj = new Volunteer();
         colobj.Add(obj);
     }
     return obj;
 }
        public IList<Volunteer> GetAll()
        {

            Volunteer obj = null;

            IList<Volunteer> colobj = null;
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = SELECTALLVolunteer;

            _connection.Open();
            try
            {
                using (_dtreader = _command.ExecuteReader())
                {
                    if (_dtreader != null && _dtreader.HasRows)
                    {
                        obj = new Volunteer();
                        colobj = new List<Volunteer>();
                        while (_dtreader.Read())
                        {
                            obj = GetVolunteer(_dtreader, colobj);
                            GetEntityFromReader(_dtreader, obj);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

                _dtreader.Close();
                _connection.Close();
            }

            return colobj;
        }
 private void GetEntityFromReader(SqlDataReader _dtr, Volunteer obj)
 {
     PopulateVolunteer(_dtr, obj);
 }
        public Volunteer GetByID(int ID)
        {

            Volunteer obj = null;
            _connection.ConnectionString = _ConnectionString;
            _command.Connection = _connection;
            _command.CommandType = CommandType.StoredProcedure;
            _command.CommandText = SELECTVolunteer;

            #region [Parameters]
            SqlParameter parameterID = new SqlParameter(CN_ID, SqlDbType.Int);
            parameterID.Value = ID;
            parameterID.Direction = ParameterDirection.Input;
            _command.Parameters.Add(parameterID);
            #endregion;

            _connection.Open();
            try
            {
                using (_dtreader = _command.ExecuteReader())
                {
                    if (_dtreader != null && _dtreader.HasRows)
                    {
                        obj = new Volunteer();
                        if (_dtreader.Read())
                            GetEntityFromReader(_dtreader, obj);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {

                _dtreader.Close();
                _connection.Close();
            }

            return obj;
        }
Exemple #7
0
        public static void Update(Volunteer obj)
        {
            VolunteerDataMapper objCaller = new VolunteerDataMapper();

            objCaller.Update(obj);
        }
Exemple #8
0
        public static int Add(Volunteer obj)
        {
            VolunteerDataMapper objCaller = new VolunteerDataMapper();

            return objCaller.Add(obj);
        }