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"; } }