private void GetProjectNameNIS()
{
try
{
AuthorizationManager objRaveHRAuthorizationManager = new AuthorizationManager();
UserRaveDomainId = objRaveHRAuthorizationManager.getLoggedInUser();
UserRaveDomainId = UserRaveDomainId.Replace("co.in", "com");
//Declaring COllection class object
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
//Declaring Master Class Object
Rave.HR.BusinessLayer.Employee.Employee employee = new Rave.HR.BusinessLayer.Employee.Employee();
//Calling Fill dropdown Business layer method to fill
//the dropdown from Employee Business class.
raveHrColl = employee.FillProjectNameNISDropDowns(UserRaveDomainId, objParameter.Role);
ddlProject.Items.Clear();
ddlProject.DataSource = raveHrColl;
ddlProject.DataTextField = Common.CommonConstants.DDL_DataTextField;
ddlProject.DataValueField = Common.CommonConstants.DDL_DataValueField;
ddlProject.DataBind();
//ddlProject.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetConsolidated", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
/// <summary>
/// Manipulates the specified obj qualification details list.
/// </summary>
/// <param name="objQualificationDetailsList">The obj qualification details list.</param>
public void Manipulation(BusinessEntities.RaveHRCollection objCRDetailsCollection)
{
try
{
//Check for each each entry in CRDetails List
foreach (BusinessEntities.Contract objAddCRDetails in objCRDetailsCollection)
{
if (objAddCRDetails.Mode == "1")
{
this.AddCRDetails(objAddCRDetails);
}
if (objAddCRDetails.Mode == "2")
{
this.UpdateCRDetails(objAddCRDetails);
}
if (objAddCRDetails.CRId > 0 && objAddCRDetails.Mode == "3")
{
this.DeleteCRDetails(objAddCRDetails);
}
}
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, CONTRACT, "Manipulation", EventIDConstants.RAVE_HR_EMPLOYEE_BUSNIESS_LAYER);
}
}
//Umesh: NIS-changes: Skill Search Report Starts
public BusinessEntities.RaveHRCollection GetPrimaryAndSecondarySkills()
{
objDA = new DataAccessClass();
try
{
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
objDA.OpenConnection(DBConstants.GetDBConnectionString());
objDataReader = objDA.ExecuteReaderSP(SPNames.Employee_GetPrimaryAndSecondarySkills);
while (objDataReader.Read())
{
KeyValue <string> keyValue = new KeyValue <string>();
keyValue.KeyName = objDataReader.GetValue(0).ToString();
keyValue.Val = objDataReader.GetValue(0).ToString();
raveHRCollection.Add(keyValue);
}
return(raveHRCollection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objDataReader != null)
{
objDataReader.Close();
}
objDA.CloseConncetion();
}
}
/// <summary>
/// Populate the grid according to sorting criteria.
/// </summary>
/// <param name="Mode"></param>
private void populateGridWithPRojectDetails(int Mode)
{
try
{
BusinessEntities.ContractProject objGridDetail = new BusinessEntities.ContractProject();
//Declare contractproject class object.
Rave.HR.BusinessLayer.Contracts.ContractProject projectDetails = new Rave.HR.BusinessLayer.Contracts.ContractProject();
BusinessEntities.RaveHRCollection CollectionGridDetail = new BusinessEntities.RaveHRCollection();
//Declare list of contractproject class object.
List <BusinessEntities.ContractProject> objListOfProjects = new List <BusinessEntities.ContractProject>();
//On pageload get the data with default sorting.
if (Mode == 1)
{
CollectionGridDetail = projectDetails.GetProjectsListDetails(GetCriteriaForPageload());
for (int i = 0; i < CollectionGridDetail.Count; i++)
{
foreach (List <BusinessEntities.ContractProject> con in CollectionGridDetail)
{
foreach (BusinessEntities.ContractProject c in con)
{
objGridDetail = (BusinessEntities.ContractProject)c;
objListOfProjects.Add(objGridDetail);
}
}
}
}
else
{
//Get the data with paging & sorting.
CollectionGridDetail = projectDetails.GetProjectsListDetails(GetCriteriaForPagingAndSorting());
for (int i = 0; i < CollectionGridDetail.Count; i++)
{
foreach (List <BusinessEntities.ContractProject> con in CollectionGridDetail)
{
foreach (BusinessEntities.ContractProject c in con)
{
objGridDetail = (BusinessEntities.ContractProject)c;
objListOfProjects.Add(objGridDetail);
}
}
}
}
//Bind the grid with respective data.
BindData(objListOfProjects);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME_LISTOFPROJECT, "populateGridWithPRojectDetails", EventIDConstants.RAVE_HR_CONTRACT_PRESENTATION_LAYER);
}
}
/// <summary>
/// Binds The Grid for Filter.
/// </summary>
/// <param name="Mode"></param>
private void BindGrid()
{
BusinessEntities.ContractProject objGridDetail = new BusinessEntities.ContractProject();
if (Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME] != null)
{
objGridDetail.ProjectName = Session[SessionNames.PROJECT_SUMMARY_PROJECT_NAME].ToString();
}
if (Session[SessionNames.CLIENT_NAME] != null)
{
objGridDetail.ClientName = Session[SessionNames.CLIENT_NAME].ToString();
}
if (Session[SessionNames.STATUS] != null)
{
objGridDetail.StatusID = Convert.ToInt32(Session[SessionNames.STATUS].ToString());
}
//Declare contractproject class object.
Rave.HR.BusinessLayer.Contracts.ContractProject projectDetails = new Rave.HR.BusinessLayer.Contracts.ContractProject();
BusinessEntities.RaveHRCollection CollectionGridDetail = new BusinessEntities.RaveHRCollection();
//Declare list of contractproject class object.
List <BusinessEntities.ContractProject> objListOfProjects = new List <BusinessEntities.ContractProject>();
objListOfProjects = projectDetails.GetProjectsDetailsForFilter(objGridDetail, GetCriteriaForPageload());
BindData(objListOfProjects);
}
/// <summary>
/// Gets the master data for the Asset or employee dropdown.
/// </summary>
private void GetSectionByBranch(int branchId)
{
try
{
raveHRCollection = new RaveHRCollection();
//Invoke the object of business layer to call BusinessLayer method.
objBLSeatAllocation = new Rave.HR.BusinessLayer.SeatAllocation.SeatAllocation();
//Get the Branchs of rave.
raveHRCollection = objBLSeatAllocation.GetSectionByBranch(branchId);
//Bind the dropdown with data.
RbListSeatAllocation.DataSource = raveHRCollection;
RbListSeatAllocation.DataValueField = SectionId;
RbListSeatAllocation.DataTextField = SectionName;
RbListSeatAllocation.DataBind();
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetMasterDataForBranch", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
}
}
private void GetMRFCode()
{
//Declaring COllection class object
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
//Declaring Master Class Object
Rave.HR.BusinessLayer.Employee.Employee employee = new Rave.HR.BusinessLayer.Employee.Employee();
try
{
//Calling Fill dropdown Business layer method to fill
//the dropdown from Employee Business class.
raveHrColl = employee.FillMRFCodeDropDowns();
ddlMRFCode.Items.Clear();
ddlMRFCode.DataSource = raveHrColl;
ddlMRFCode.DataTextField = Common.CommonConstants.DDL_DataTextField;
ddlMRFCode.DataValueField = Common.CommonConstants.DDL_DataValueField;
ddlMRFCode.DataBind();
ddlMRFCode.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetMRFCode", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
private void GetEmployeeLocation()
{
Rave.HR.BusinessLayer.Common.Master master = new Rave.HR.BusinessLayer.Common.Master();
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
try
{
raveHrColl = master.FillDropDownsBL((int)Common.EnumsConstants.Category.CandidateLocation);
ddlLocation.ClearSelection();
//ddlLocation.Items.Clear();
ddlLocation.DataSource = raveHrColl;
ddlLocation.DataTextField = Common.CommonConstants.DDL_DataTextField;
ddlLocation.DataValueField = Common.CommonConstants.DDL_DataValueField;
ddlLocation.DataBind();
ddlLocation.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetEmployeeLocation", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
private BusinessEntities.RaveHRCollection GetHeadCountReport(string SortExpressionAndDirection)
{
BusinessEntities.Projects project = new Projects();
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
Rave.HR.BusinessLayer.Employee.Employee employeeBL = new Rave.HR.BusinessLayer.Employee.Employee();
try
{
project.ProjectDivision = ddlDivision.SelectedValue != "Select" ? Convert.ToInt32(ddlDivision.SelectedValue) : 0;
project.ProjectBussinessArea = ddlBusinessArea.SelectedValue != "Select" ? Convert.ToInt32(ddlBusinessArea.SelectedValue) : 0;
project.ProjectBussinessSegment = ddlBusinessSegment.SelectedValue != "Select" ? Convert.ToInt32(ddlBusinessSegment.SelectedValue) : 0;
//Siddharth 27 March 2015 Start
raveHRCollection = employeeBL.GetHeadCountReport(project, SortExpressionAndDirection);
//Siddharth 27 March 2015 End
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetHeadCountReport", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
return(raveHRCollection);
}
/// <summary>
/// Gets the professional details.
/// </summary>
/// <returns></returns>
private BusinessEntities.RaveHRCollection GetVisaDetails(int employeeID)
{
Rave.HR.BusinessLayer.Employee.VisaDetails objVisaDetailsBAL;
BusinessEntities.VisaDetails objVisaDetails;
// Initialise Collection class object
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
objVisaDetailsBAL = new Rave.HR.BusinessLayer.Employee.VisaDetails();
objVisaDetails = new BusinessEntities.VisaDetails();
//objVisaDetails.EMPId = 14;
objVisaDetails.EMPId = employeeID;
raveHRCollection = objVisaDetailsBAL.GetVisaDetails(objVisaDetails);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetVisaDetails", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
return(raveHRCollection);
}
/// <summary>
/// Gets the certification details.
/// </summary>
/// <returns></returns>
private BusinessEntities.RaveHRCollection GetEmployeeResume(int employeeID)
{
Rave.HR.BusinessLayer.Employee.EmployeeResume objEmployeeResumeBAL;
BusinessEntities.EmployeeResume objEmployeeResume;
// Initialise Collection class object
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
objEmployeeResumeBAL = new Rave.HR.BusinessLayer.Employee.EmployeeResume();
objEmployeeResume = new BusinessEntities.EmployeeResume();
//objCertificationDetails.EMPId = 14;
objEmployeeResume.EMPId = employeeID;
raveHRCollection = objEmployeeResumeBAL.GetEmployeeResumeDetails(objEmployeeResume);
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetEmployeeResumeDetails", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
return(raveHRCollection);
}
private void PopulateData()
{
try
{
Rave.HR.BusinessLayer.MRF.MRFDetail MrfBL = new Rave.HR.BusinessLayer.MRF.MRFDetail();
BusinessEntities.RaveHRCollection collObj = new BusinessEntities.RaveHRCollection();
string SkillName = string.Empty;
if (!string.IsNullOrEmpty(txtSkillsName.Text))
{
SkillName = txtSkillsName.Text;
}
else
{
SkillName = "";
}
collObj = MrfBL.GetSkillsList(SkillName);
grdvListofSkill.DataSource = collObj;
grdvListofSkill.DataBind();
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "PopulateData", EventIDConstants.RAVE_HR_MRF_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
private void ShowHeaderWhenEmptyGrid(BusinessEntities.RaveHRCollection raveHRCollection)
{
try
{
//set header visible
grdvHeadCount.ShowHeader = true;
// Disable sorting
grdvHeadCount.AllowSorting = false;
//Create empty datasource for Grid view and bind
raveHRCollection.Add(new BusinessEntities.Employee());
grdvHeadCount.DataSource = raveHRCollection;
grdvHeadCount.DataBind();
//clear all the cells in the row
grdvHeadCount.Rows[0].Cells.Clear();
//add a new blank cell
grdvHeadCount.Rows[0].Cells.Add(new TableCell());
grdvHeadCount.Rows[0].Cells[0].Text = CommonConstants.NO_RECORDS_FOUND_MESSAGE;
grdvHeadCount.Rows[0].Cells[0].Wrap = false;
grdvHeadCount.Rows[0].Cells[0].Width = Unit.Percentage(10);
}
catch
{
}
}
/// <summary>
/// Deallocate the employee from seat.
/// </summary>
/// <returns></returns>
public List <BusinessEntities.SeatAllocation> UnallocatedEmployee()
{
DataAccessClass objDASeatAllocation = new DataAccessClass();
List <BusinessEntities.SeatAllocation> objListSeatAlloctaion = null;
// Initialise Collection class object
raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
objDASeatAllocation.OpenConnection(DBConstants.GetDBConnectionString());
//--get result
DataSet dsSeatDescription = objDASeatAllocation.GetDataSet(SPNames.SeatAllocation_GetUnallocatedEmployee);
//--Create entities and add to list
BusinessEntities.SeatAllocation objBESeatDetail = null;
objListSeatAlloctaion = new List <BusinessEntities.SeatAllocation>();
foreach (DataRow dr in dsSeatDescription.Tables[0].Rows)
{
objBESeatDetail = new BusinessEntities.SeatAllocation();
if (dr[DbTableColumn.Seat_EmployeeID].ToString() != string.Empty)
{
objBESeatDetail.EmployeeID = Convert.ToInt32(dr[DbTableColumn.Seat_EmployeeID]);
}
if (dr[DbTableColumn.Seat_EmployeeCode].ToString() != string.Empty)
{
objBESeatDetail.EmployeeCode = dr[DbTableColumn.Seat_EmployeeCode].ToString();
}
if (dr[DbTableColumn.Seat_EmployeeName].ToString() != string.Empty)
{
objBESeatDetail.EmployeeName = dr[DbTableColumn.Seat_EmployeeName].ToString();
}
if (dr[DbTableColumn.Seat_EMPEmailID].ToString() != string.Empty)
{
objBESeatDetail.EmployeeEmailID = dr[DbTableColumn.Seat_EMPEmailID].ToString();
}
//--add to list
objListSeatAlloctaion.Add(objBESeatDetail);
}
return(objListSeatAlloctaion);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASSNAME, "UnallocatedEmployee", EventIDConstants.RAVE_HR_SEATALLOCATION_DATA_ACCESS_LAYER);
}
finally
{
objDASeatAllocation.CloseConncetion();
}
}
/// <summary>
/// Handles the RowDeleting event of the gvVisaDetails control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.WebControls.GridViewDeleteEventArgs"/> instance containing the event data.</param>
protected void gvVisaDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int deleteRowIndex = 0;
int rowIndex = -1;
BusinessEntities.VisaDetails objVisaDetails = new BusinessEntities.VisaDetails();
deleteRowIndex = e.RowIndex;
objVisaDetails = (BusinessEntities.VisaDetails)VisaDetailsCollection.Item(deleteRowIndex);
objVisaDetails.Mode = 3;
if (ViewState[VISADETAILSDELETE] != null)
{
BusinessEntities.RaveHRCollection objDeleteVisaDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[VISADETAILSDELETE];
objDeleteVisaDetailsCollection.Add(objVisaDetails);
ViewState[VISADETAILSDELETE] = objDeleteVisaDetailsCollection;
}
else
{
BusinessEntities.RaveHRCollection objDeleteVisaDetailsCollection1 = new BusinessEntities.RaveHRCollection();
objDeleteVisaDetailsCollection1.Add(objVisaDetails);
ViewState[VISADETAILSDELETE] = objDeleteVisaDetailsCollection1;
}
VisaDetailsCollection.RemoveAt(deleteRowIndex);
ViewState[DELETEROWINDEX] = deleteRowIndex;
DoDataBind();
if (ViewState[ROWINDEX] != null)
{
rowIndex = Convert.ToInt32(ViewState[ROWINDEX].ToString());
//check edit index with deleted index if edit index is greater than or equal to delete index then rowindex decremented.
if (rowIndex != -1 && deleteRowIndex <= rowIndex)
{
rowIndex--;
//store the rowindex in viewstate.
ViewState[ROWINDEX] = rowIndex;
}
ImageButton btnImg = (ImageButton)gvVisaDetails.Rows[rowIndex].FindControl(IMGBTNDELETE);
btnImg.Enabled = false;
//Disabling all the edit buttons.
for (int i = 0; i < gvVisaDetails.Rows.Count; i++)
{
if (rowIndex != i)
{
ImageButton btnImgEdit = (ImageButton)gvVisaDetails.Rows[i].FindControl(IMGBTNEDIT);
btnImgEdit.Enabled = false;
}
}
}
}
/// <summary>
/// Gets the skills.
/// </summary>
private RaveHRCollection GetSkills()
{
Rave.HR.BusinessLayer.Employee.SkillsDetails objSkillTypeBL = new Rave.HR.BusinessLayer.Employee.SkillsDetails();
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
raveHrColl = objSkillTypeBL.GetPrimaryAndSecondarySkills();
return(raveHrColl);
}
private void FillDepartment(string role)
{
//Declaring COllection class object
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
DataSet dsDepartment = null;
Rave.HR.BusinessLayer.FourC.FourC fourCBAL = new Rave.HR.BusinessLayer.FourC.FourC();
if (role == MasterEnum.FourCRole.RMS_FUNCTIONALMANAGER.ToString())
{
dsDepartment = fourCBAL.GetFunctionalManagerDeptName(int.Parse(ViewState["LoginEmpId"].ToString()));
}
else
{
////Declaring Master Class Object
//Rave.HR.BusinessLayer.Common.Master master = new Rave.HR.BusinessLayer.Common.Master();
////Calling Fill dropdown Business layer method to fill
////the dropdown from Master class.
//raveHRCollection = master.FillDepartmentDropDownBL();
dsDepartment = fourCBAL.GetDepartmentName("");
}
if (dsDepartment != null)
{
ddlDepartment.Items.Clear();
ddlDepartment.DataSource = dsDepartment;
ddlDepartment.DataTextField = dsDepartment.Tables[0].Columns[1].ToString();
ddlDepartment.DataValueField = dsDepartment.Tables[0].Columns[0].ToString();
ddlDepartment.DataBind();
//ddlDepartment.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
ddlDepartment.Items.Insert(0, new ListItem(CommonConstants.SELECT, CommonConstants.ZERO.ToString()));
//remove the Dept Name
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByValue(CommonConstants.DeptId_RaveDevelopment.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.PRESALES_USA.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.PRESALES_UK.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.PRESALES_INDIA.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.RAVECONSULTANT_USA.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.RAVECONSULTANT_UK.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.RAVEFORCASTEDPROJECT.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.SALES_DEPARTMENT.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.Senior_Mgt_DEPARTMENT.ToString()));
ddlDepartment.Items.Remove(ddlDepartment.Items.FindByText(CommonConstants.Project_Mentee2010_DEPARTMENT.ToString()));
}
//ddlDepartment.Items.Clear();
//ddlDepartment.DataSource = raveHRCollection;
//ddlDepartment.DataTextField = Common.CommonConstants.DDL_DataTextField;
//ddlDepartment.DataValueField = Common.CommonConstants.DDL_DataValueField;
//ddlDepartment.DataBind();
//ddlDepartment.Items.Insert(0, new ListItem(CommonConstants.SELECT, CommonConstants.ZERO.ToString()));
////remove the Dept Name called RaveDevelopment from Dropdown -Vandna
//ddlDepartment.Items.Remove(ddlDepartment.Items.FindByValue(CommonConstants.DeptId_RaveDevelopment.ToString()));
}
/// <summary>
/// Fills the Project Name dropdown
/// </summary>
private void FillProjectNameDropDown()
{
// Initialise Collection class object
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// Initialise Business layer object
Rave.HR.BusinessLayer.MRF.MRFDetail mrfProjectName = new Rave.HR.BusinessLayer.MRF.MRFDetail();
try
{
// Call the Business layer method
raveHRCollection = mrfProjectName.GetProjectName();
DataSet dsProject = null;
Rave.HR.BusinessLayer.FourC.FourC fourCBAL = new Rave.HR.BusinessLayer.FourC.FourC();
dsProject = fourCBAL.GetProjectNameAddCreatorReviewer();
if (raveHRCollection != null)
{
// Assign the data source to dropdown
ddlProject.DataSource = dsProject;
//ddlProject.DataTextField = CommonConstants.DDL_DataTextField;
//ddlProject.DataValueField = CommonConstants.DDL_DataValueField;
ddlProject.DataTextField = dsProject.Tables[0].Columns[1].ToString();
ddlProject.DataValueField = dsProject.Tables[0].Columns[0].ToString();
// Bind the data to dropdown
ddlProject.DataBind();
// Default value of dropdown is "Select"
ddlProject.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
ddlProjectNameFilter.DataSource = raveHRCollection;
ddlProjectNameFilter.DataTextField = CommonConstants.DDL_DataTextField;
ddlProjectNameFilter.DataValueField = CommonConstants.DDL_DataValueField;
// Bind the data to dropdown
ddlProjectNameFilter.DataBind();
// Default value of dropdown is "Select"
ddlProjectNameFilter.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
ddlProjectNameFilter.Enabled = false;
}
}
//catches RaveHRException exception
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "FillProjectNameDropDown", EventIDConstants.RAVE_HR_RP_PRESENTATION_LAYER);
}
}
private void GetConsolidated(string SortExpressionAndDirection)
{
BusinessEntities.Employee employee = new BusinessEntities.Employee();
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
Rave.HR.BusinessLayer.Employee.Employee employeeBL = new Rave.HR.BusinessLayer.Employee.Employee();
try
{
DataSet ds = new DataSet();
ds = employeeBL.GetConsolidated(Convert.ToInt32(ddlProject.SelectedValue), SortExpressionAndDirection);
GVResourcesOnboard.DataSource = ds.Tables[0];
Session["GVResourcesOnboard"] = Convert.ToInt32(ds.Tables[0].Rows.Count);
GVResourcesOnboard.DataBind();
GVResourcesReleased.DataSource = ds.Tables[1];
Session["GVResourcesReleased"] = Convert.ToInt32(ds.Tables[1].Rows.Count);
GVResourcesReleased.DataBind();
if (ds != null)
{
if (ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
btnExport.Visible = false;
}
else
{
btnExport.Visible = true;
}
if (ds.Tables[0].Rows.Count == 0)
{
TROnBoard.Visible = false;
}
else
{
TROnBoard.Visible = true;
}
if (ds.Tables[1].Rows.Count == 0)
{
TRRelease.Visible = false;
}
else
{
TRRelease.Visible = true;
}
}
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetConsolidated", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
/// <summary>
/// Fill DropDown Method
/// </summary>
private void FillDropDown()
{
//Declaring Master Class Object
Rave.HR.BusinessLayer.Common.Master master = new Rave.HR.BusinessLayer.Common.Master();
try
{
BusinessEntities.MRFDetail mrfDetailobj = new BusinessEntities.MRFDetail();
if (Session[SessionNames.MRFPREVIOUSVALUE] != null)
{
mrfDetailobj = (BusinessEntities.MRFDetail)Session[SessionNames.MRFPREVIOUSVALUE];
}
int testingDeparmentId = mrfDetailobj.DepartmentId;
//Calling Business layer FillDropDown Method
if (testingDeparmentId == (int)MasterEnum.MRFDepartment.Testing)
{
raveHRCollection = master.FillDropDownsBL(testingDeparmentId);
}
else
{
//Calling Business layer FillDropDown Method
raveHRCollection = master.FillDropDownsBL(Convert.ToInt32(Common.EnumsConstants.Category.PrimarySkills));
}
//Check Collection is null or not
if (raveHRCollection != null)
{
//Assign DataSOurce to Collection
ddlSkillCategory.DataSource = raveHRCollection;
//Assign DataText Filed to DropDown
ddlSkillCategory.DataTextField = CommonConstants.DDL_DataTextField;
//Assign DataValue Field to Dropdown
ddlSkillCategory.DataValueField = CommonConstants.DDL_DataValueField;
//Bind Dropdown
ddlSkillCategory.DataBind();
//Insert Select as a item for dropdown
ddlSkillCategory.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
raveHRCollection.Clear();
}
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.PresentationLayer,
CLASS_NAME_RAISEMRF_NEXT, "FillDropDown", EventIDConstants.RAVE_HR_MRF_PRESENTATION_LAYER);
}
}
public void SendEmailForProjectClosed(BusinessEntities.Projects objProjectDetails)
{
try
{
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
string projectManagerEmail = string.Empty;
string strProjectStatus = string.Empty;
string strProjectStatusFlag = objProjectDetails.ProjectStatus;
string sComp = Utility.GetUrl();
string strProjectSummaryLink = sComp + CommonConstants.PROJECTSUMMARY_PAGE;
//Get ProjectManager Name
raveHRCollection = DataAccessLayer.Projects.Projects.GetProjectManagerByProjectId(objProjectDetails);
foreach (BusinessEntities.Projects objProj in raveHRCollection)
{
projectManagerEmail += objProj.EmailIdOfPM;
//projectManagerEmail += ",";
objProjectDetails.EmailIdOfPM = projectManagerEmail;
if (objProjectDetails.EmailIdOfPM.EndsWith(","))
{
objProjectDetails.EmailIdOfPM = objProjectDetails.EmailIdOfPM.Substring(0, objProjectDetails.EmailIdOfPM.Length - 1);
}
}
IRMSEmail obj = new RMSEmail(Convert.ToInt16(EnumsConstants.RMSModule.Projects),
Convert.ToInt16(EnumsConstants.EmailFunctionality.DeletedProject));
obj.To.Add(objProjectDetails.EmailIdOfPM);
obj.Subject = string.Format(obj.Subject, objProjectDetails.ProjectCode,
objProjectDetails.ClientName,
objProjectDetails.ProjectName);
obj.Body = string.Format(obj.Body, objProjectDetails.ProjectName,
objProjectDetails.ClientName,
GetHTMLForProjectClosed(objProjectDetails),
strProjectSummaryLink);
obj.SendEmail(obj);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.BusinessLayer, PROJECTS, SEND_MAIL_CLOSED_PROJECT, EventIDConstants.RAVE_HR_PROJECTS_BUSNIESS_LAYER);
}
}
/// <summary>
/// Gets the type of the skills.
/// </summary>
/// <param name="SkillType">Type of the skill.</param>
private void GetSkillsByType(int SkillType)
{
Rave.HR.BusinessLayer.Common.Master master = new Rave.HR.BusinessLayer.Common.Master();
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
raveHrColl = master.FillDropDownsBL(SkillType);
ddlSkills.DataSource = raveHrColl;
ddlSkills.DataTextField = Common.CommonConstants.DDL_DataTextField;
ddlSkills.DataValueField = Common.CommonConstants.DDL_DataValueField;
ddlSkills.DataBind();
ddlSkills.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
}
/// <summary>
/// Gets the bifurcation.
/// </summary>
private void GetBifurcation()
{
Rave.HR.BusinessLayer.Common.Master master = new Rave.HR.BusinessLayer.Common.Master();
BusinessEntities.RaveHRCollection raveHrColl = new BusinessEntities.RaveHRCollection();
raveHrColl = master.FillDropDownsBL((int)Common.EnumsConstants.Category.ProjectDoneStatus);
ddlBifurcation.DataSource = raveHrColl;
ddlBifurcation.DataTextField = Common.CommonConstants.DDL_DataTextField;
ddlBifurcation.DataValueField = Common.CommonConstants.DDL_DataValueField;
ddlBifurcation.DataBind();
ddlBifurcation.Items.Insert(CommonConstants.ZERO, CommonConstants.SELECT);
}
//Siddhesh Arekar Issue ID : 55884 Closure Type
/// <summary>
/// Get Master Type Details
/// </summary>
/// <param name="category"></param>
/// <returns>string</returns>
public KeyValue <string> GetMasterTypeDetails(int categoryId, string key)
{
try
{
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
Rave.HR.DataAccessLayer.Common.Master master = new Rave.HR.DataAccessLayer.Common.Master();
return(master.GetMasterTypeDetails(categoryId, key));
}
catch (RaveHRException ex)
{
throw ex;
}
}
/// <summary>
/// get the branches of a section.
/// </summary>
/// <param name="branchID"></param>
/// <returns></returns>
public RaveHRCollection GetSectionByBranch(int branchID)
{
BusinessEntities.SeatAllocation objSeatAllocation = null;
SqlDataReader objReader = null;;
DataAccessClass objDASeatAllocation = new DataAccessClass();
try
{
raveHRCollection = new RaveHRCollection();
objDASeatAllocation.OpenConnection(DBConstants.GetDBConnectionString());
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter(SPParameter.BranchID, DbType.Int32);
sqlParam[0].Value = branchID;
objReader = objDASeatAllocation.ExecuteReaderSP(SPNames.SeatAllocation_GetSection, sqlParam);
while (objReader.Read())
{
objSeatAllocation = new BusinessEntities.SeatAllocation();
objSeatAllocation.SectionID = int.Parse(objReader[DbTableColumn.Seat_SectionID].ToString());
objSeatAllocation.SectionName = objReader[DbTableColumn.Seat_SectionName].ToString();
raveHRCollection.Add(objSeatAllocation);
}
return(raveHRCollection);
}
//catches RaveHRException exception
catch (RaveHRException ex)
{
throw ex;
}
//catches genral exception
catch (Exception ex)
{
throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, CLASSNAME, "GetSectionByBranch", EventIDConstants.RAVE_HR_SEATALLOCATION_DATA_ACCESS_LAYER);
}
//close datareader and connection
finally
{
//checks if datareader is null
if (!objReader.IsClosed)
{
//close datareader
objReader.Close();
}
//close connection
objDASeatAllocation.CloseConncetion();
}
}
private void PopulateData()
{
try
{
Rave.HR.BusinessLayer.Employee.Employee empBL = new Rave.HR.BusinessLayer.Employee.Employee();
BusinessEntities.RaveHRCollection collObj = new BusinessEntities.RaveHRCollection();
//Aarohi : Issue 28572(CR) : 05/01/2012 : Start
//Commented the below line of code to add a new parameter for employeeId
//commented for 4C report
//collObj = empBL.GetEmployeesList(txtResourceName.Text.Trim());
//if (hidEMPId.Text != null || hidEMPId.Text == string.Empty || hidEMPId.Text == "")
//if (hidEMPId.Text != null && hidEMPId.Text != string.Empty || hidEMPId.Text != "")
//{
// collObj = empBL.GetEmployeeListForFMRM(txtResourceName.Text.Trim(), hidEMPId.Text);
//}
//else
//{
// collObj = empBL.GetEmployeesList(txtResourceName.Text.Trim());
//}
//Aarohi : Issue 28572(CR) : 05/01/2012 : End
//CASES to show employee
//First to show all sub-ordinate
if (DecryptQueryString("VIEW") != null && !string.IsNullOrEmpty(DecryptQueryString("VIEW")))
{
collObj = empBL.GetEmployeesView(DecryptQueryString("VIEW"), int.Parse(DecryptQueryString("EmpId")), txtResourceName.Text.Trim());
}
else
{
collObj = empBL.GetEmployeesList(txtResourceName.Text.Trim());
}
grdvListofEmployees.DataSource = collObj;
grdvListofEmployees.DataBind();
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "PopulateData", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
//Ishwar Patil : Trainging Module 29/04/2014 : End
// Ishwar NISRMS 13032015 Start
public BusinessEntities.RaveHRCollection FillDropDownsBLForStatus(int categoryId)
{
try
{
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
Rave.HR.DataAccessLayer.Common.Master master = new Rave.HR.DataAccessLayer.Common.Master();
raveHRCollection = master.FillDropDownsDLForStatus(categoryId);
return(raveHRCollection);
}
catch (RaveHRException ex)
{
throw ex;
}
}
//Siddharth 27 March 2015 Start
private DataTable GetSkillSearchDetails(string SortExpressionAndDirection)
{
Rave.HR.BusinessLayer.Employee.SkillsDetails objSkillsDetailsBAL = new Rave.HR.BusinessLayer.Employee.SkillsDetails();
BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
try
{
//Add selected items in collection
IList <string> MandatorySkills = new List <string>();
IList <string> OptionalSkills = new List <string>();
for (int i = 0; i < gvSkillCriteria.Rows.Count; i++)
{
DropDownList ddlSkill = (DropDownList)gvSkillCriteria.Rows[i].FindControl("ddlSkill");
RadioButtonList rblMandatoryOptional = (RadioButtonList)gvSkillCriteria.Rows[i].FindControl("rblMandatoryOptional");
if (rblMandatoryOptional.SelectedValue == "0")
{
if (Convert.ToString(ddlSkill.SelectedValue) != CommonConstants.SELECT)
{
MandatorySkills.Add(ddlSkill.SelectedValue);
}
}
else
{
if (Convert.ToString(ddlSkill.SelectedValue) != CommonConstants.SELECT)
{
OptionalSkills.Add(ddlSkill.SelectedValue);
}
}
}
string commaSeparatedMandatorySkills = String.Join(",", MandatorySkills.ToArray());
string commadSepratedOptionalSkills = String.Join(",", OptionalSkills.ToArray());
dt = new DataTable();
dt = objSkillsDetailsBAL.GetSkillSearchDetails(commaSeparatedMandatorySkills, commadSepratedOptionalSkills, SortExpressionAndDirection);
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "GetEmployeeSummary", EventIDConstants.RAVE_EMP_SKILL_SEARCH_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
return(dt);
}
//Siddharth 26 March 2015 Start
private void SortGridView(string sortExpression, string direction)
{
try
{
sortExpression = "[" + sortExpression + "]";
if (sortExpression == CommonConstants.EMP_FIRSTNAME)
{
objParameter.SortExpressionAndDirection = sortExpression + direction;
}
else
{
objParameter.SortExpressionAndDirection = sortExpression + direction;
}
//This will call the bind function and pass sort details
raveHRCollection = GetHeadCountReport(objParameter.SortExpressionAndDirection);
if (raveHRCollection.Count == 0)
{
grdvHeadCount.DataSource = raveHRCollection;
Session["HeadCountReport"] = raveHRCollection.Count;
grdvHeadCount.DataBind();
ShowHeaderWhenEmptyGrid(raveHRCollection);
//Siddharth 30 April 2015 Start - Clear the Session
Session[SessionNames.PREVIOUS_SORT_EXPRESSION_EMP] = null;
Session[SessionNames.SORT_DIRECTION_EMP] = null;
//Siddharth 30 April 2015 End
btnExport.Visible = false;
}
else
{
grdvHeadCount.AllowSorting = true;
grdvHeadCount.DataSource = raveHRCollection;
grdvHeadCount.DataBind();
btnExport.Visible = true;
}
}
catch (RaveHRException ex)
{
throw ex;
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "SortGridView", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
private void FillEmployeeGrid()
{
//Calling Fill dropdown Business layer method to fill the dropdown
raveHRCollection = mRFDetail.GetEmployeeBL();
//Check Collection object is null or not
if (raveHRCollection != null)
{
//Assign DataSource
gvPopUp.DataSource = raveHRCollection;
//Bind Dropdown
gvPopUp.DataBind();
}
}
