protected void odsHRMemberLeaveAccount_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression("HRMemberLeaveAccount." + HRMemberLeaveAccountEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
e.InputParameters["filterExpression"] = fe;
}
protected void odsHRAdditonalInformation_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(HRAdditonalInformationEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
e.InputParameters["filterExpression"] = fe;
}
private void GetResumeReport()
{
hypResumeReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_RESUME_REPORT, UrlConstants.OVERVIEW_EMPLOYEE_ID, OverviewEmployeeID.ToString()).ToString();
hypResumeReport.Target = "_blank";
}
protected void afuFiles_UploadedComplete(object sender, AsyncFileUploadEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeePhotoEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
IList <HREmployeePhotoEntity> lstmemberImageEntity = FCCHREmployeePhoto.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
HREmployeePhotoEntity memberImageEntity = new HREmployeePhotoEntity();
Boolean isSaveFlag = true;
if (lstmemberImageEntity != null && lstmemberImageEntity.Count > 0)
{
isSaveFlag = false;
}
memberImageEntity.EmployeeID = this.OverviewEmployeeID;
memberImageEntity.OriginalFileName = Path.GetFileName(e.FileName);
memberImageEntity.CurrentFileName = Guid.NewGuid().ToString() + Path.GetExtension(e.FileName);
memberImageEntity.FileType = "";
memberImageEntity.Extension = Path.GetExtension(e.FileName);
memberImageEntity.Path = FileUploadConstants.HR.Employee + memberImageEntity.CurrentFileName;
memberImageEntity.Remarks = String.Empty;
memberImageEntity.IsCurrent = true;
Int64 result = -1;
if (isSaveFlag)
{
result = FCCHREmployeePhoto.GetFacadeCreate().Add(memberImageEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
result = FCCHREmployeePhoto.GetFacadeCreate().Update(memberImageEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
MiscUtil.ShowMessage(lblMessage, "Image Uploaded Successfully.", false);
BindMemberImageList();
}
// file upload
afuFiles.SaveAs(Server.MapPath(memberImageEntity.Path));
//LoadFileListGried
BindMemberImageList();
}
protected void odsHREmployeeSalaryInfo_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSalaryInfoEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.LikeWithBothMath);
e.InputParameters["filterExpression"] = fe;
}
protected void odsLeaveApplicationChecking_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeLeaveApplication." + HREmployeeLeaveApplicationEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
if (chbxFilter.Checked)
{
if (txtRequestStartDate.Text.IsNotNullOrEmpty() || txtRequestEndDate.Text.IsNotNullOrEmpty())
{
String fe2 = "(RequestStartDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and RequestEndDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "' OR RequestEndDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and RequestStartDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "')";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe2, SQLJoinType.AND, fe);
}
else
{
this.messageDetails.Text = "Please Select Request Start Date and End Date. First";
this.MPE.Show();
}
}
e.InputParameters["filterExpression"] = fe;
}
private void HavingLeave()
{
String fe_alreadyRequested1 = "(RequestStartDate >= '" + DateTime.Now + "' and RequestEndDate <='" + DateTime.Now + "' OR RequestEndDate >= '" + DateTime.Now + "' and RequestStartDate <='" + DateTime.Now + "')";
String fe_alreadyRequested2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeLeaveApplicationEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
String fe_alreadyRequested = SqlExpressionBuilder.PrepareFilterExpression(fe_alreadyRequested1, SQLJoinType.AND, fe_alreadyRequested2);
IList <HREmployeeLeaveApplicationEntity> lstHREmployeeLeaveApplication = FCCHREmployeeLeaveApplication.GetFacadeCreate().GetIL(null, null, String.Empty, fe_alreadyRequested, DatabaseOperationType.LoadWithFilterExpression);
if (lstHREmployeeLeaveApplication != null && lstHREmployeeLeaveApplication.Count > 0)
{
btnSubmit.Enabled = false;
lblPending.Text = "<font color='green'>You are having leave</font>";
this.messageDetails.Text = lblPending.Text;
this.MPE.Show();
}
}
private Boolean ValidationInput()
{
Boolean flag = true;
#region Check Balance
Decimal?totalLeaveEarned = GetToalLeaveEarned();
Decimal?totalLeaveEnjoyed = GetToalLeaveEnjoyed() + Decimal.Parse(txtTotalLeaveDays.Text);
if (totalLeaveEarned > 0 && totalLeaveEarned <= totalLeaveEnjoyed)
{
//MiscUtil.ShowMessage(lblMessage, "Sorry you do not have sufficient balance to take a leave please ask your HOD for extra leave.", true);
this.messageDetails.Text = "Sorry you do not have sufficient balance to take a leave please ask your HOD for extra leave.";
this.MPE.Show();
flag = false;
}
#endregion
String fe = "SessionStartDate<= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and SessionEndDate>='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "'";
IList <MDSalarySessionEntity> lstMDSalarySession = FCCMDSalarySession.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lstMDSalarySession != null && lstMDSalarySession.Count > 0)
{
ViewState["SalarySessionID"] = lstMDSalarySession[0].SalarySessionID;
}
else
{
//MiscUtil.ShowMessage(lblMessage, "Sorry your Request start and end date is not under any session please choose.", true);
this.messageDetails.Text = "Sorry your Request Start or End Date did not match with our month. May be they are under two different month. So please check the date.";
this.MPE.Show();
flag = false;
}
if (flag)
{
String fe_alreadyRequested1 = "(RequestStartDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and RequestEndDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "' OR RequestEndDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and RequestStartDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "')";
String fe_alreadyRequested2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeLeaveApplicationEntity.FLD_NAME_EmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
String fe_alreadyRequested = SqlExpressionBuilder.PrepareFilterExpression(fe_alreadyRequested1, SQLJoinType.AND, fe_alreadyRequested2);
IList <HREmployeeLeaveApplicationEntity> lstHREmployeeLeaveApplication = FCCHREmployeeLeaveApplication.GetFacadeCreate().GetIL(null, null, String.Empty, fe_alreadyRequested, DatabaseOperationType.LoadWithFilterExpression);
if (lstHREmployeeLeaveApplication != null && lstHREmployeeLeaveApplication.Count > 0)
{
//MiscUtil.ShowMessage(lblMessage, "Sorry You already have leave in this session please take carefully", true);
this.messageDetails.Text = "Sorry You already have leave in this date. Please Check.";
this.MPE.Show();
flag = false;
}
}
return(flag);
}
private void GenerateReport()
{
hypGenerateReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATION_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, (Int64.Parse(ddlEvolutionSessionID.SelectedValue)).ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, OverviewEmployeeID.ToString()).ToString();
hypGenerateReport.Target = "_blank";
}
protected void lvHRSession_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
HRSession_DetailedEntity ent = (HRSession_DetailedEntity)dataItem.DataItem;
HyperLink hypEvoluationReport = (HyperLink)e.Item.FindControl("hypEvoluationReport");
hypEvoluationReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATION_REPORT, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, OverviewEmployeeID.ToString()).ToString();
hypEvoluationReport.Target = "_blank";
}
}
