/// <summary>
/// Binds the List Of MRF Grid
/// </summary>
private void BindGridHeadCount()
{
try
{
//Siddharth 7 May 2015 Start
imageDirection = SortOrder.Ascending.ToString();
Session[SessionNames.SORT_DIRECTION_EMP] = null;
//Siddharth 7 May 2015 End
sortExpression = "Division";
raveHRCollection = GetHeadCountReport("Division ASC");
lblCount.Visible = true;
if (raveHRCollection.Count == 0)
{
grdvHeadCount.DataSource = raveHRCollection;
grdvHeadCount.DataBind();
lblCount.Text = " Total Count : 0";
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();
int count = 0;
for (int i = 0; i < raveHRCollection.Count; i++)
{
count = count + Convert.ToInt32(((BusinessEntities.Employee)(raveHRCollection.Item(i))).ResourceTypeCount);
}
lblCount.Text = " Total Count : " + count;
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);
}
}
/// <summary>
/// Mail for Approval
/// </summary>
private void ApprovalMail()
{
mrfDetail = (BusinessEntities.MRFDetail)Session[SessionNames.MRFDETAIL_APPREJMRF];
BusinessEntities.MRFDetail mailDetail = new BusinessEntities.MRFDetail();
Rave.HR.BusinessLayer.MRF.MRFDetail mrfSummaryBL = new Rave.HR.BusinessLayer.MRF.MRFDetail();
mailDetail = mrfSummaryBL.GetMailingDetails(mrfDetail);
EmployeeEmailId = mailDetail.EmailId;
RaisedByEmailId = mailDetail.RaisedBy;
int[] IDs;
Boolean B_ClientName = false;
string ClientName = string.Empty;
//Added by Kanchan for the requirment specified in the Discussion with Sawita Kamath and Gaurav Thakkar.
// Requirment raised: When a mrf is approved the approval mail should go to the reporting to.
if (mailDetail.ReportingToId != null)
{
if (mailDetail.ReportingToId.Contains(","))
{
// countOfReportingTo = mailDetail.ReportingToId.LastIndexOf(",");
string[] allReportingTo;
allReportingTo = mailDetail.ReportingToId.Split(',');
countOfReportingTo = allReportingTo.Length;
IDs = new int[countOfReportingTo];
ReportingToByEmailId_PM = new string[countOfReportingTo];
for (int i = 0; i < countOfReportingTo; i++)
{
IDs[i] = Convert.ToInt32(allReportingTo[i].ToString());
ReportingToByEmailId_PM[i] = getMailID(IDs[i]);
}
}
else
{
ReportingToByEmailId = getMailID(Convert.ToInt32(mailDetail.ReportingToId));
}
raveHRCollection = new BusinessEntities.RaveHRCollection();
raveHRCollection = mrfSummaryBL.GetProjectManagerByProjectId(mailDetail);
BusinessEntities.MRFDetail forPm = new BusinessEntities.MRFDetail();
string Mail = string.Empty;
MailPM = string.Empty;
foreach (BusinessEntities.MRFDetail mrf in raveHRCollection)
{
Mail = string.Empty;
forPm = (BusinessEntities.MRFDetail)raveHRCollection.Item(0);
if (!forPm.PmID.Contains(","))
{
Mail = getMailID(Convert.ToInt32(forPm.EmployeeId));
}
else
{
string[] MailsForPm = forPm.PmID.Split(',');
foreach (string id in MailsForPm)
{
Mail += getMailID(Convert.ToInt32(id)) + ",";
}
}
MailPM += "," + Mail;
if (MailPM.EndsWith(","))
{
MailPM = MailPM.TrimEnd(',');
}
}
}
//Siddharth 26-02-2015 Start
ClientName = mrfDetail.ClientName;
if (ClientName.ToUpper().Contains("NPS") || ClientName.ToUpper().Contains("NORTHGATE"))
{
B_ClientName = true;
}
//Siddharth 26-02-2015 End
#region Coded By Sameer For New MailFunctionality
Rave.HR.BusinessLayer.MRF.MRFDetail objBLMRF = new Rave.HR.BusinessLayer.MRF.MRFDetail();
objBLMRF.SendMailToWhizibleForInternalResourceAllocation(mrfDetail, mailDetail, B_ClientName);
#endregion Coded By Sameer For New MailFunctionality
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (ValidateControls())
{
Rave.HR.BusinessLayer.Employee.VisaDetails objVisaDetailsBAL;
//Rave.HR.BusinessLayer.Employee.Employee objEmployeeBAL;
BusinessEntities.VisaDetails objVisaDetails;
BusinessEntities.RaveHRCollection objSaveVisaDetailsCollection = new BusinessEntities.RaveHRCollection();
try
{
objEmployeeBAL = new Rave.HR.BusinessLayer.Employee.Employee();
if (rbtnValidPassport.SelectedIndex == CommonConstants.ZERO)
{
employee.PassportNo = txtPassportNo.Text;
employee.PassportIssuePlace = txtIssuePlace.Text;
employee.PassportIssueDate = Convert.ToDateTime(txtIssueDate.Text);
employee.PassportExpireDate = Convert.ToDateTime(txtExpiryDate.Text);
if (rbtnValidVisa.SelectedIndex == CommonConstants.ZERO)
{
objVisaDetailsBAL = new Rave.HR.BusinessLayer.Employee.VisaDetails();
if (gvVisaDetails.Rows[0].Cells[0].Text != NO_RECORDS_FOUND_MESSAGE)
{
for (int i = 0; i < gvVisaDetails.Rows.Count; i++)
{
objVisaDetails = new BusinessEntities.VisaDetails();
Label VisaId = (Label)gvVisaDetails.Rows[i].FindControl(VISAID);
Label Mode = (Label)gvVisaDetails.Rows[i].FindControl(MODE);
objVisaDetails.VisaId = int.Parse(VisaId.Text);
objVisaDetails.EMPId = int.Parse(EMPId.Value);
objVisaDetails.CountryName = gvVisaDetails.Rows[i].Cells[0].Text;
objVisaDetails.VisaType = gvVisaDetails.Rows[i].Cells[1].Text;
objVisaDetails.ExpiryDate = Convert.ToDateTime(gvVisaDetails.Rows[i].Cells[2].Text);
objVisaDetails.Mode = int.Parse(Mode.Text);
objSaveVisaDetailsCollection.Add(objVisaDetails);
}
}
BusinessEntities.RaveHRCollection objDeleteVisaDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[VISADETAILSDELETE];
if (objDeleteVisaDetailsCollection != null)
{
BusinessEntities.VisaDetails obj = null;
for (int i = 0; i < objDeleteVisaDetailsCollection.Count; i++)
{
objVisaDetails = new BusinessEntities.VisaDetails();
obj = (BusinessEntities.VisaDetails)objDeleteVisaDetailsCollection.Item(i);
objVisaDetails.VisaId = obj.VisaId;
objVisaDetails.EMPId = obj.EMPId;
objVisaDetails.CountryName = obj.CountryName;
objVisaDetails.VisaType = obj.VisaType;
objVisaDetails.ExpiryDate = obj.ExpiryDate;
objVisaDetails.Mode = obj.Mode;
objSaveVisaDetailsCollection.Add(objVisaDetails);
}
}
}
else
{
//delete visa details if exists.
objVisaDetailsBAL = new Rave.HR.BusinessLayer.Employee.VisaDetails();
objVisaDetailsBAL.DeleteVisaDetailsByEmpId(employeeID);
}
}
else
{
employee.PassportNo = string.Empty;
employee.PassportIssuePlace = string.Empty;
employee.PassportIssueDate = DateTime.MinValue;
employee.PassportExpireDate = DateTime.MinValue;
//delete visa details if exists.
objVisaDetailsBAL = new Rave.HR.BusinessLayer.Employee.VisaDetails();
objVisaDetailsBAL.DeleteVisaDetailsByEmpId(employeeID);
}
Boolean Flag = false;
objEmployeeBAL.UpdateEmployee(employee, Flag);
objVisaDetailsBAL.Manipulation(objSaveVisaDetailsCollection);
if (ViewState.Count > 0)
{
ViewState.Clear();
}
//Refresh the grip after saving
if (EMPId.Value != string.Empty)
{
int empID = Convert.ToInt32(EMPId.Value);
//Refresh the grip after saving
this.PopulateGrid(empID);
}
lblMessage.Text = "Passport details saved successfully.";
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnSave_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
Rave.HR.BusinessLayer.Employee.ProjectDetails objProjectDetailsBAL;
BusinessEntities.ProjectDetails objProjectDetails;
BusinessEntities.RaveHRCollection objSaveProjectDetailsCollection = new BusinessEntities.RaveHRCollection();
try
{
objProjectDetailsBAL = new Rave.HR.BusinessLayer.Employee.ProjectDetails();
if (gvProjectDetails.Rows[0].Cells[0].Text != NO_RECORDS_FOUND_MESSAGE)
{
for (int i = 0; i < gvProjectDetails.Rows.Count; i++)
{
objProjectDetails = new BusinessEntities.ProjectDetails();
Label ProjectId = (Label)gvProjectDetails.Rows[i].FindControl(PROJECTID);
Label Mode = (Label)gvProjectDetails.Rows[i].FindControl(MODE);
objProjectDetails.ProjectId = int.Parse(ProjectId.Text);
objProjectDetails.EMPId = int.Parse(EMPId.Value);
objProjectDetails.Organisation = gvProjectDetails.Rows[i].Cells[2].Text;
objProjectDetails.ProjectName = gvProjectDetails.Rows[i].Cells[1].Text;
objProjectDetails.ProjectLocation = gvProjectDetails.Rows[i].Cells[3].Text;
objProjectDetails.ClientName = gvProjectDetails.Rows[i].Cells[4].Text;
objProjectDetails.ProjectSize = int.Parse(gvProjectDetails.Rows[i].Cells[5].Text);
objProjectDetails.OnsiteDuration = gvProjectDetails.Rows[i].Cells[6].Text;
objProjectDetails.Role = gvProjectDetails.Rows[i].Cells[7].Text;
objProjectDetails.Description = gvProjectDetails.Rows[i].Cells[8].Text;
objProjectDetails.Resposibility = gvProjectDetails.Rows[i].Cells[9].Text;
objProjectDetails.Mode = int.Parse(Mode.Text);
Label LocationId = (Label)gvProjectDetails.Rows[i].FindControl(ProjectLocationId);
objProjectDetails.LocationId = Convert.ToInt32(LocationId.Text);
Label ProjectDoneID = (Label)gvProjectDetails.Rows[i].FindControl(ProjectDoneStatus);
objProjectDetails.ProjectDone = Convert.ToInt32(ProjectDoneID.Text);
objSaveProjectDetailsCollection.Add(objProjectDetails);
}
}
BusinessEntities.RaveHRCollection objDeleteProjectDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[PROJECTDETAILSDELETE];
if (objDeleteProjectDetailsCollection != null)
{
BusinessEntities.ProjectDetails obj = null;
for (int i = 0; i < objDeleteProjectDetailsCollection.Count; i++)
{
objProjectDetails = new BusinessEntities.ProjectDetails();
obj = (BusinessEntities.ProjectDetails)objDeleteProjectDetailsCollection.Item(i);
objProjectDetails.ProjectId = obj.ProjectId;
objProjectDetails.EMPId = obj.EMPId;
objProjectDetails.ProjectName = obj.ProjectName;
objProjectDetails.Organisation = obj.Organisation;
objProjectDetails.ClientName = obj.ClientName;
objProjectDetails.ProjectSize = obj.ProjectSize;
objProjectDetails.Role = obj.Role;
objProjectDetails.ProjectLocation = obj.ProjectLocation;
objProjectDetails.OnsiteDuration = obj.OnsiteDuration;
objProjectDetails.Description = obj.Description;
objProjectDetails.Resposibility = obj.Resposibility;
objProjectDetails.ProjectSize = obj.ProjectSize;
objProjectDetails.Mode = obj.Mode;
objProjectDetails.LocationId = objProjectDetails.LocationId;
objProjectDetails.ProjectDone = obj.ProjectDone;
objProjectDetails.ProjectDoneName = obj.ProjectDoneName;
objSaveProjectDetailsCollection.Add(objProjectDetails);
}
}
objProjectDetailsBAL.Manipulation(objSaveProjectDetailsCollection);
if (ViewState.Count > 0)
{
ViewState.Clear();
}
if (EMPId.Value != string.Empty)
{
int empID = Convert.ToInt32(EMPId.Value);
//Refresh the grip after saving
this.PopulateGrid(empID);
}
if (gvProjectDetails.Rows.Count == 0)
{
btnSave.Visible = false;
}
lblMessage.Text = "Project details saved successfully.";
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnSave_Click", EventIDConstants.RAVE_HR_EMPLOYEE_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
Rave.HR.BusinessLayer.Employee.QualificationDetails objQualificationDetailsBAL;
BusinessEntities.QualificationDetails objQualificationDetails;
BusinessEntities.RaveHRCollection objSaveQualificationDetailsCollection = new BusinessEntities.RaveHRCollection();
try
{
objQualificationDetailsBAL = new Rave.HR.BusinessLayer.Employee.QualificationDetails();
if (gvQualification.Rows[0].Cells[0].Text != NO_RECORDS_FOUND_MESSAGE)
{
for (int i = 0; i < gvQualification.Rows.Count; i++)
{
objQualificationDetails = new BusinessEntities.QualificationDetails();
Label QualificationValue = (Label)gvQualification.Rows[i].FindControl(QUALIFICATION);
Label QualificationId = (Label)gvQualification.Rows[i].FindControl(QUALIFICATIONID);
Label Mode = (Label)gvQualification.Rows[i].FindControl(MODE);
objQualificationDetails.QualificationId = int.Parse(QualificationId.Text);
objQualificationDetails.EMPId = int.Parse(EMPId.Value);
objQualificationDetails.QualificationName = gvQualification.Rows[i].Cells[0].Text;
objQualificationDetails.UniversityName = gvQualification.Rows[i].Cells[1].Text;
objQualificationDetails.InstituteName = gvQualification.Rows[i].Cells[2].Text;
objQualificationDetails.PassingYear = gvQualification.Rows[i].Cells[3].Text;
objQualificationDetails.GPA = float.Parse(gvQualification.Rows[i].Cells[4].Text);
objQualificationDetails.Outof = float.Parse(gvQualification.Rows[i].Cells[5].Text);
objQualificationDetails.Percentage = float.Parse(gvQualification.Rows[i].Cells[6].Text);
objQualificationDetails.Mode = int.Parse(Mode.Text);
objQualificationDetails.Qualification = int.Parse(QualificationValue.Text);
objSaveQualificationDetailsCollection.Add(objQualificationDetails);
}
}
BusinessEntities.RaveHRCollection objDeleteQualificationDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[QUALIFICATIONDETAILSDELETE];
if (objDeleteQualificationDetailsCollection != null)
{
BusinessEntities.QualificationDetails obj = null;
for (int i = 0; i < objDeleteQualificationDetailsCollection.Count; i++)
{
objQualificationDetails = new BusinessEntities.QualificationDetails();
obj = (BusinessEntities.QualificationDetails)objDeleteQualificationDetailsCollection.Item(i);
objQualificationDetails.QualificationId = obj.QualificationId;
objQualificationDetails.EMPId = obj.EMPId;
objQualificationDetails.QualificationName = obj.QualificationName;
objQualificationDetails.UniversityName = obj.UniversityName;
objQualificationDetails.InstituteName = obj.InstituteName;
objQualificationDetails.PassingYear = obj.PassingYear;
objQualificationDetails.GPA = obj.GPA;
objQualificationDetails.Outof = obj.Outof;
objQualificationDetails.Percentage = obj.Percentage;
objQualificationDetails.Mode = obj.Mode;
objQualificationDetails.Qualification = obj.Qualification;
objSaveQualificationDetailsCollection.Add(objQualificationDetails);
}
}
objQualificationDetailsBAL.Manipulation(objSaveQualificationDetailsCollection);
if (ViewState.Count > 0)
{
ViewState.Clear();
}
if (EMPId.Value != string.Empty)
{
int empID = Convert.ToInt32(EMPId.Value);
//Refresh the grip after saving
this.PopulateGrid(empID);
}
if (gvQualification.Rows[0].Cells[0].Text == NO_RECORDS_FOUND_MESSAGE)
{
btnSave.Visible = false;
}
lblMessage.Text = "Qualification details saved successfully.";
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnSave_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
/// <summary>
/// Handles the Click event of the btnSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnSave_Click(object sender, EventArgs e)
{
Rave.HR.BusinessLayer.Employee.SkillsDetails objSkillsDetailsBAL;
Rave.HR.BusinessLayer.Employee.Employee objEmployeeSkillsBAL;
BusinessEntities.SkillsDetails objSkillsDetails;
BusinessEntities.RaveHRCollection objSaveSkillsDetailsCollection = new BusinessEntities.RaveHRCollection();
try
{
objSkillsDetailsBAL = new Rave.HR.BusinessLayer.Employee.SkillsDetails();
objEmployeeSkillsBAL = new Rave.HR.BusinessLayer.Employee.Employee();
if (gvSkills.Rows[0].Cells[0].Text != NO_RECORDS_FOUND_MESSAGE)
{
for (int i = 0; i < gvSkills.Rows.Count; i++)
{
objSkillsDetails = new BusinessEntities.SkillsDetails();
Label SkillValue = (Label)gvSkills.Rows[i].FindControl(SKILL);
Label ProficiencyValue = (Label)gvSkills.Rows[i].FindControl(PROFICIENCY);
Label SkillId = (Label)gvSkills.Rows[i].FindControl(SKILLID);
Label Mode = (Label)gvSkills.Rows[i].FindControl(MODE);
objSkillsDetails.SkillsId = int.Parse(SkillId.Text);
objSkillsDetails.EMPId = int.Parse(EMPId.Value);
objSkillsDetails.SkillName = gvSkills.Rows[i].Cells[0].Text;
objSkillsDetails.Experience = gvSkills.Rows[i].Cells[1].Text;
objSkillsDetails.ProficiencyLevel = gvSkills.Rows[i].Cells[2].Text;
objSkillsDetails.LastUsedDate = Convert.ToDateTime(gvSkills.Rows[i].Cells[3].Text);
objSkillsDetails.Mode = int.Parse(Mode.Text);
objSkillsDetails.Skill = int.Parse(SkillValue.Text);
objSkillsDetails.Proficiency = int.Parse(ProficiencyValue.Text);
objSaveSkillsDetailsCollection.Add(objSkillsDetails);
}
}
BusinessEntities.RaveHRCollection objDeleteSkillsDetailsCollection = (BusinessEntities.RaveHRCollection)ViewState[SKILLDETAILSDELETE];
if (objDeleteSkillsDetailsCollection != null)
{
BusinessEntities.SkillsDetails obj = null;
for (int i = 0; i < objDeleteSkillsDetailsCollection.Count; i++)
{
objSkillsDetails = new BusinessEntities.SkillsDetails();
obj = (BusinessEntities.SkillsDetails)objDeleteSkillsDetailsCollection.Item(i);
objSkillsDetails.SkillsId = obj.SkillsId;
objSkillsDetails.EMPId = obj.EMPId;
objSkillsDetails.Skill = obj.Skill;
objSkillsDetails.Experience = obj.Experience;
objSkillsDetails.Proficiency = obj.Proficiency;
objSkillsDetails.Mode = obj.Mode;
objSkillsDetails.Skill = obj.Skill;
objSkillsDetails.Proficiency = obj.Proficiency;
objSaveSkillsDetailsCollection.Add(objSkillsDetails);
}
}
objSkillsDetailsBAL.Manipulation(objSaveSkillsDetailsCollection);
if (ViewState.Count > 0)
{
ViewState.Clear();
}
if (EMPId.Value != string.Empty)
{
int empID = Convert.ToInt32(EMPId.Value);
//Refresh the grip after saving
this.PopulateGrid(empID);
}
if (gvSkills.Rows.Count == 0)
{
btnSave.Visible = false;
}
objEmployeeSkillsBAL.SendMailApprovalOfSkillsRating(employee);
lblMessage.Text = "Skills details saved successfully.";
}
catch (RaveHRException ex)
{
LogErrorMessage(ex);
}
catch (Exception ex)
{
RaveHRException objEx = new RaveHRException(ex.Message, ex, Sources.PresentationLayer, CLASS_NAME, "btnSave_Click", EventIDConstants.RAVE_HR_PROJECTS_PRESENTATION_LAYER);
LogErrorMessage(objEx);
}
}
