public List <BusinessEntities.Master> GetMasterData(string strCategory)
{
try
{
Rave.HR.DataAccessLayer.Projects.RaveHRMaster objDropDownDAL = new Rave.HR.DataAccessLayer.Projects.RaveHRMaster();
DataTable dtDropDown = new DataTable();
dtDropDown = objDropDownDAL.FillDropDownList(strCategory);
List <BusinessEntities.Master> objListDropDown = new List <BusinessEntities.Master>();
BusinessEntities.Master objRaveHRMaster = null;
foreach (DataRow drProjectDetails in dtDropDown.Rows)
{
objRaveHRMaster = new BusinessEntities.Master();
objRaveHRMaster.MasterId = int.Parse(drProjectDetails["MasterID"].ToString());
objRaveHRMaster.MasterName = drProjectDetails["MasterName"].ToString();
objListDropDown.Add(objRaveHRMaster);
}
return(objListDropDown);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, "RaveHRMaster.cs", "GetMasterData", EventIDConstants.RAVE_HR_PROJECTS_BUSNIESS_LAYER);
}
finally
{
}
}
/// <summary>
/// Gets master data such as ProjectStatus, MRFStatus etc.
/// </summary>
/// <returns>List</returns>
public List <BusinessEntities.Master> GetMasterData(string Category)
{
try
{
Rave.HR.DataAccessLayer.Common.Master masterData = new Rave.HR.DataAccessLayer.Common.Master();
DataTable dtMasterData = new DataTable();
dtMasterData = masterData.FillDropDownList(Category);
List <BusinessEntities.Master> listMasterData = new List <BusinessEntities.Master>();
BusinessEntities.Master fetchMasterData = null;
foreach (DataRow drMasterData in dtMasterData.Rows)
{
fetchMasterData = new BusinessEntities.Master();
fetchMasterData.MasterId = int.Parse(drMasterData["MasterID"].ToString());
fetchMasterData.MasterName = drMasterData["MasterName"].ToString();
listMasterData.Add(fetchMasterData);
}
return(listMasterData);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
//throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, "RaveHRMaster.cs", "GetMasterData");
}
}
/// <summary>
/// Returns Project Summary data for GridView
/// </summary>
/// <returns>List</returns>
private List <BusinessEntities.Projects> GetProjectSummaryData(bool setPageing)
{
if (grdvListofProjects.BottomPagerRow != null)
{
GridViewRow gvrPager = grdvListofProjects.BottomPagerRow;
TextBox txtPages = (TextBox)gvrPager.Cells[0].FindControl("txtPages");
if (txtPages.Text != "" && int.Parse(txtPages.Text) != 0 && Convert.ToInt32(txtPages.Text) <= Convert.ToInt32(Session[sessionPageCount].ToString()))
{
objProjectCriteria.PageNumber = int.Parse(txtPages.Text);
}
}
else
{
objProjectCriteria.PageNumber = Convert.ToInt32(Session[SessionNames.CURRENT_PAGE_INDEX_PROJECT].ToString());
}
//checks if PageNumber=0 then assign 1 to it
if (objProjectCriteria.PageNumber == 0)
{
objProjectCriteria.PageNumber = 1;
}
Rave.HR.BusinessLayer.Projects.Projects objProjectSummaryBAL = new Rave.HR.BusinessLayer.Projects.Projects();
BusinessEntities.Master objGetProjectStatus = new BusinessEntities.Master();
BusinessEntities.Projects objGetProjectSummary = new BusinessEntities.Projects();
List <BusinessEntities.Projects> objListProjectSummary = new List <BusinessEntities.Projects>();
try
{
if (Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME] == null || Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME].ToString() == string.Empty)
{
objGetProjectSummary.ProjectName = null;
}
else
{
objGetProjectSummary.ProjectName = Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME].ToString();
}
if (Session[SessionNames.CLIENT_NAME] == null || Session[SessionNames.CLIENT_NAME].ToString() == SELECT)
{
objGetProjectSummary.ClientName = null;
}
else
{
objGetProjectSummary.ClientName = Session[SessionNames.CLIENT_NAME].ToString();
}
if ((objProjectCriteria.RolePM == AuthorizationManagerConstants.ROLEPROJECTMANAGER) || (objProjectCriteria.RoleRPM == AuthorizationManagerConstants.ROLERPM) || (objProjectCriteria.RoleCOO == AuthorizationManagerConstants.ROLECOO))
{
if (Session[SessionNames.PROJECT_STATUS] == null || Session[SessionNames.PROJECT_STATUS].ToString() == SELECT)
{
objGetProjectStatus.MasterId = 0;
}
else
{
objGetProjectStatus.MasterId = Convert.ToInt32(Session[SessionNames.PROJECT_STATUS].ToString());
}
}
else
{
objGetProjectStatus.MasterId = 0;
}
//If any of the session is null or Contains text "Select" get the page load data
if ((Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME] == null || Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME].ToString() == string.Empty) && (Session[SessionNames.CLIENT_NAME] == null || Session[SessionNames.CLIENT_NAME].ToString() == SELECT) && (Session[SessionNames.PROJECT_STATUS] == null || Session[SessionNames.PROJECT_STATUS].ToString() == SELECT))
{
objListProjectSummary = objProjectSummaryBAL.GetProjectSummaryForPageLoad(objProjectCriteria, PAGE_SIZE, ref pageCount, setPageing);
}
//Else get the filtered data based upon filter critera selection
else
{
objListProjectSummary = objProjectSummaryBAL.GetProjectSummaryForFilter(objGetProjectSummary, objGetProjectStatus, objProjectCriteria, PAGE_SIZE, ref pageCount, setPageing);
}
Session[sessionPageCount] = pageCount;
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetDataProjectSummaryApplyFilter", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
return(objListProjectSummary);
}
public DataTable GetFilteredProjectSummaryList(BusinessEntities.Projects objGetProjectSummary, BusinessEntities.Master objGetProjectStatus, string UserMailId, string COORole, string PresalesRole, string PMRole, string RPMRole)
{
Rave.HR.DataAccessLayer.Projects.Projects objGetProjectSummaryDAL = new Rave.HR.DataAccessLayer.Projects.Projects();
DataSet dsProjectSummary = new DataSet();
DataTable dt = new DataTable();
try
{
dsProjectSummary = objGetProjectSummaryDAL.GetProjectSummaryForFilter(objGetProjectSummary, objGetProjectStatus, UserMailId, COORole, PresalesRole, PMRole, RPMRole);
dt = dsProjectSummary.Tables[0];
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, PROJECTS, "GetFilteredProjectSummaryList", EventIDConstants.RAVE_HR_PROJECTS_BUSNIESS_LAYER);
}
return(dt);
}
public List <BusinessEntities.Projects> GetProjectSummaryForFilter(BusinessEntities.Projects objGetProjectSummary, BusinessEntities.Master objGetProjectStatus, BusinessEntities.ProjectCriteria objProjectCriteria, int pageSize, ref int pageCount, bool setPageing)
{
List <BusinessEntities.Projects> objProjectSummary = new List <BusinessEntities.Projects>();
try
{
Rave.HR.DataAccessLayer.Projects.Projects objGetProjectSummaryDAL = new Rave.HR.DataAccessLayer.Projects.Projects();
objProjectSummary = objGetProjectSummaryDAL.GetProjectSummaryForFilter(objGetProjectSummary, objGetProjectStatus, objProjectCriteria, pageSize, ref pageCount, setPageing);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, PROJECTS, "GetProjectSummaryForFilter", EventIDConstants.RAVE_HR_PROJECTS_BUSNIESS_LAYER);
}
return(objProjectSummary);
}