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