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(); }
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; }
public static void Update(Volunteer obj) { VolunteerDataMapper objCaller = new VolunteerDataMapper(); objCaller.Update(obj); }
public static int Add(Volunteer obj) { VolunteerDataMapper objCaller = new VolunteerDataMapper(); return objCaller.Add(obj); }