/// <summary>
        /// Deletes the professional details.
        /// </summary>
        /// <param name="objDeleteProfessionalDetails">The obj delete professional details.</param>
        public void DeleteProfessionalDetails(BusinessEntities.ProfessionalDetails objDeleteProfessionalDetails)
        {
            objDA    = new DataAccessClass();
            sqlParam = new SqlParameter[2];

            try
            {
                objDA.OpenConnection(DBConstants.GetDBConnectionString());


                sqlParam[0] = new SqlParameter(SPParameter.ProfessionalId, SqlDbType.Int);
                if (objDeleteProfessionalDetails.ProfessionalId == 0)
                {
                    sqlParam[0].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[0].Value = objDeleteProfessionalDetails.ProfessionalId;
                }

                sqlParam[1] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
                if (objDeleteProfessionalDetails.EMPId == 0)
                {
                    sqlParam[1].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[1].Value = objDeleteProfessionalDetails.EMPId;
                }

                objDA.ExecuteNonQuerySP(SPNames.Employee_DeleteProfessionalDetails, sqlParam);
            }
            catch (RaveHRException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "DeleteProfessionalDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
            }
            finally
            {
                objDA.CloseConncetion();
            }
        }
示例#2
0
        /// <summary>
        /// Gets the professional details.
        /// </summary>
        /// <param name="objGetProfessionalDetails">The obj get professional details.</param>
        /// <returns></returns>
        public BusinessEntities.RaveHRCollection GetProfessionalDetails(BusinessEntities.ProfessionalDetails objGetProfessionalDetails)
        {
            //Object declaration of QualificationDetails class
            Rave.HR.DataAccessLayer.Employees.ProfessionalDetails objGetProfessionalDetailsDAL;

            try
            {
                //Created new instance of QualificationDetails class to call objGetQualificationDetailsDAL() of Data access layer
                objGetProfessionalDetailsDAL = new Rave.HR.DataAccessLayer.Employees.ProfessionalDetails();

                //Call to GetQualificationDetails() of Data access layer and return the Qualifications
                return(objGetProfessionalDetailsDAL.GetProfessionalDetails(objGetProfessionalDetails));
            }
            catch (RaveHRException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, "GetProfessionalDetails", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
            }
        }
        /// <summary>
        /// Adds the professional details.
        /// </summary>
        /// <param name="objAddProfessionalDetails">The obj add professional details.</param>
        public void AddProfessionalDetails(BusinessEntities.ProfessionalDetails objAddProfessionalDetails)
        {
            try
            {
                objDA = new DataAccessClass();
                objDA.OpenConnection(DBConstants.GetDBConnectionString());
                SqlParameter[] sqlParam = new SqlParameter[6];

                sqlParam[0]       = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
                sqlParam[0].Value = objAddProfessionalDetails.EMPId;

                sqlParam[1] = new SqlParameter(SPParameter.CourseName, SqlDbType.NChar, 20);
                if (objAddProfessionalDetails.CourseName == "" || objAddProfessionalDetails.CourseName == null)
                {
                    sqlParam[1].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[1].Value = objAddProfessionalDetails.CourseName;
                }

                sqlParam[2] = new SqlParameter(SPParameter.InstitutionName, SqlDbType.NChar, 50);
                if (objAddProfessionalDetails.InstitutionName == "" || objAddProfessionalDetails.InstitutionName == null)
                {
                    sqlParam[2].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[2].Value = objAddProfessionalDetails.InstitutionName;
                }

                sqlParam[3] = new SqlParameter(SPParameter.PassingYear, SqlDbType.NChar, 4);
                if (objAddProfessionalDetails.PassingYear == "" || objAddProfessionalDetails.PassingYear == null)
                {
                    sqlParam[3].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[3].Value = objAddProfessionalDetails.PassingYear;
                }

                sqlParam[4] = new SqlParameter(SPParameter.Score, SqlDbType.NChar, 10);
                if (objAddProfessionalDetails.Score == "" || objAddProfessionalDetails.Score == null)
                {
                    sqlParam[4].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[4].Value = objAddProfessionalDetails.Score;
                }

                sqlParam[5] = new SqlParameter(SPParameter.Outof, SqlDbType.NChar, 10);
                if (objAddProfessionalDetails.Outof == "" || objAddProfessionalDetails.Outof == null)
                {
                    sqlParam[5].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[5].Value = objAddProfessionalDetails.Outof;
                }

                int AddProfessinalDetails = objDA.ExecuteNonQuerySP(SPNames.Employee_AddProfessionalDetails, sqlParam);
            }
            catch (RaveHRException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "AddProfessionalDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
            }
            finally
            {
                objDA.CloseConncetion();
            }
        }
        /// <summary>
        /// Gets the professional details.
        /// </summary>
        /// <param name="objGetProfessionalDetails">The obj get professional details.</param>
        /// <returns></returns>
        public BusinessEntities.RaveHRCollection GetProfessionalDetails(BusinessEntities.ProfessionalDetails objGetProfessionalDetails)
        {
            // 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 (objGetProfessionalDetails.EMPId == 0)
                {
                    sqlParam[0].Value = DBNull.Value;
                }
                else
                {
                    sqlParam[0].Value = objGetProfessionalDetails.EMPId;
                }

                //Execute the SP
                objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetProfessionalDetails, sqlParam);

                while (objDataReader.Read())
                {
                    //Initialise the Business Entity object
                    objProfessionalDetails = new BusinessEntities.ProfessionalDetails();

                    objProfessionalDetails.ProfessionalId  = int.Parse(objDataReader[DbTableColumn.PId].ToString());
                    objProfessionalDetails.EMPId           = int.Parse(objDataReader[DbTableColumn.EMPId].ToString());
                    objProfessionalDetails.CourseName      = objDataReader[DbTableColumn.CourseName].ToString();
                    objProfessionalDetails.InstitutionName = objDataReader[DbTableColumn.InstitutionName].ToString();
                    objProfessionalDetails.PassingYear     = objDataReader[DbTableColumn.PassingYear].ToString();
                    objProfessionalDetails.Score           = objDataReader[DbTableColumn.Score].ToString();
                    objProfessionalDetails.Outof           = objDataReader[DbTableColumn.Outof].ToString() == string.Empty ? string.Empty : objDataReader[DbTableColumn.Outof].ToString();

                    // Add the object to Collection
                    raveHRCollection.Add(objProfessionalDetails);
                }

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