/// <summary>
/// This method will fetch record of project details under particular contract
/// specified in criteria object from data base
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public List <BusinessEntities.ContractProject> GetProjectsForContracts(ContractCriteria criteria)
{
try
{
//instantiate contract project objectof data layer
objContractProj = new Rave.HR.DataAccessLayer.Contracts.ContractProject();
return(objContractProj.GetProjectForContracts(criteria));
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CONTRACTPROJECT, GETPROJECTSFORCONTRACT, EventIDConstants.RAVE_HR_CONTRACT_BUSNIESS_LAYER);
}
}
public List <BusinessEntities.ContractProject> GetProjectDetailsForFilter(BusinessEntities.ContractProject objGridDetail, ContractCriteria criteria)
{
int pageCount = 1;
int counter = 0;
List <BusinessEntities.ContractProject> objListOfProjects = null;
// Initialise Data Access Class object
DataAccessClass objProjectDetails = new DataAccessClass();
// Initialise Collection class object
raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
//Open the connection to DB
objProjectDetails.OpenConnection(DBConstants.GetDBConnectionString());
SqlParameter[] sqlParam = new SqlParameter[7];
sqlParam[0] = new SqlParameter(SPParameter.SortExpresion, DbType.String);
sqlParam[0].Value = criteria.SortExpression + criteria.Direction;
sqlParam[1] = new SqlParameter(SPParameter.pageNum, DbType.Int32);
sqlParam[1].Value = criteria.PageNumber;
sqlParam[2] = new SqlParameter(SPParameter.pageSize, DbType.Int32);
sqlParam[2].Value = 10;
sqlParam[3] = new SqlParameter(SPParameter.ClientName, SqlDbType.VarChar);
if (objGridDetail.ClientName == null)
{
sqlParam[3].Value = DBNull.Value;
}
else
{
sqlParam[3].Value = objGridDetail.ClientName;
}
sqlParam[4] = new SqlParameter(SPParameter.ProjectName, SqlDbType.VarChar);
sqlParam[4].Value = objGridDetail.ProjectName;
sqlParam[5] = new SqlParameter(SPParameter.StatusId, SqlDbType.Int);
sqlParam[5].Value = objGridDetail.StatusID;
sqlParam[6] = new SqlParameter(SPParameter.pageCount, SqlDbType.Int);
sqlParam[6].Direction = ParameterDirection.Output;
//gets the all project details.
DataSet dsProjectdetails = objProjectDetails.GetDataSet(SPNames.CONTRACT_GETPROJECTLISTFORFILER, sqlParam);
pageCount = Convert.ToInt32(sqlParam[6].Value);
//Create entities and add to list
BusinessEntities.ContractProject objProjects = null;
objListOfProjects = new List <BusinessEntities.ContractProject>();
foreach (DataRow dr in dsProjectdetails.Tables[0].Rows)
{
counter++;
objProjects = new BusinessEntities.ContractProject();
objProjects.ProjectCode = dr[DbTableColumn.Con_ProjectCode].ToString();
objProjects.DocumentName = dr[DbTableColumn.Con_DocumentName].ToString();
objProjects.ContractCode = dr[DbTableColumn.Con_ContractCode].ToString();
objProjects.ProjectName = dr[DbTableColumn.Con_ConProjectName].ToString();
objProjects.ContractType = dr[DbTableColumn.Con_ContractName].ToString();
objProjects.ClientName = dr[DbTableColumn.ClientName].ToString();
//add page count only first time.
if (counter == 1)
{
objProjects.PageCount = pageCount;
}
//--add to list
objListOfProjects.Add(objProjects);
}
return(objListOfProjects);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASSNAME, "getClientNameByProjectCode", EventIDConstants.RAVE_HR_CONTRACT_DATA_ACCESS_LAYER);
}
finally
{
objProjectDetails.CloseConncetion();
}
}
