public clsProfile getProfileByEmailAddress(string emailAddress)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "[dbo].[sp_getProfileByEmail]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@EMAILADDRESS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, emailAddress));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
clsProfile businessObject = new clsProfile();
//
PopulateBusinessObjectFromReader(businessObject, dataReader);
//
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
String mess = ex.Message;
throw new Exception("clsProfile::getProfile::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
public clsProfile getProfile(clsProfileKeys keys)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "[dbo].[sp_getProfile]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@empID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.EMP_ID));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
clsProfile businessObject = new clsProfile();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("clsProfile::getProfile::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
public bool UpdateProfile(clsProfile businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "[dbo].[sp_updateProfile]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
//sqlCommand.Parameters.Add(new SqlParameter("@IMGPATH", businessObject.IMAGE_PATH));
//sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID));
//sqlCommand.Parameters.Add(new SqlParameter("@CEL_NO", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CEL_NO));
//sqlCommand.Parameters.Add(new SqlParameter("@HOMEPHONE", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.HOMEPHONE));
//sqlCommand.Parameters.Add(new SqlParameter("@LOCATION", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LOCATION));
//sqlCommand.Parameters.Add(new SqlParameter("@LOCAL", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LOCAL));
//sqlCommand.Parameters.Add(new SqlParameter("@EMAIL_ADD2", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMAIL_ADDRESS2));
//sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.SmallInt, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS));
//sqlCommand.Parameters.Add(new SqlParameter("@DATEREVIEWED", SqlDbType.DateTime, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DT_REVIEWED));
//MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("clsProfile::updateProfile::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(clsProfile businessObject, IDataReader dataReader)
{
businessObject.EMP_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsProfile.clsProfileFields.EMP_ID.ToString()));
businessObject.WS_EMP_ID = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.WS_EMP_ID.ToString()));
businessObject.DEPT_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsProfile.clsProfileFields.DEPT_ID.ToString()));
businessObject.LAST_NAME = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.LAST_NAME.ToString()));
businessObject.FIRST_NAME = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.FIRST_NAME.ToString()));
//MIDDLENAME
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.MIDDLE_NAME.ToString())))
{
businessObject.MIDDLE_NAME = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.MIDDLE_NAME.ToString()));
}
else
{
businessObject.MIDDLE_NAME = String.Empty;
}
//NICKNAME
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.NICK_NAME.ToString())))
{
businessObject.NICK_NAME = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.NICK_NAME.ToString()));
}
else
{
businessObject.NICK_NAME = String.Empty;
}
//BIRTHDATE
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.BIRTHDATE.ToString())))
{
businessObject.BIRTHDATE = dataReader.GetDateTime(dataReader.GetOrdinal(clsProfile.clsProfileFields.BIRTHDATE.ToString()));
}
else
{
businessObject.BIRTHDATE = DateTime.Today;
}
//DATEHIRED
businessObject.DATE_HIRED = dataReader.GetDateTime(dataReader.GetOrdinal(clsProfile.clsProfileFields.DATE_HIRED.ToString()));
//IMAGE_PATH
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.IMAGE_PATH.ToString())))
{
businessObject.IMAGE_PATH = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.IMAGE_PATH.ToString()));
}
else
{
businessObject.IMAGE_PATH = String.Empty;
}
//DEPARTMENT
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.DEPARTMENT.ToString())))
{
businessObject.DEPARTMENT = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.DEPARTMENT.ToString()));
}
else
{
businessObject.DEPARTMENT = string.Empty;
}
//DIVISION
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.DIVISION.ToString())))
{
businessObject.DIVISION = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.DIVISION.ToString()));
}
else
{
businessObject.DIVISION = string.Empty;
}
//POSITION
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.POSITION.ToString())))
{
businessObject.POSITION = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.POSITION.ToString()));
}
else
{
businessObject.POSITION = string.Empty;
}
//EMAIL_ADDRESS
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.EMAIL_ADDRESS.ToString())))
{
businessObject.EMAIL_ADDRESS = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.EMAIL_ADDRESS.ToString()));
}
else
{
businessObject.EMAIL_ADDRESS = string.Empty;
}
//EMAIL_ADDRESS2
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.EMAIL_ADDRESS2.ToString())))
{
businessObject.EMAIL_ADDRESS2 = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.EMAIL_ADDRESS2.ToString()));
}
else
{
businessObject.EMAIL_ADDRESS2 = string.Empty;
}
//LOCATION
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.LOCATION.ToString())))
{
businessObject.LOCATION = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.LOCATION.ToString()));
}
else
{
businessObject.LOCATION = string.Empty;
}
//CEL_NO
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.CEL_NO.ToString())))
{
businessObject.CEL_NO = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.CEL_NO.ToString()));
}
else
{
businessObject.CEL_NO = string.Empty;
}
//LOCAL
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.LOCAL.ToString())))
{
businessObject.LOCAL = dataReader.GetInt32(dataReader.GetOrdinal(clsProfile.clsProfileFields.LOCAL.ToString()));
}
else
{
businessObject.LOCAL = 0;
}
//HOMEPHONE
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.HOMEPHONE.ToString())))
{
businessObject.HOMEPHONE = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.HOMEPHONE.ToString()));
}
else
{
businessObject.HOMEPHONE = string.Empty;
}
//OTHERPHONE
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.OTHER_PHONE.ToString())))
{
businessObject.OTHER_PHONE = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.OTHER_PHONE.ToString()));
}
else
{
businessObject.OTHER_PHONE = string.Empty;
}
//OTHERPHONE
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.DT_REVIEWED.ToString())))
{
businessObject.DT_REVIEWED = dataReader.GetDateTime(dataReader.GetOrdinal(clsProfile.clsProfileFields.DT_REVIEWED.ToString()));
}
else
{
businessObject.DT_REVIEWED = DateTime.Now;
}
//OTHERPHONE
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.Permission.ToString())))
{
businessObject.PERMISSION = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.Permission.ToString()));
}
else
{
businessObject.PERMISSION = string.Empty;
}
//CIVILSTATUS
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsProfile.clsProfileFields.CivilStatus.ToString())))
{
businessObject.CIVILSTATUS = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.CivilStatus.ToString()));
}
else
{
businessObject.CIVILSTATUS = string.Empty;
}
businessObject.SHIFT_STATUS = dataReader.GetString(dataReader.GetOrdinal(clsProfile.clsProfileFields.SHIFT_STATUS.ToString()));
}
