/// <summary> /// /// </summary> /// <param name="addContract"></param> /// <returns></returns> public int Save(BusinessEntities.Contract addContract) { SqlConnection objConnection = null; SqlCommand objCommand = null; string ConnStr = string.Empty; try { ConnStr = DBConstants.GetDBConnectionString(); objConnection = new SqlConnection(ConnStr); objConnection.Open(); objCommand = new SqlCommand(SPNames.Contract_AddContract, objConnection); objCommand.CommandType = CommandType.StoredProcedure; SqlParameter[] sqlParam = new SqlParameter[18]; sqlParam[0] = objCommand.Parameters.AddWithValue(SPParameter.ContractReferenceID, addContract.ContractReferenceID); sqlParam[1] = objCommand.Parameters.AddWithValue(SPParameter.ContractType, addContract.ContractType); sqlParam[2] = objCommand.Parameters.AddWithValue(SPParameter.DocumentName, addContract.DocumentName); sqlParam[3] = objCommand.Parameters.AddWithValue(SPParameter.ContractStatus, addContract.ContractStatus); sqlParam[4] = objCommand.Parameters.AddWithValue(SPParameter.AccountManagerID, addContract.AccountManagerID); sqlParam[5] = objCommand.Parameters.AddWithValue(SPParameter.EmailID, addContract.EmailID); sqlParam[6] = objCommand.Parameters.AddWithValue(SPParameter.ClientName, addContract.ClientName); sqlParam[7] = objCommand.Parameters.AddWithValue(SPParameter.LocationID, addContract.LocationID); sqlParam[8] = objCommand.Parameters.AddWithValue(SPParameter.ParentContractID, parentContractId); sqlParam[9] = objCommand.Parameters.AddWithValue(SPParameter.CreatedById, addContract.CreatedByEmailId); sqlParam[10] = objCommand.Parameters.AddWithValue(SPParameter.CreatedDate, DateTime.Now); sqlParam[11] = objCommand.Parameters.AddWithValue(SPParameter.ContractValue, addContract.ContractValue); sqlParam[12] = objCommand.Parameters.AddWithValue(SPParameter.CurrencyType, addContract.CurrencyType); sqlParam[13] = objCommand.Parameters.AddWithValue(SPParameter.Division, addContract.Division); sqlParam[14] = objCommand.Parameters.AddWithValue(SPParameter.Sponsor, addContract.Sponsor); sqlParam[15] = objCommand.Parameters.AddWithValue(SPParameter.OutContractId, 0); sqlParam[15].Direction = ParameterDirection.Output; sqlParam[16] = objCommand.Parameters.AddWithValue(SPParameter.ContractStartDate, addContract.ContractStartDate); sqlParam[17] = objCommand.Parameters.AddWithValue(SPParameter.ContractEndDate, addContract.ContractEndDate); int contract = objCommand.ExecuteNonQuery(); int ContractId = Convert.ToInt32(sqlParam[15].Value); return(ContractId); } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, SAVE, EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER); } finally { if (objConnection.State == ConnectionState.Open) { objConnection.Close(); } } }
/// <summary> /// Checks the CR reference no. /// </summary> /// <param name="objCRDetails">The obj CR details.</param> /// <returns></returns> public bool checkCRReferenceNo(BusinessEntities.Contract objCRDetails) { bool result = false; DataAccessClass ProjectDetails = new DataAccessClass(); try { ProjectDetails.OpenConnection(DBConstants.GetDBConnectionString()); SqlParameter[] sqlParam = new SqlParameter[4]; sqlParam[0] = new SqlParameter(SPParameter.CRReferenceNo, DbType.String); sqlParam[0].Value = objCRDetails.CRReferenceNo; sqlParam[1] = new SqlParameter(SPParameter.ContractId, DbType.Int32); sqlParam[1].Value = objCRDetails.ContractID; sqlParam[2] = new SqlParameter(SPParameter.ProjectCode, DbType.String); sqlParam[2].Value = objCRDetails.CRProjectCode; sqlParam[3] = new SqlParameter(SPParameter.COUNT, DbType.Int32); sqlParam[3].Direction = ParameterDirection.Output; //gets the all employee details related to project . ProjectDetails.ExecuteNonQuerySP(SPNames.Contracts_CheckCRReferenceNo, sqlParam); int count = Convert.ToInt32(sqlParam[3].Value); if (count > 0) { result = true; } else { result = false; } return(result); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, "checkCRReferenceNo", EventIDConstants.RAVE_HR_CONTRACT_PRESENTATION_LAYER); } finally { ProjectDetails.CloseConncetion(); } }
/// <summary> /// Deletes the Contract details from the /// contracts table and saves it to the contract history table. /// </summary> /// <param name="contract"></param> public bool delete(BusinessEntities.Contract contract) { //creates a DataAccessClass object. DataAccessClass Contract = new DataAccessClass(); try { bool result = false; //creates a new business entity. objcontract = new BusinessEntities.ContractProject(); //Opens the connection. Contract.OpenConnection(DBConstants.GetDBConnectionString()); //Declares the parameters for the sp. SqlParameter[] sqlParam = new SqlParameter[2]; sqlParam[0] = new SqlParameter(SPParameter.ContractCode, DbType.String); sqlParam[0].Value = contract.ContractCode; sqlParam[1] = new SqlParameter(SPParameter.ReasonForDeletion, DbType.String); sqlParam[1].Value = contract.ReasonForDeletion; //update changes in the database. int delete = Contract.ExecuteNonQuerySP(SPNames.Contract_DeleteContract, sqlParam); result = true; return(result); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, DELETE, EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER); } finally { Contract.CloseConncetion(); } }
/// <summary> /// Deletes the CR details. /// </summary> /// <param name="objDeleteCRDetails">The obj delete CR details.</param> public void DeleteCRDetails(BusinessEntities.Contract objDeleteCRDetails) { //Initialise Data Access Class object objDA = new DataAccessClass(); //Initialise SqlParameter Class object sqlParam = new SqlParameter[1]; 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.CRId, SqlDbType.Int); if (objDeleteCRDetails.CRId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objDeleteCRDetails.CRId; } //Execute SP along with proper parameters objDA.ExecuteNonQuerySP(SPNames.Contracts_DeleteCRDetails, sqlParam); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, "DeleteCRDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } }
/// <summary> /// Gets the CR details. /// </summary> /// <param name="objGetCRDetails">The obj get CR details.</param> /// <returns></returns> public BusinessEntities.RaveHRCollection GetCRDetails(BusinessEntities.Contract objGetCRDetails) { //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 { //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.ContractId, SqlDbType.Int); if (objGetCRDetails.ContractID == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objGetCRDetails.ContractID; } objDataReader = objDA.ExecuteReaderSP(SPNames.Contracts_GetCRDetails, sqlParam); while (objDataReader.Read()) { //Initialise the Business Entity object objCRDetails = new BusinessEntities.Contract(); objCRDetails.CRId = Convert.ToInt32(objDataReader[DbTableColumn.Con_CRId].ToString()); objCRDetails.CRProjectCode = objDataReader[DbTableColumn.ProjectCode].ToString(); objCRDetails.CRReferenceNo = objDataReader[DbTableColumn.Con_CRReferenceNo].ToString(); objCRDetails.CRStartDate = Convert.ToDateTime(objDataReader[DbTableColumn.Con_CRStartDate].ToString()); objCRDetails.CREndDate = Convert.ToDateTime(objDataReader[DbTableColumn.Con_CREndDate].ToString()); objCRDetails.CRRemarks = objDataReader[DbTableColumn.Con_Remarks].ToString(); // Add the object to Collection raveHRCollection.Add(objCRDetails); } } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, "GetCRDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER); } finally { if (objDataReader != null) { objDataReader.Close(); } objDA.CloseConncetion(); } // Return the Collection return(raveHRCollection); }
/// <summary> /// Updates the CR details. /// </summary> /// <param name="objUpdateCRDetails">The obj update CR details.</param> public void UpdateCRDetails(BusinessEntities.Contract objUpdateCRDetails) { //Initialise Data Access Class object objDA = new DataAccessClass(); //Initialise SqlParameter Class object sqlParam = new SqlParameter[5]; 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.CRId, SqlDbType.Int); if (objUpdateCRDetails.CRId == 0) { sqlParam[0].Value = DBNull.Value; } else { sqlParam[0].Value = objUpdateCRDetails.CRId; } sqlParam[1] = new SqlParameter(SPParameter.CRReferenceNo, SqlDbType.NChar, 50); if (objUpdateCRDetails.CRReferenceNo == "" || objUpdateCRDetails.CRReferenceNo == null) { sqlParam[1].Value = DBNull.Value; } else { sqlParam[1].Value = objUpdateCRDetails.CRReferenceNo; } sqlParam[2] = new SqlParameter(SPParameter.StartDate, SqlDbType.DateTime); if (objUpdateCRDetails.CRStartDate == DateTime.MinValue) { sqlParam[2].Value = DBNull.Value; } sqlParam[2].Value = objUpdateCRDetails.CRStartDate; sqlParam[3] = new SqlParameter(SPParameter.EndDate, SqlDbType.DateTime); if (objUpdateCRDetails.CREndDate == DateTime.MinValue) { sqlParam[3].Value = DBNull.Value; } else { sqlParam[3].Value = objUpdateCRDetails.CREndDate; } sqlParam[4] = new SqlParameter(SPParameter.Remarks, SqlDbType.NChar, 50); if (string.IsNullOrEmpty(objUpdateCRDetails.CRRemarks)) { sqlParam[4].Value = DBNull.Value; } else { sqlParam[4].Value = objUpdateCRDetails.CRRemarks; } //Execute SP along with proper parameters objDA.ExecuteNonQuerySP(SPNames.Contracts_UpdateCRDetails, sqlParam); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, "UpdateCRDetails", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER); } finally { objDA.CloseConncetion(); } }
/// <summary> /// updates the edited contract. /// </summary> /// <param name="addContract"></param> /// <returns></returns> public bool edit(BusinessEntities.Contract Contract) { bool result = false; SqlConnection objConnection = null; SqlCommand objCommand = null; string ConnStr = string.Empty; try { ConnStr = DBConstants.GetDBConnectionString(); objConnection = new SqlConnection(ConnStr); objConnection.Open(); objCommand = new SqlCommand(SPNames.Contract_EditContracts, objConnection); objCommand.CommandType = CommandType.StoredProcedure; SqlParameter[] sqlParam = new SqlParameter[16]; sqlParam[0] = objCommand.Parameters.AddWithValue(SPParameter.ContractReferenceID, Contract.ContractReferenceID); sqlParam[1] = objCommand.Parameters.AddWithValue(SPParameter.ContractType, Contract.ContractType); sqlParam[2] = objCommand.Parameters.AddWithValue(SPParameter.DocumentName, Contract.DocumentName); sqlParam[3] = objCommand.Parameters.AddWithValue(SPParameter.ContractStatus, Contract.ContractStatus); sqlParam[4] = objCommand.Parameters.AddWithValue(SPParameter.AccountManagerID, Contract.AccountManagerID); sqlParam[5] = objCommand.Parameters.AddWithValue(SPParameter.EmailID, Contract.EmailID); sqlParam[6] = objCommand.Parameters.AddWithValue(SPParameter.ClientName, Contract.ClientName.ToString()); sqlParam[7] = objCommand.Parameters.AddWithValue(SPParameter.LocationID, Contract.LocationID); sqlParam[8] = objCommand.Parameters.AddWithValue(SPParameter.ContractCode, Contract.ContractCode); sqlParam[9] = objCommand.Parameters.AddWithValue(SPParameter.ContractValue, Contract.ContractValue); sqlParam[10] = objCommand.Parameters.AddWithValue(SPParameter.CurrencyType, Contract.CurrencyType); sqlParam[11] = objCommand.Parameters.AddWithValue(SPParameter.CreatedById, Contract.CreatedByEmailId); sqlParam[12] = objCommand.Parameters.AddWithValue(SPParameter.Division, Contract.Division); sqlParam[13] = objCommand.Parameters.AddWithValue(SPParameter.Sponsor, Contract.Sponsor); sqlParam[14] = objCommand.Parameters.AddWithValue(SPParameter.ContractStartDate, Contract.ContractStartDate); sqlParam[15] = objCommand.Parameters.AddWithValue(SPParameter.ContractEndDate, Contract.ContractEndDate); int contract = objCommand.ExecuteNonQuery(); if (contract != 0) { result = true; } else { result = false; } return(result); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, EDIT, EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER); } finally { if (objConnection.State == ConnectionState.Open) { objConnection.Close(); } } }
/// <summary> /// This function is used to retrieve Details of contract from database. /// </summary> /// <param name="objViewProject"></param> /// <returns>Dataset</returns> public BusinessEntities.Contract ViewContractDetails(BusinessEntities.Contract objViewContract) { SqlConnection objConnection = null; SqlCommand objCommand = null; DataSet ds = null; try { string ConnStr = DBConstants.GetDBConnectionString(); objConnection = new SqlConnection(ConnStr); objCommand = new SqlCommand(SPNames.Contract_ViewContracts, objConnection); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue(SPParameter.ContractId, objViewContract.ContractID); ds = new DataSet(); SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand); objDataAdapter.Fill(ds); //return ds; objcontract = new BusinessEntities.Contract(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[DbTableColumn.Con_ContractId] != null) { objcontract.ContractID = Convert.ToInt32(dr[DbTableColumn.Con_ContractId]); } if (dr[DbTableColumn.Con_ContractCode] != null) { objcontract.ContractCode = dr[DbTableColumn.Con_ContractCode].ToString(); } if (dr[DbTableColumn.Con_ContractType] != null) { objcontract.ContractType = dr[DbTableColumn.Con_ContractType].ToString(); } if (dr[DbTableColumn.Con_ContractRefId] != null) { objcontract.ContractReferenceID = dr[DbTableColumn.Con_ContractRefId].ToString(); } if (dr[DbTableColumn.Con_AccountManagerId] != null) { objcontract.AccountManagerID = Convert.ToInt32(dr[DbTableColumn.Con_AccountManagerId]); } if (dr[DbTableColumn.Con_AccountManagerName] != null) { objcontract.AccountManagerName = dr[DbTableColumn.Con_AccountManagerName].ToString(); } if (dr[DbTableColumn.Con_DocumentName] != null) { objcontract.DocumentName = dr[DbTableColumn.Con_DocumentName].ToString(); } if (dr[DbTableColumn.Con_contractStatus] != null) { objcontract.ContractStatus = dr[DbTableColumn.Con_contractStatus].ToString(); } if (dr[DbTableColumn.EmailId] != null) { objcontract.EmailID = dr[DbTableColumn.EmailId].ToString(); } if (dr[DbTableColumn.ClientName] != null) { objcontract.ClientName = dr[DbTableColumn.ClientName].ToString(); } if (dr[DbTableColumn.Con_LocationId].ToString() != "") { objcontract.LocationID = Convert.ToInt32(dr[DbTableColumn.Con_LocationId]); } if (dr[DbTableColumn.Con_Contractlocation] != null) { objcontract.LocationName = dr[DbTableColumn.Con_Contractlocation].ToString(); } if (dr[DbTableColumn.Con_ContractValue] != null) { objcontract.ContractValue = Convert.ToDecimal(dr[DbTableColumn.Con_ContractValue]); } if (dr[DbTableColumn.Con_CurrencyType] != null) { objcontract.CurrencyType = Convert.ToInt32(dr[DbTableColumn.Con_CurrencyType]); } if (dr[DbTableColumn.Con_Division] != null) { objcontract.Division = Convert.ToString(dr[DbTableColumn.Con_Division]); } if (dr[DbTableColumn.Con_Sponsor] != null) { objcontract.Sponsor = Convert.ToString(dr[DbTableColumn.Con_Sponsor]); } if (dr[DbTableColumn.Con_ContractStartDate].ToString() != string.Empty) { objcontract.ContractStartDate = Convert.ToDateTime(dr[DbTableColumn.Con_ContractStartDate]); } if (dr[DbTableColumn.Con_ContractEndDate].ToString() != string.Empty) { objcontract.ContractEndDate = Convert.ToDateTime(dr[DbTableColumn.Con_ContractEndDate]); } if (dr[DbTableColumn.Con_ClientAbbreviation].ToString() != string.Empty) { objcontract.ClinetAbbrivation = dr[DbTableColumn.Con_ClientAbbreviation].ToString(); } //Siddharth 13 March 2015 Start if (dr[DbTableColumn.ProjectModel].ToString() != string.Empty) { objcontract.ProjectModel = dr["ProjectModel"].ToString(); } //Siddharth 13 March 2015 End //Siddharth 9 Sept 2015 Start if (dr[DbTableColumn.BusinessVertical].ToString() != string.Empty) { objcontract.BusinessVertical = dr["BusinessVertical"].ToString(); } //Siddharth 9 Sept 2015 Start } return(objcontract); } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, VIEWCONTRACT, EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER); } finally { if (objConnection.State == ConnectionState.Open) { objConnection.Close(); } } }
/// <summary> /// This method will fetch record based on criteria object from data base and return back to buisness layer. /// </summary> /// <param name="criteria"></param> /// <returns></returns> public List <BusinessEntities.Contract> GetContracts(BusinessEntities.ContractCriteria criteria) { int pageCount = 1; int counter = 0; DataAccessClass objDAContractsForProject = new DataAccessClass(); try { //Getting List in which data will hold List <BusinessEntities.Contract> contractList = new List <BusinessEntities.Contract>(); DataSet dsContractsForProject = null; objDAContractsForProject.OpenConnection(DBConstants.GetDBConnectionString()); //At loading firstTime if (criteria.Mode == 1) { SqlParameter[] sqlParam = new SqlParameter[2]; sqlParam[0] = new SqlParameter(SPParameter.ContractId, DbType.Int32); sqlParam[0].Value = criteria.ContractId; sqlParam[1] = new SqlParameter(SPParameter.Mode, DbType.Int32); sqlParam[1].Value = criteria.Mode; //--get result dsContractsForProject = objDAContractsForProject.GetDataSet(SPNames.Contract_GetContract, sqlParam); } //At the time of filtering else { SqlParameter[] sqlParam = new SqlParameter[8]; sqlParam[0] = new SqlParameter(SPParameter.SortExpression, DbType.String); if (!string.IsNullOrEmpty(criteria.SortExpression)) { if (criteria.SortExpression == CommonConstants.CON_CONTRACTCODE) { sqlParam[0].Value = criteria.SortExpression + criteria.Direction; } else { sqlParam[0].Value = criteria.SortExpression + criteria.Direction + "," + CommonConstants.CON_CONTRACTCODE + criteria.Direction; } } else { sqlParam[0].Value = CommonConstants.CON_CONTRACTCODE + " ASC"; } sqlParam[1] = new SqlParameter(SPParameter.pageNum, DbType.Int32); sqlParam[1].Value = criteria.PageNumber; sqlParam[2] = new SqlParameter(SPParameter.@DocumentName, DbType.String); if (!string.IsNullOrEmpty(criteria.DocumentName)) { sqlParam[2].Value = criteria.DocumentName; } else { sqlParam[2].Value = DBNull.Value; } sqlParam[3] = new SqlParameter(SPParameter.ContractType, DbType.Int32); sqlParam[3].Value = criteria.ContractTypeID; sqlParam[4] = new SqlParameter(SPParameter.ContractStatus, DbType.Int32); sqlParam[4].Value = criteria.ContractStatus; sqlParam[5] = new SqlParameter(SPParameter.pageSize, DbType.Int32); sqlParam[5].Value = 10; sqlParam[6] = new SqlParameter(SPParameter.ClientName, DbType.Int32); sqlParam[6].Value = criteria.ClientNameId; sqlParam[7] = new SqlParameter(SPParameter.pageCount, SqlDbType.Int); sqlParam[7].Direction = ParameterDirection.Output; //--get result dsContractsForProject = objDAContractsForProject.GetDataSet(SPNames.Contract_GetContractInFilter, sqlParam); //Get the pagecount from output parameter. pageCount = Convert.ToInt32(sqlParam[7].Value); } //--Create entities and add to list BusinessEntities.Contract objBEContractsForProject = null; counter = 0; //assigning the values to contract object and add that object into list. foreach (DataRow dr in dsContractsForProject.Tables[0].Rows) { counter++; objBEContractsForProject = new BusinessEntities.Contract(); if (dr[DbTableColumn.Con_ContractId] != null) { objBEContractsForProject.ContractID = Convert.ToInt32(dr[DbTableColumn.Con_ContractId]); } if (dr[DbTableColumn.Con_ContractRefId] != null) { objBEContractsForProject.ContractReferenceID = dr[DbTableColumn.Con_ContractRefId].ToString(); } if (dr[DbTableColumn.Con_ContractCode] != null) { objBEContractsForProject.ContractCode = dr[DbTableColumn.Con_ContractCode].ToString(); } if (dr[DbTableColumn.Con_ContractName] != null) { objBEContractsForProject.ContractType = dr[DbTableColumn.Con_ContractName].ToString(); } if (dr[DbTableColumn.Con_DocumentName] != null) { objBEContractsForProject.DocumentName = dr[DbTableColumn.Con_DocumentName].ToString(); } if (dr[DbTableColumn.Con_FirstName] != null) { objBEContractsForProject.FirstName = dr[DbTableColumn.Con_FirstName].ToString() + " " + dr[DbTableColumn.Con_LastName].ToString(); } if (dr[DbTableColumn.ClientName] != null) { objBEContractsForProject.ClientName = dr[DbTableColumn.ClientName].ToString(); } if (dr[DbTableColumn.Con_ContractProjectId] != null) { objBEContractsForProject.ProjectId = Convert.ToInt32(dr[DbTableColumn.Con_ContractProjectId].ToString()); } //Add page count to objBEContractsForProject. if (counter == 1 && criteria.Mode != 1) { objBEContractsForProject.PageCount = pageCount; } //--add to list contractList.Add(objBEContractsForProject); } //return fetched record return(contractList); } catch (RaveHRException ex) { throw ex; } catch (Exception ex) { throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, Contracts, GETCONTRACTS, EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER); } finally { objDAContractsForProject.CloseConncetion(); } }