/// <summary>
/// Deletes the Resume details.
/// </summary>
/// <param name="objDeleteProjectDetails">The obj delete project details.</param>
public void DeleteResumeDetails(BusinessEntities.ProjectDetails objDeleteProjectDetails)
{
objDA = new DataAccessClass();
sqlParam = new SqlParameter[2];
try
{
objDA.OpenConnection(DBConstants.GetDBConnectionString());
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objDeleteProjectDetails.EMPId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objDeleteProjectDetails.EMPId;
}
sqlParam[1] = new SqlParameter(SPParameter.DocumentName, SqlDbType.NVarChar);
if (objDeleteProjectDetails.EMPId == 0)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objDeleteProjectDetails.EMPId;
}
objDA.ExecuteNonQuerySP(SPNames.USP_Employee_DeleteEmployeeResumeDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "DeleteResumeDetails", EventIDConstants.RAVE_HR_EMPLOYEE_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Updates the project details.
/// </summary>
/// <param name="objUpdateProjectDetails">The obj update project details.</param>
public void UpdateProjectDetails(BusinessEntities.ProjectDetails objUpdateProjectDetails)
{
Rave.HR.DataAccessLayer.Employees.ProjectDetails objUpdateProjectDetailsDAL;
try
{
objUpdateProjectDetailsDAL = new Rave.HR.DataAccessLayer.Employees.ProjectDetails();
objUpdateProjectDetailsDAL.UpdateProjectDetails(objUpdateProjectDetails);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, "UpdateProjectDetails", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Gets the project details.
/// </summary>
/// <param name="objGetProjectDetails">The obj get project details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetProjectDetails(BusinessEntities.ProjectDetails objGetProjectDetails)
{
//Object declaration of QualificationDetails class
Rave.HR.DataAccessLayer.Employees.ProjectDetails objGetProjectDetailsDAL;
try
{
//Created new instance of QualificationDetails class to call objGetQualificationDetailsDAL() of Data access layer
objGetProjectDetailsDAL = new Rave.HR.DataAccessLayer.Employees.ProjectDetails();
//Call to GetQualificationDetails() of Data access layer and return the Qualifications
return(objGetProjectDetailsDAL.GetProjectDetails(objGetProjectDetails));
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, "GetProjectDetails", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Adds the project details.
/// </summary>
/// <param name="objAddProjectDetails">The obj add project details.</param>
public void AddProjectDetails(BusinessEntities.ProjectDetails objAddProjectDetails)
{
try
{
objDA = new DataAccessClass();
objDA.OpenConnection(DBConstants.GetDBConnectionString());
SqlParameter[] sqlParam = new SqlParameter[14];
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
sqlParam[0].Value = objAddProjectDetails.EMPId;
sqlParam[1] = new SqlParameter(SPParameter.ProjectName, SqlDbType.NVarChar, 50);
if (objAddProjectDetails.ProjectName == "" || objAddProjectDetails.ProjectName == null)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objAddProjectDetails.ProjectName;
}
sqlParam[2] = new SqlParameter(SPParameter.Organisation, SqlDbType.NVarChar, 50);
if (objAddProjectDetails.Organisation == "" || objAddProjectDetails.Organisation == null)
{
sqlParam[2].Value = DBNull.Value;
}
else
{
sqlParam[2].Value = objAddProjectDetails.Organisation;
}
sqlParam[3] = new SqlParameter(SPParameter.Years, SqlDbType.NChar, 10);
if (objAddProjectDetails.Years == "" || objAddProjectDetails.Years == null)
{
sqlParam[3].Value = DBNull.Value;
}
else
{
sqlParam[3].Value = objAddProjectDetails.Years;
}
sqlParam[4] = new SqlParameter(SPParameter.Role, SqlDbType.NChar, 10);
if (objAddProjectDetails.Role == "" || objAddProjectDetails.Role == null)
{
sqlParam[4].Value = DBNull.Value;
}
else
{
sqlParam[4].Value = objAddProjectDetails.Role;
}
sqlParam[5] = new SqlParameter(SPParameter.Onsite, SqlDbType.Bit);
if (objAddProjectDetails.Onsite == null)
{
sqlParam[5].Value = DBNull.Value;
}
else
{
sqlParam[5].Value = objAddProjectDetails.Onsite;
}
sqlParam[6] = new SqlParameter(SPParameter.OnsiteDuration, SqlDbType.NChar, 10);
if (objAddProjectDetails.OnsiteDuration == "" || objAddProjectDetails.OnsiteDuration == null)
{
sqlParam[6].Value = DBNull.Value;
}
else
{
sqlParam[6].Value = objAddProjectDetails.OnsiteDuration;
}
sqlParam[7] = new SqlParameter(SPParameter.Description, SqlDbType.NChar);
if (objAddProjectDetails.Description == "" || objAddProjectDetails.Description == null)
{
sqlParam[7].Value = DBNull.Value;
}
else
{
sqlParam[7].Value = objAddProjectDetails.Description;
}
sqlParam[8] = new SqlParameter(SPParameter.Resposibility, SqlDbType.NChar);
if (objAddProjectDetails.Resposibility == "" || objAddProjectDetails.Resposibility == null)
{
sqlParam[8].Value = DBNull.Value;
}
else
{
sqlParam[8].Value = objAddProjectDetails.Resposibility;
}
sqlParam[9] = new SqlParameter(SPParameter.ProjectLocation, SqlDbType.Int);
if (objAddProjectDetails.ProjectLocation == "" || objAddProjectDetails.ProjectLocation == null)
{
sqlParam[9].Value = DBNull.Value;
}
else
{
sqlParam[9].Value = objAddProjectDetails.LocationId;
}
sqlParam[10] = new SqlParameter(SPParameter.ClientName, SqlDbType.NChar);
if (objAddProjectDetails.ClientName == "" || objAddProjectDetails.ClientName == null)
{
sqlParam[10].Value = DBNull.Value;
}
else
{
sqlParam[10].Value = objAddProjectDetails.ClientName;
}
sqlParam[11] = new SqlParameter(SPParameter.ProjectSize, SqlDbType.Int);
sqlParam[11].Value = objAddProjectDetails.ProjectSize;
sqlParam[12] = new SqlParameter(SPParameter.ProjectDone, SqlDbType.Int);
sqlParam[12].Value = objAddProjectDetails.ProjectDone;
sqlParam[13] = new SqlParameter(SPParameter.RankOrder, SqlDbType.Int);
sqlParam[13].Value = objAddProjectDetails.RankOrder;
int AddProjectDetails = objDA.ExecuteNonQuerySP(SPNames.Employee_AddProjectsDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "AddProjectsDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Gets the project details.
/// </summary>
/// <param name="objGetProjectDetails">The obj get project details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetProjectDetails(BusinessEntities.ProjectDetails objGetProjectDetails)
{
// Initialise Data Access Class object
objDA = new DataAccessClass();
sqlParam = new SqlParameter[1];
// Initialise Collection class object
raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
//Open the connection to DB
objDA.OpenConnection(DBConstants.GetDBConnectionString());
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objGetProjectDetails.EMPId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objGetProjectDetails.EMPId;
}
//Execute the SP
objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetProjectsDetails, sqlParam);
while (objDataReader.Read())
{
//Initialise the Business Entity object
objProjectDetails = new BusinessEntities.ProjectDetails();
objProjectDetails.ProjectId = int.Parse(objDataReader[DbTableColumn.PId].ToString());
objProjectDetails.EMPId = int.Parse(objDataReader[DbTableColumn.EMPId].ToString());
objProjectDetails.ProjectName = objDataReader[DbTableColumn.ProjectName].ToString();
objProjectDetails.Organisation = objDataReader[DbTableColumn.Organisation].ToString();
objProjectDetails.Years = objDataReader[DbTableColumn.Years].ToString();
objProjectDetails.Role = objDataReader[DbTableColumn.Role].ToString();
objProjectDetails.Onsite = Convert.ToBoolean(objDataReader[DbTableColumn.Onsite].ToString());
objProjectDetails.OnsiteDuration = objDataReader[DbTableColumn.OnsiteDuration].ToString();
objProjectDetails.Description = objDataReader[DbTableColumn.Description].ToString();
objProjectDetails.LocationId = int.Parse(objDataReader[DbTableColumn.ProjectLocation].ToString());
objProjectDetails.ProjectLocation = objDataReader[DbTableColumn.LocationName].ToString();
objProjectDetails.ProjectSize = int.Parse(objDataReader[DbTableColumn.ProjectSize].ToString());
objProjectDetails.ClientName = objDataReader[DbTableColumn.ClientName].ToString();
objProjectDetails.Resposibility = objDataReader[DbTableColumn.Resposibility].ToString();
objProjectDetails.ProjectDone = int.Parse(objDataReader[DbTableColumn.ProjectDone].ToString());
objProjectDetails.ProjectDoneName = objDataReader[DbTableColumn.ProjectDoneName].ToString();
if (!string.IsNullOrEmpty(objDataReader[DbTableColumn.RankOrder].ToString()))
{
objProjectDetails.RankOrder = int.Parse(objDataReader[DbTableColumn.RankOrder].ToString());
}
// Add the object to Collection
raveHRCollection.Add(objProjectDetails);
}
// Return the Collection
return(raveHRCollection);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "GetProfessionalDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
if (objDataReader != null)
{
objDataReader.Close();
}
objDA.CloseConncetion();
}
}
