/// <summary>
/// Deletes the organisation details.
/// </summary>
/// <param name="objDeleteOrganisationDetails">The obj delete organisation details.</param>
public void DeleteOrganisationDetails(BusinessEntities.OrganisationDetails objDeleteOrganisationDetails)
{
objDA = new DataAccessClass();
sqlParam = new SqlParameter[2];
try
{
objDA.OpenConnection(DBConstants.GetDBConnectionString());
sqlParam[0] = new SqlParameter(SPParameter.OrganisationId, SqlDbType.Int);
if (objDeleteOrganisationDetails.OrganisationId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objDeleteOrganisationDetails.OrganisationId;
}
sqlParam[1] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
if (objDeleteOrganisationDetails.EMPId == 0)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objDeleteOrganisationDetails.EMPId;
}
objDA.ExecuteNonQuerySP(SPNames.Employee_DeleteOrganisationDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "DeleteOrganisationDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Gets the organisation details.
/// </summary>
/// <param name="objGetOrganisationDetails">The obj get organisation details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetOrganisationDetails(BusinessEntities.OrganisationDetails objGetOrganisationDetails)
{
Rave.HR.DataAccessLayer.Employees.OrganisationDetails objGetOrganisationDetailsDAL;
try
{
objGetOrganisationDetailsDAL = new Rave.HR.DataAccessLayer.Employees.OrganisationDetails();
return(objGetOrganisationDetailsDAL.GetOrganisationDetails(objGetOrganisationDetails));
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, "GetOrganisationDetails", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Deletes the non organisation details.
/// </summary>
/// <param name="objDeleteOrganisationDetails">The obj delete organisation details.</param>
public void DeleteNonOrganisationDetails(BusinessEntities.OrganisationDetails objDeleteOrganisationDetails)
{
Rave.HR.DataAccessLayer.Employees.OrganisationDetails objDeleteOrganisationDetailsDAL;
try
{
objDeleteOrganisationDetailsDAL = new Rave.HR.DataAccessLayer.Employees.OrganisationDetails();
objDeleteOrganisationDetailsDAL.DeleteNonOrganisationDetails(objDeleteOrganisationDetails);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CLASS_NAME, "DeleteOrganisationDetails", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
/// <summary>
/// Adds the organisation details.
/// </summary>
/// <param name="objAddOrganisationDetails">The obj add organisation details.</param>
public void AddOrganisationDetails(BusinessEntities.OrganisationDetails objAddOrganisationDetails)
{
try
{
objDA = new DataAccessClass();
objDA.OpenConnection(DBConstants.GetDBConnectionString());
SqlParameter[] sqlParam = new SqlParameter[10];
sqlParam[0] = new SqlParameter(SPParameter.EmpId, SqlDbType.Int);
sqlParam[0].Value = objAddOrganisationDetails.EMPId;
sqlParam[1] = new SqlParameter(SPParameter.CompanyName, SqlDbType.NChar, 50);
if (objAddOrganisationDetails.CompanyName == "" || objAddOrganisationDetails.CompanyName == null)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objAddOrganisationDetails.CompanyName;
}
sqlParam[2] = new SqlParameter(SPParameter.MonthSince, SqlDbType.Int);
sqlParam[2].Value = objAddOrganisationDetails.MonthSince;
sqlParam[3] = new SqlParameter(SPParameter.YearSince, SqlDbType.Int);
sqlParam[3].Value = objAddOrganisationDetails.YearSince;
sqlParam[4] = new SqlParameter(SPParameter.MonthTill, SqlDbType.Int);
sqlParam[4].Value = objAddOrganisationDetails.MonthTill;
sqlParam[5] = new SqlParameter(SPParameter.YearTill, SqlDbType.Int);
sqlParam[5].Value = objAddOrganisationDetails.YearTill;
sqlParam[6] = new SqlParameter(SPParameter.Designation, SqlDbType.NChar, 50);
if (objAddOrganisationDetails.Designation == "" || objAddOrganisationDetails.Designation == null)
{
sqlParam[6].Value = DBNull.Value;
}
else
{
sqlParam[6].Value = objAddOrganisationDetails.Designation;
}
sqlParam[7] = new SqlParameter(SPParameter.ExperienceType, SqlDbType.Int, 10);
sqlParam[7].Value = objAddOrganisationDetails.ExperienceType;
sqlParam[8] = new SqlParameter(SPParameter.ExperienceInMonth, SqlDbType.Int);
sqlParam[8].Value = objAddOrganisationDetails.ExperienceMonth;
sqlParam[9] = new SqlParameter(SPParameter.ExperienceInYear, SqlDbType.Int);
sqlParam[9].Value = objAddOrganisationDetails.ExperienceYear;
int AddProfessinalDetails = objDA.ExecuteNonQuerySP(SPNames.Employee_AddOrganisationDetails, sqlParam);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASS_NAME, "AddOrganisationDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
objDA.CloseConncetion();
}
}
/// <summary>
/// Gets the organisation details.
/// </summary>
/// <param name="objGetOrganisationDetails">The obj get organisation details.</param>
/// <returns></returns>
public BusinessEntities.RaveHRCollection GetOrganisationDetails(BusinessEntities.OrganisationDetails objGetOrganisationDetails)
{
// Initialise Data Access Class object
objDA = new DataAccessClass();
sqlParam = new SqlParameter[2];
// 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 (objGetOrganisationDetails.EMPId == 0)
{
sqlParam[0].Value = DBNull.Value;
}
else
{
sqlParam[0].Value = objGetOrganisationDetails.EMPId;
}
sqlParam[1] = new SqlParameter(SPParameter.ExperienceType, SqlDbType.Int);
if (objGetOrganisationDetails.ExperienceType == 0)
{
sqlParam[1].Value = DBNull.Value;
}
else
{
sqlParam[1].Value = objGetOrganisationDetails.ExperienceType;
}
//Execute the SP
objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetOrganisationDetails, sqlParam);
while (objDataReader.Read())
{
//Initialise the Business Entity object
objOrganisationDetails = new BusinessEntities.OrganisationDetails();
objOrganisationDetails.OrganisationId = int.Parse(objDataReader[DbTableColumn.OId].ToString());
objOrganisationDetails.EMPId = int.Parse(objDataReader[DbTableColumn.EMPId].ToString());
objOrganisationDetails.CompanyName = objDataReader[DbTableColumn.CompanyName].ToString();
objOrganisationDetails.MonthSince = int.Parse(objDataReader[DbTableColumn.MonthSince].ToString());
objOrganisationDetails.YearSince = int.Parse(objDataReader[DbTableColumn.YearSince].ToString());
objOrganisationDetails.MonthTill = int.Parse(objDataReader[DbTableColumn.MonthTill].ToString());
objOrganisationDetails.YearTill = int.Parse(objDataReader[DbTableColumn.YearTill].ToString());
objOrganisationDetails.Designation = objDataReader[DbTableColumn.Designation].ToString();
objOrganisationDetails.MonthSinceName = objDataReader[DbTableColumn.MonthSinceName].ToString();
objOrganisationDetails.MonthTillName = objDataReader[DbTableColumn.MonthTillName].ToString();
objOrganisationDetails.WorkingSince = objOrganisationDetails.MonthSinceName + "-" + objOrganisationDetails.YearSince.ToString();
objOrganisationDetails.WorkingTill = objOrganisationDetails.MonthTillName + "-" + objOrganisationDetails.YearTill.ToString();
objOrganisationDetails.ExperienceMonth = objDataReader[DbTableColumn.ExperienceInMonth].ToString() == string.Empty ? 0 : int.Parse(objDataReader[DbTableColumn.ExperienceInMonth].ToString());
objOrganisationDetails.ExperienceYear = objDataReader[DbTableColumn.ExperienceInYear].ToString() == string.Empty ? 0 : int.Parse(objDataReader[DbTableColumn.ExperienceInYear].ToString());
objOrganisationDetails.Experience = objOrganisationDetails.ExperienceYear + " " + YEARS + "-" + objOrganisationDetails.ExperienceMonth + " " + MONTHS;
// Add the object to Collection
raveHRCollection.Add(objOrganisationDetails);
}
// 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();
}
}
