/// <summary> /// Deletes the emergency contact. /// </summary> /// <param name="objDeleteEmergencyContact">The obj delete emergency contact.</param> public void DeleteEmergencyContact(BusinessEntities.EmergencyContact objDeleteEmergencyContact) { //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.EmergencyContactId, SqlDbType.Int); if (objDeleteEmergencyContact.EmergencyContactId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objDeleteEmergencyContact.EmergencyContactId; } sqlParam[1] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int); if (objDeleteEmergencyContact.EMPId == 0) { sqlParam[1].Value = DBNull.Value; } else { sqlParam[1].Value = objDeleteEmergencyContact.EMPId; } //Execute SP along with proper parameters objDA.ExecuteNonQuerySP(SPNames.Employee_DeleteEmergencyContact, sqlParam); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, DELETEEMERGENCYCONTACT, EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } }
/// <summary> /// Gets the address. /// </summary> /// <param name="objEmployee">The obj get certification details.</param> /// <returns></returns> public BusinessEntities.RaveHRCollection GetEmergencyContact(BusinessEntities.EmergencyContact objGetEmergencyContact) { //Object declaration of QualificationDetails class Rave.HR.DataAccessLayer.Employees.EmergencyContact objEmergencyContactDAL; try { //Created new instance of QualificationDetails class to call objGetQualificationDetailsDAL() of Data access layer objEmergencyContactDAL = new Rave.HR.DataAccessLayer.Employees.EmergencyContact(); //Call to GetQualificationDetails() of Data access layer and return the Qualifications return(objEmergencyContactDAL.GetEmergencyContact(objGetEmergencyContact)); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, GETEMERGENCYCONTACT, EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER); } }
/// <summary> /// Adds the address. /// </summary> /// <param name="objAddCertificationDetails">The obj add certification details.</param> public void AddEmergencyContact(BusinessEntities.EmergencyContact objEmergencyContact) { //Object declaration of objAddAddressDAL class Rave.HR.DataAccessLayer.Employees.EmergencyContact objAddEmergencyContactDAL; try { //Created new instance of CertificationDetails class to call AddCertificationDetails() of Data access layer objAddEmergencyContactDAL = new Rave.HR.DataAccessLayer.Employees.EmergencyContact(); //Call to AddCertificationDetails() of Data access layer objAddEmergencyContactDAL.AddEmergencyContact(objEmergencyContact); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, ADDEMERGENCYCONTACT, EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER); } }
/// <summary> /// Deletes the qualification details. /// </summary> /// <param name="objDeleteEmergencyContact">The object delete qualification details.</param> public void DeleteEmergencyContact(BusinessEntities.EmergencyContact objDeleteEmergencyContact) { //Object declaration of EmergencyContact class Rave.HR.DataAccessLayer.Employees.EmergencyContact objDeleteEmergencyContactDAL; try { //Created new instance of EmergencyContact class to call DeleteEmergencyContact() of Data access layer objDeleteEmergencyContactDAL = new Rave.HR.DataAccessLayer.Employees.EmergencyContact(); //Call to DeleteEmergencyContact() of Data access layer objDeleteEmergencyContactDAL.DeleteEmergencyContact(objDeleteEmergencyContact); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, DELETEEMERGENCYCONTACT, EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER); } }
/// <summary> /// Adds the EmergencyContact. /// </summary> /// <param name="objAddEmployee">The object add employee.</param> public int AddEmergencyContact(BusinessEntities.EmergencyContact objEmergencyContact) { int empID = 0; objDA = new DataAccessClass(); sqlParam = new SqlParameter[4]; try { using (TransactionScope ts = new TransactionScope()) { objDA.OpenConnection(DBConstants.GetDBConnectionString()); sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int); if (objEmergencyContact.EMPId == 0) { return(0); } else { sqlParam[0].Value = objEmergencyContact.EMPId; } sqlParam[1] = new SqlParameter(SPParameter.ContactName, SqlDbType.NVarChar, 50); if (objEmergencyContact.ContactName == "" || objEmergencyContact.ContactName == null) { sqlParam[1].Value = DBNull.Value; } else { sqlParam[1].Value = objEmergencyContact.ContactName; } sqlParam[2] = new SqlParameter(SPParameter.ContactNumber, SqlDbType.NVarChar, 50); if (objEmergencyContact.ContactNumber == "" || objEmergencyContact.ContactNumber == null) { sqlParam[2].Value = DBNull.Value; } else { sqlParam[2].Value = objEmergencyContact.ContactNumber; } sqlParam[3] = new SqlParameter(SPParameter.Relation, SqlDbType.Int); if (objEmergencyContact.RelationType == 0) { sqlParam[3].Value = DBNull.Value; } else { sqlParam[3].Value = objEmergencyContact.RelationType; } objDA.ExecuteNonQuerySP(SPNames.Employee_AddEmergencyContact, sqlParam); ts.Complete(); } } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, ADDEMERGENCYCONTACT, EventIDConstants.RAVE_HR_EMPLOYEE_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } return(empID); }
/// <summary> /// Gets the Employee Address. /// </summary> /// <param name="objGetCertificationDetails">The object get certification details.</param> /// <returns></returns> public BusinessEntities.RaveHRCollection GetEmergencyContact(BusinessEntities.EmergencyContact objGetEmergencyContact) { //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 { using (TransactionScope ts = new TransactionScope()) { //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 (objGetEmergencyContact.EMPId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objGetEmergencyContact.EMPId; } objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetEmergencyContact, sqlParam); while (objDataReader.Read()) { //Initialise the Business Entity object objEmergencyContact = new BusinessEntities.EmergencyContact(); objEmergencyContact.EmergencyContactId = Convert.ToInt32(objDataReader[DbTableColumn.EmergencyContactId].ToString()); objEmergencyContact.EMPId = Convert.ToInt32(objDataReader[DbTableColumn.EMPId].ToString()); objEmergencyContact.ContactName = objDataReader[DbTableColumn.ContactName].ToString(); objEmergencyContact.ContactNumber = objDataReader[DbTableColumn.ContactNumber].ToString(); objEmergencyContact.Relation = objDataReader[DbTableColumn.Relation].ToString(); objEmergencyContact.RelationType = int.Parse(objDataReader[DbTableColumn.RelationType].ToString()); // Add the object to Collection raveHRCollection.Add(objEmergencyContact); } if (!objDataReader.IsClosed) { objDataReader.Close(); } ts.Complete(); } } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, GETEMERGENCYCONTACT, EventIDConstants.RAVE_HR_EMPLOYEE_DATA_ACCESS_LAYER); } finally { if (!objDataReader.IsClosed) { objDataReader.Close(); } objDA.CloseConncetion(); } // Return the Collection return(raveHRCollection); }