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);
}
