/// <summary>
/// Deletes the certification details.
/// </summary>
/// <param name="objDeleteCertificationDetails">The object delete certification details.</param>
public void DeleteCertificationDetails(BusinessEntities.CertificationDetails objDeleteCertificationDetails)
{
//Initialise Data Access Class object
objDA = new DataAccessClass();
//Initialise SqlParameter Class object
sqlParam = new SqlParameter[2];
try
{
//Open the connection to DB
objDA.OpenConnection(DBConstants.GetDBConnectionString());
//Check each parameters nullibality and add values to sqlParam object accordingly
sqlParam[0] = new SqlParameter(SPParameter.CertificationId, SqlDbType.Int);
if (objDeleteCertificationDetails.CertificationId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objDeleteCertificationDetails.CertificationId;
}
sqlParam[1] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objDeleteCertificationDetails.EMPId == 0)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objDeleteCertificationDetails.EMPId;
}
//Execute SP along with proper parameters
objDA.ExecuteNonQuerySP(SPNames.Employee_DeleteCertificationDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, DELETECERTIFICATIONDETAILS, EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Updates the certification details.
/// </summary>
/// <param name="objUpdateCertificationDetails">The obj update certification details.</param>
public void UpdateCertificationDetails(BusinessEntities.CertificationDetails objUpdateCertificationDetails)
{
//Object declaration of CertificationDetails class
Rave.HR.DataAccessLayer.Employees.CertificationDetails objUpdateCertificationDetailsDAL;
try
{
//Created new instance of CertificationDetails class to call UpdateCertificationDetails() of Data access layer
objUpdateCertificationDetailsDAL = new Rave.HR.DataAccessLayer.Employees.CertificationDetails();
//Call to UpdateCertificationDetails() of Data access layer
objUpdateCertificationDetailsDAL.UpdateCertificationDetails(objUpdateCertificationDetails);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, UPDATECERTIFICATIONDETAILS, EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Gets the certification details.
/// </summary>
/// <param name="objGetCertificationDetails">The obj get certification details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetCertificationDetails(BusinessEntities.CertificationDetails objGetCertificationDetails)
{
//Object declaration of QualificationDetails class
Rave.HR.DataAccessLayer.Employees.CertificationDetails objGetCertificationDetailsDAL;
try
{
//Created new instance of QualificationDetails class to call objGetQualificationDetailsDAL() of Data access layer
objGetCertificationDetailsDAL = new Rave.HR.DataAccessLayer.Employees.CertificationDetails();
//Call to GetQualificationDetails() of Data access layer and return the Qualifications
return(objGetCertificationDetailsDAL.GetCertificationDetails(objGetCertificationDetails));
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, GETCERTIFICATIONDETAILS, EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Adds the certification details.
/// </summary>
/// <param name="objAddCertificationDetails">The object add certification details.</param>
public void AddCertificationDetails(BusinessEntities.CertificationDetails objAddCertificationDetails)
{
//Initialise Data Access Class object
objDA = new DataAccessClass();
//Initialise SqlParameter Class object
sqlParam = new SqlParameter[6];
try
{
//Open the connection to DB
objDA.OpenConnection(DBConstants.GetDBConnectionString());
//Check each parameters nullibality and add values to sqlParam object accordingly
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objAddCertificationDetails.EMPId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objAddCertificationDetails.EMPId;
}
sqlParam[1] = new SqlParameter(SPParameter.CertificationName, SqlDbType.NChar, 10);
if (objAddCertificationDetails.CertificationName == "" || objAddCertificationDetails.CertificationName == null)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objAddCertificationDetails.CertificationName;
}
sqlParam[2] = new SqlParameter(SPParameter.CertificateDate, SqlDbType.DateTime);
if (objAddCertificationDetails.CertificateDate == null)
{
sqlParam[2].Value = DBNull.Value;
}
else
{
sqlParam[2].Value = objAddCertificationDetails.CertificateDate;
}
sqlParam[3] = new SqlParameter(SPParameter.CertificateValidDate, SqlDbType.DateTime);
if (objAddCertificationDetails.CertificateValidDate == null || objAddCertificationDetails.CertificateValidDate == DateTime.MinValue)
{
sqlParam[3].Value = DBNull.Value;
}
else
{
sqlParam[3].Value = objAddCertificationDetails.CertificateValidDate;
}
sqlParam[4] = new SqlParameter(SPParameter.Score, SqlDbType.Float);
if (objAddCertificationDetails.Score == 0)
{
sqlParam[4].Value = DBNull.Value;
}
else
{
sqlParam[4].Value = objAddCertificationDetails.Score;
}
sqlParam[5] = new SqlParameter(SPParameter.OutOf, SqlDbType.Float);
if (objAddCertificationDetails.OutOf == 0)
{
sqlParam[5].Value = DBNull.Value;
}
else
{
sqlParam[5].Value = objAddCertificationDetails.OutOf;
}
//Execute SP along with proper parameters
objDA.ExecuteNonQuerySP(SPNames.Employee_AddCertificationDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, ADDCERTIFICATIONDETAILS, EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Gets the certification details.
/// </summary>
/// <param name="objGetCertificationDetails">The object get certification details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetCertificationDetails(BusinessEntities.CertificationDetails objGetCertificationDetails)
{
//Initialise Data Access Class object
objDA = new DataAccessClass();
//Initialise SqlParameter Class object
sqlParam = new SqlParameter[1];
//Initialise Collection class object
raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
//Open the connection to DB
objDA.OpenConnection(DBConstants.GetDBConnectionString());
//Check each parameters nullibality and add values to sqlParam object accordingly
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objGetCertificationDetails.EMPId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objGetCertificationDetails.EMPId;
}
objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetCertificationDetails, sqlParam);
while (objDataReader.Read())
{
//Initialise the Business Entity object
objCertificationDetails = new BusinessEntities.CertificationDetails();
objCertificationDetails.CertificationId = Convert.ToInt32(objDataReader[DbTableColumn.CId].ToString());
objCertificationDetails.EMPId = Convert.ToInt32(objDataReader[DbTableColumn.EMPId].ToString());
objCertificationDetails.CertificationName = objDataReader[DbTableColumn.CertificationName].ToString();
objCertificationDetails.CertificateDate = Convert.ToDateTime(objDataReader[DbTableColumn.CertificateDate].ToString());
if (objDataReader[DbTableColumn.CertificateValidDate].ToString() != "")
{
objCertificationDetails.CertificateValidDate = Convert.ToDateTime(objDataReader[DbTableColumn.CertificateValidDate].ToString());
}
objCertificationDetails.Score = float.Parse(objDataReader[DbTableColumn.Score].ToString());
objCertificationDetails.OutOf = float.Parse(objDataReader[DbTableColumn.OutOf].ToString());
// Add the object to Collection
raveHRCollection.Add(objCertificationDetails);
}
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, GETCERTIFICATIONDETAILS, EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
if (objDataReader != null)
{
objDataReader.Close();
}
objDA.CloseConncetion();
}
// Return the Collection
return(raveHRCollection);
}
