public int Add(CareerPosts obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = INSERTCareerPosts; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = obj.ID; parameterID.Direction = ParameterDirection.Output; _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 parameterJobID = new SqlParameter(PN_JOBID, SqlDbType.Int); parameterJobID.Value = obj.JobID; parameterJobID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterJobID); SqlParameter parameterDate = new SqlParameter(PN_DATE, SqlDbType.NVarChar); parameterDate.Value = obj.Date; parameterDate.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterDate); SqlParameter parameterExperiences = new SqlParameter(PN_EXPERIENCES, SqlDbType.NVarChar); parameterExperiences.Value = obj.Experiences; parameterExperiences.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterExperiences); SqlParameter parameterCVDocument = new SqlParameter(PN_CVDOCUMENT, SqlDbType.NVarChar); parameterCVDocument.Value = obj.CVDocument; parameterCVDocument.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterCVDocument); SqlParameter parameterCVText = new SqlParameter(PN_CVTEXT, SqlDbType.NVarChar); parameterCVText.Value = obj.CVText; parameterCVText.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterCVText); SqlParameter parameterImage = new SqlParameter(PN_IMAGE, SqlDbType.NVarChar); parameterImage.Value = obj.Image; parameterImage.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterImage); SqlParameter parameterPhone = new SqlParameter(PN_PHONE, SqlDbType.NVarChar); parameterPhone.Value = obj.Phone; parameterPhone.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterPhone); SqlParameter parameterTitle = new SqlParameter(PN_TITLE, SqlDbType.NVarChar); parameterTitle.Value = obj.Title; parameterTitle.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterTitle); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(parameterID.Value); return obj.ID; }
public void PopulateCareerPosts(SqlDataReader _dtr, CareerPosts obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_JOBID); if (!_dtr.IsDBNull(columnIndex)) { obj.JobID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_DATE); if (!_dtr.IsDBNull(columnIndex)) { obj.Date = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_EXPERIENCES); if (!_dtr.IsDBNull(columnIndex)) { obj.Experiences = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_CVDOCUMENT); if (!_dtr.IsDBNull(columnIndex)) { obj.CVDocument = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_CVTEXT); if (!_dtr.IsDBNull(columnIndex)) { obj.CVText = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_IMAGE); if (!_dtr.IsDBNull(columnIndex)) { obj.Image = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_PHONE); if (!_dtr.IsDBNull(columnIndex)) { obj.Phone = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CareerPostsDataMapper.CN_TITLE); if (!_dtr.IsDBNull(columnIndex)) { obj.Title = _dtr.GetString((columnIndex)); } }
public CareerPosts GetCareerPosts(SqlDataReader _dtr, IList<CareerPosts> colobj) { CareerPosts obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new CareerPosts(); colobj.Add(obj); } return obj; }
public IList<CareerPosts> GetAll() { CareerPosts obj = null; IList<CareerPosts> colobj = new List<CareerPosts>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTALLCareerPosts; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new CareerPosts(); colobj = new List<CareerPosts>(); while (_dtreader.Read()) { obj = GetCareerPosts(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
private void GetEntityFromReader(SqlDataReader _dtr, CareerPosts obj) { PopulateCareerPosts(_dtr, obj); }
public CareerPosts GetByID(int ID) { CareerPosts obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTCareerPosts; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_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 CareerPosts(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public static void Update(CareerPosts obj) { CareerPostsDataMapper objCaller = new CareerPostsDataMapper(); objCaller.Update(obj); }
public static int Add(CareerPosts obj) { CareerPostsDataMapper objCaller = new CareerPostsDataMapper(); return objCaller.Add(obj); }