protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = String.Empty; Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); //String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal); String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, "00", SQLMatchType.Equal); fe = fe_assignToEmployee; if (chbxFilter.Checked) { if (txtRequestStartDate.Text.IsNotNullOrEmpty() || txtRequestEndDate.Text.IsNotNullOrEmpty()) { String fe2 = "OTIssue.AssignedToEmployeeID = " + OverviewEmployeeID + " and ( OTIssue.ExpectedStartDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and OTIssue.ExpectedEndDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "' or OTIssue.ExpectedEndDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and OTIssue.ExpectedStartDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "')"; fe = fe2; } else { this.messageDetails.Text = "Please Select Request Start Date and End Date. First"; this.MPE.Show(); } } //fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee); e.InputParameters["filterExpression"] = fe; }
private HREmployeeNoticeTemplateEntity BuildHREmployeeNoticeTemplateEntity() { HREmployeeNoticeTemplateEntity hREmployeeNoticeTemplateEntity = CurrentHREmployeeNoticeTemplateEntity; if (ddlNoticeTemplateTypeID.Items.Count > 0) { if (ddlNoticeTemplateTypeID.SelectedValue == "0") { } else { hREmployeeNoticeTemplateEntity.NoticeTemplateTypeID = Int64.Parse(ddlNoticeTemplateTypeID.SelectedValue); } } hREmployeeNoticeTemplateEntity.TemplateName = txtTemplateName.Text.Trim(); hREmployeeNoticeTemplateEntity.Text = txtText.Content.Trim(); hREmployeeNoticeTemplateEntity.Remarks = txtRemarks.Text.Trim(); hREmployeeNoticeTemplateEntity.CreateDate = System.DateTime.Now; hREmployeeNoticeTemplateEntity.IP = MiscUtil.GetLocalIP(); hREmployeeNoticeTemplateEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(hREmployeeNoticeTemplateEntity); }
private ACBankAccountDepositEntity BuildACBankAccountDepositEntity() { ACBankAccountDepositEntity aCBankAccountDepositEntity = CurrentACBankAccountDepositEntity; if (txtDepositDate.Text.Trim().IsNotNullOrEmpty()) { aCBankAccountDepositEntity.DepositDate = MiscUtil.ParseToDateTime(txtDepositDate.Text); } if (ddlPaidFromID.Items.Count > 0) { if (ddlPaidFromID.SelectedValue == "0") { } else { aCBankAccountDepositEntity.PaidFromID = Int64.Parse(ddlPaidFromID.SelectedValue); } } if (ddlReferenceID.Items.Count > 0 && ddlReferenceID.SelectedValue != "0") { aCBankAccountDepositEntity.ReferenceID = Int64.Parse(ddlReferenceID.SelectedValue); } else { aCBankAccountDepositEntity.ReferenceID = null; } if (ddlBankAccountID.Items.Count > 0) { if (ddlBankAccountID.SelectedValue == "0") { } else { aCBankAccountDepositEntity.BankAccountID = Int64.Parse(ddlBankAccountID.SelectedValue); } } //if (ddlProjectID.Items.Count > 0) //{ // if (ddlProjectID.SelectedValue == "0") // { // } // else // { // aCBankAccountDepositEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); // } //} aCBankAccountDepositEntity.BankAccountDepositApprovalStatusID = MasterDataConstants.ACMDBankAccountDepositApprovalStatus.INITIATED; aCBankAccountDepositEntity.Reference = txtReference.Text.Trim(); aCBankAccountDepositEntity.Name = txtName.Text.Trim(); aCBankAccountDepositEntity.Memo = txtMemo.Text.Trim(); aCBankAccountDepositEntity.PreparedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(aCBankAccountDepositEntity); }
private PRMMaterialReceiveEntity BuildPRMMaterialReceiveEntity() { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlRequisitionID.Items.Count > 0) { if (ddlRequisitionID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { } else { pRMMaterialReceiveEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } pRMMaterialReceiveEntity.MRRNo = txtMRRNo.Text.Trim(); if (txtMRRDate.Text.Trim().IsNotNullOrEmpty()) { pRMMaterialReceiveEntity.MRRDate = MiscUtil.ParseToDateTime(txtMRRDate.Text); } pRMMaterialReceiveEntity.Remarks = txtRemarks.Text.Trim(); pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID = MasterDataConstants.MDMaterialReceiveApprovalStatus.INITIATED; pRMMaterialReceiveEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(pRMMaterialReceiveEntity); }
protected void btnSave_Click(object sender, EventArgs e) { try { StringBuilder xmlStr = new StringBuilder(); Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); String ip = MiscUtil.GetLocalIP(); Int64 projectID = 0; if (ddlProjectID != null && ddlProjectID.SelectedValue != "0") { projectID = Int64.Parse(ddlProjectID.SelectedValue); } xmlStr.Append("<m>"); foreach (TreeNode tn in treeTask.CheckedNodes) { String subXmlStr = null; subXmlStr = subXmlStr + "<i><a>" + tn.Text + "</a><b>" + employeeID + "</b><c>" + ddlAssignedToEmployeeID.SelectedValue + "</c><d>" + ip + "</d><e>" + CurrentMember.MemberID + "</e><f>" + projectID + "</f></i>"; xmlStr.Append(subXmlStr.ToString()); } xmlStr.Append("</m>"); FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.TaskTemplateInfo); MiscUtil.ShowMessage(lblMessage, "Task Template Item Map Save Successfully.", false); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true); } }
private void PrepareInitialView() { BuildDropDownList(); txtDiscussionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); txtTopics.Text = String.Empty; txtNote.Text = String.Empty; chkIsFollowUpNeeded.Checked = false; chkIsIWillCall.Checked = false; chkIsField1.Checked = false; txtNextAction.Text = String.Empty; txtNextCommunicationDate.Text = System.DateTime.Now.AddDays(7).ToString(UIConstants.SHORT_DATE_FORMAT); if (ddlCommunicateByEmployeeID.Items.Count > 0 && ddlCommunicateByEmployeeID != null) { Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (currentEmployeeID > 0) { ddlCommunicateByEmployeeID.SelectedValue = currentEmployeeID.ToString(); } } btnSubmit.Text = "Add"; btnAddNew.Visible = false; }
private void PrepareInitialView() { BuildDropDownList(); txtStartDate.Text = System.DateTime.Now.AddDays(-7).ToString(UIConstants.SHORT_DATE_FORMAT); txtEndDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); if (this.Page.User.Identity.IsAuthenticated == true) { //if (Roles.IsUserInRole(this.Page.User.Identity.Name, "1.466") == true || // Roles.IsUserInRole(this.Page.User.Identity.Name, "HR") == true || // Roles.IsUserInRole(this.Page.User.Identity.Name, "CRM") == true || // Roles.IsUserInRole(this.Page.User.Identity.Name, "Accounts") == true || // Roles.IsUserInRole(this.Page.User.Identity.Name, "Engineers") == true|| // Roles.IsUserInRole(this.Page.User.Identity.Name, "IS") == true) if (this.Page.User.Identity.Name.Equals("17.466") == true || this.Page.User.Identity.Name.Equals("17.042") == true || this.Page.User.Identity.Name.Equals("17.1127") == true || this.Page.User.Identity.Name.Equals("17.605") == true || this.Page.User.Identity.Name.Equals("17.599") == true || this.Page.User.Identity.Name.Equals("17.1000") == true || this.Page.User.Identity.Name.Equals("17.979") == true || this.Page.User.Identity.Name.Equals("17.687") == true || this.Page.User.Identity.Name.Equals("17.788") == true || this.Page.User.Identity.Name.Equals("17.1116") == true || this.Page.User.Identity.Name.Equals("17.799") == true || this.Page.User.Identity.Name.Equals("17.780") == true) { String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_EvaluationSessionStatusID, MasterDataConstants.MDEvaluationSessionStatus.OPEN.ToString(), SQLMatchType.Equal); IList <HRSessionEntity> lstHRSessionEntity = FCCHRSession.GetFacadeCreate().GetIL(null, null, String.Empty, fe_session, DatabaseOperationType.LoadWithFilterExpression); if (lstHRSessionEntity != null && lstHRSessionEntity.Count > 0) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SupervisorEmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeSupervisorMap." + HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SessionCategoryID, lstHRSessionEntity[0].SessionID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <HREmployeeSupervisorMap_DetailedEntity> lst = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe); if (lst != null && lst.Count > 0) { ddlEmployeeID.Items.Clear(); foreach (HREmployeeSupervisorMap_DetailedEntity ent in lst) { ListItem lstItem = new ListItem(); lstItem.Text = ent.EmployeeCode + " - " + ent.EmployeeFullName + "(" + ent.SessionCategoryName.ToString() + ")"; lstItem.Value = ent.EmployeeID.ToString(); ddlEmployeeID.Items.Add(lstItem); } } ddlEmployeeID.Enabled = true; } } else { ddlEmployeeID.SelectedValue = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(); ddlEmployeeID.Enabled = false; } } }
private void PrepareInitialView() { BuildDropDownList(); BindPRMItemBrandMapList(); txtContactFullName.Text = String.Empty; txtCompanyName.Text = String.Empty; txtDesignation.Text = String.Empty; txtMobileNo.Text = String.Empty; txtMobileNo2.Text = String.Empty; txtLandPhone.Text = String.Empty; txtLandPhoneOffice.Text = String.Empty; txtFaxNumber.Text = String.Empty; txtPresentAddress.Text = String.Empty; txtPresentAddressOffice.Text = String.Empty; txtEmail.Text = String.Empty; txtEmail2.Text = String.Empty; txtDOB.Text = String.Empty; txtNoOfChildren.Text = String.Empty; txtAreaNeededFrom.Text = String.Empty; txtAreaNeededTo.Text = String.Empty; txtParkingNeeded.Text = String.Empty; txtToiletNeeded.Text = String.Empty; txtUnitNeeded.Text = String.Empty; txtRemarks.Text = String.Empty; txtLeadConversionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (currentEmployeeID > 0) { if (ddlLeadGeneratedByEmployeeID.Items.Count > 0 && ddlLeadGeneratedByEmployeeID != null) { ddlLeadGeneratedByEmployeeID.SelectedValue = currentEmployeeID.ToString(); } if (ddlLeadManagedByOneEmployeeID.Items.Count > 0 && ddlLeadManagedByOneEmployeeID != null) { ddlLeadManagedByOneEmployeeID.SelectedValue = currentEmployeeID.ToString(); } if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0 && ddlLeadManagedByTwoEmployeeID != null) { ddlLeadManagedByTwoEmployeeID.SelectedValue = currentEmployeeID.ToString(); } } if (ddlAreaUnitID.Items.Count > 0 && ddlAreaUnitID != null) { ddlAreaUnitID.SelectedValue = "1"; } if (PageAPType == MasterDataConstants.CRMMDBuyerType.EXISTING_BUYER) { pnlEditor.Visible = false; } btnSubmit.Text = "Save and Add New"; btnAddNew.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PrepareValidator(); PrepareInitialView(); PrepareEditView(); hfOverviewEmployeeID.Value = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(); } }
private ACBankAccountTransferEntity BuildACBankAccountTransferEntity() { ACBankAccountTransferEntity aCBankAccountTransferEntity = CurrentACBankAccountTransferEntity; if (ddlFromBankAccountID.Items.Count > 0) { if (ddlFromBankAccountID.SelectedValue == "0") { } else { aCBankAccountTransferEntity.FromBankAccountID = Int64.Parse(ddlFromBankAccountID.SelectedValue); } } if (ddlToBankAccountID.Items.Count > 0) { if (ddlToBankAccountID.SelectedValue == "0") { } else { aCBankAccountTransferEntity.ToBankAccountID = Int64.Parse(ddlToBankAccountID.SelectedValue); } } if (txtTransferDate.Text.Trim().IsNotNullOrEmpty()) { aCBankAccountTransferEntity.TransferDate = MiscUtil.ParseToDateTime(txtTransferDate.Text); } if (!txtAmount.Text.Trim().IsNullOrEmpty()) { aCBankAccountTransferEntity.Amount = Decimal.Parse(txtAmount.Text.Trim()); } if (!txtBankCharge.Text.Trim().IsNullOrEmpty()) { aCBankAccountTransferEntity.BankCharge = Decimal.Parse(txtBankCharge.Text.Trim()); } else { aCBankAccountTransferEntity.BankCharge = null; } aCBankAccountTransferEntity.BankAccountTransferApprovalStatusID = MasterDataConstants.ACMDBankAccountTransferApprovalStatus.INITIATED; aCBankAccountTransferEntity.Memo = txtMemo.Text.Trim(); aCBankAccountTransferEntity.Remarks = txtRemarks.Text.Trim(); aCBankAccountTransferEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(aCBankAccountTransferEntity); }
private HRSessionEntity BuildHRSessionEntity() { HRSessionEntity hRSessionEntity = CurrentHRSessionEntity; if (ddlSessionCategoryID.Items.Count > 0) { if (ddlSessionCategoryID.SelectedValue == "0") { } else { hRSessionEntity.SessionCategoryID = Int64.Parse(ddlSessionCategoryID.SelectedValue); } } hRSessionEntity.SessionName = txtSessionName.Text.Trim(); if (txtStartDate.Text.Trim().IsNotNullOrEmpty()) { hRSessionEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text); } if (txtEndDate.Text.Trim().IsNotNullOrEmpty()) { hRSessionEntity.EndDate = MiscUtil.ParseToDateTime(txtEndDate.Text); } if (txtDeadlineDate.Text.Trim().IsNotNullOrEmpty()) { hRSessionEntity.DeadlineDate = MiscUtil.ParseToDateTime(txtDeadlineDate.Text); } if (ddlEvaluationSessionStatusID.Items.Count > 0) { if (ddlEvaluationSessionStatusID.SelectedValue == "0") { } else { hRSessionEntity.EvaluationSessionStatusID = Int64.Parse(ddlEvaluationSessionStatusID.SelectedValue); } } hRSessionEntity.Remarks = txtRemarks.Text.Trim(); hRSessionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); hRSessionEntity.CreateDate = System.DateTime.Now; hRSessionEntity.IP = MiscUtil.GetLocalIP(); return(hRSessionEntity); }
private void BuildDropDownList() { MiscUtil.PopulateBDTaskTemplate(ddlTaskTemplateID, true); MiscUtil.PopulateHREmployee(ddlAssignedToEmployeeID, false); MiscUtil.PopulateBDProject(ddlProjectID, true); if (ddlAssignedToEmployeeID != null && ddlAssignedToEmployeeID.Items.Count > 0) { Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { ddlAssignedToEmployeeID.SelectedValue = employeeID.ToString(); } } }
private HREmployeeNoticeEntity BuildHREmployeeNoticeEntity() { HREmployeeNoticeEntity hREmployeeNoticeEntity = CurrentHREmployeeNoticeEntity; if (ddlSendToEmployeeID.Items.Count > 0) { if (ddlSendToEmployeeID.SelectedValue == "0") { } else { hREmployeeNoticeEntity.SendToEmployeeID = Int64.Parse(ddlSendToEmployeeID.SelectedValue); } } if (!txtMemo.Text.Trim().IsNullOrEmpty()) { hREmployeeNoticeEntity.Memo = txtMemo.Text.Trim(); } else { hREmployeeNoticeEntity.Memo = null; } hREmployeeNoticeEntity.Text = txtText.Content.Trim(); hREmployeeNoticeEntity.Remarks = txtRemarks.Text.Trim(); if (txtNoticeDate.Text.Trim().IsNotNullOrEmpty()) { hREmployeeNoticeEntity.NoticeDate = MiscUtil.ParseToDateTime(txtNoticeDate.Text); } hREmployeeNoticeEntity.PreparedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); hREmployeeNoticeEntity.PreparedByEmployeeSalaryLevel = null; if (ddlTemplateID.Items.Count > 0) { if (ddlTemplateID.SelectedValue == "0") { } else { hREmployeeNoticeEntity.TemplateID = Int64.Parse(ddlTemplateID.SelectedValue); } } hREmployeeNoticeEntity.ViewCount = 0; return(hREmployeeNoticeEntity); }
private void PrepareInitialView() { BuildDropDownList(); BindLabel(); SubmitButtonEnable(); Int64 employeeID = _CurrentEmployeeEvaluatedID; if (employeeID > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(ResourceEmployee_CustomEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal); IList <ResourceEmployee_CustomEntity> lst = FCCResourceEmployee_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe); if (lst != null && lst.Count > 0) { lblEmployeeName.Text = lst[0].MemberFullName.ToString(); lblEmployeeCode.Text = lst[0].EmployeeCode; lblDepartment.Text = lst[0].DepartmentName; lblDesignation.Text = lst[0].DesignationName; lblConfirmDate.Text = lst[0].ConfirmDate.ToStringDefault(); lblJoinDate.Text = lst[0].JoinDate.ToStringDefault(); lblSessionEvaluatedBy.Text = CurrentMember.FirstName + " " + CurrentMember.MiddleName + " " + CurrentMember.LastName; if (lst[0].EmployeeID == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember)) { lblSessionEvaluatedBy.Text += " (Self)"; } else { lblSessionEvaluatedBy.Text += " (Supervisor)"; } } } String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_SessionID, _CurrentSessionID.ToString(), SQLMatchType.Equal); HRSessionEntity hRSessionEntity = FCCHRSession.GetFacadeCreate().GetByID(_CurrentSessionID); if (hRSessionEntity != null && hRSessionEntity.SessionID > 0) { lblSessionName.Text = hRSessionEntity.SessionName; lblSessionStartDate.Text = hRSessionEntity.StartDate.ToStringDefault(); lblSessionEndDate.Text = hRSessionEntity.EndDate.ToStringDefault(); lblSessionEvaluationType.Text = "N/A"; } }
private void PrepareInitialView() { BuildDropDownList(); txtContactFullName.Text = String.Empty; txtMobileNo.Text = String.Empty; txtLandPhone.Text = String.Empty; txtPresentAddress.Text = String.Empty; txtEmail.Text = String.Empty; txtLandArea1.Text = String.Empty; txtLandArea2.Text = String.Empty; txtPlotNumber.Text = String.Empty; txtPlotAddress.Text = String.Empty; txtPlotMapUrl.Content = String.Empty; txtArea.Text = String.Empty; txtDimension.Text = String.Empty; txtSpecialFeatures.Text = String.Empty; txtStructure.Text = String.Empty; txtRAJUKDetails.Text = String.Empty; txtLeadConversionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (currentEmployeeID > 0) { if (ddlLeadGeneratedByEmployeeID.Items.Count > 0 && ddlLeadGeneratedByEmployeeID != null) { ddlLeadGeneratedByEmployeeID.SelectedValue = currentEmployeeID.ToString(); } if (ddlLeadManagedByOneEmployeeID.Items.Count > 0 && ddlLeadManagedByOneEmployeeID != null) { ddlLeadManagedByOneEmployeeID.SelectedValue = currentEmployeeID.ToString(); } if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0 && ddlLeadManagedByTwoEmployeeID != null) { ddlLeadManagedByTwoEmployeeID.SelectedValue = currentEmployeeID.ToString(); } if (ddlReferredByEmployeeID.Items.Count > 0 && ddlReferredByEmployeeID != null) { ddlReferredByEmployeeID.SelectedValue = currentEmployeeID.ToString(); } } btnSubmit.Text = "Save and Add New"; btnAddNew.Visible = false; }
protected void btnShowReport_Click(object sender, EventArgs e) { String reportContant = ReportConstants.WEEKLY_DTL_INDIVIDUAL_REPORT; String employeeID = String.Empty; if (ddlEmployeeID != null && ddlEmployeeID.SelectedValue != "0") { employeeID = ddlEmployeeID.SelectedValue; } else { employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(); } String NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", reportContant, UrlConstants.OVERVIEW_ISSUE_FROM_DATE, txtStartDate.Text.Trim().ToString(), UrlConstants.OVERVIEW_ISSUE_TO_DATE, txtEndDate.Text.Trim().ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, employeeID).ToString(); Helper.Response.Redirect(NavigationUrl); }
private BDProcessAssignedResourceEntity BuildBDProcessAssignedResourceEntity() { BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity = CurrentBDProcessAssignedResourceEntity; if (ddlProcessCategoryID.Items.Count > 0) { if (ddlProcessCategoryID.SelectedValue == "0") { } else { bDProcessAssignedResourceEntity.ProcessCategoryID = Int64.Parse(ddlProcessCategoryID.SelectedValue); } } bDProcessAssignedResourceEntity.Title = txtTitle.Text.Trim(); bDProcessAssignedResourceEntity.Purposes = txtPurposes.Text.Trim(); bDProcessAssignedResourceEntity.Remarks = txtRemarks.Text.Trim(); if (txtStartDate.Text.Trim().IsNotNullOrEmpty()) { bDProcessAssignedResourceEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text); } else { bDProcessAssignedResourceEntity.StartDate = null; } bDProcessAssignedResourceEntity.CreateDate = System.DateTime.Now; bDProcessAssignedResourceEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (ddlProcessAssignedResourceApprovalStatusID.Items.Count > 0) { if (ddlProcessAssignedResourceApprovalStatusID.SelectedValue == "0") { } else { bDProcessAssignedResourceEntity.ProcessAssignedResourceApprovalStatusID = Int64.Parse(ddlProcessAssignedResourceApprovalStatusID.SelectedValue); } } return(bDProcessAssignedResourceEntity); }
private CMNERPCommentEntity BuildCMNERPCommentEntity() { CMNERPCommentEntity cMNERPCommentEntity = CurrentCMNERPCommentEntity; cMNERPCommentEntity.ProcessCategoryID = PageProcessType; cMNERPCommentEntity.ReferenceID = PageReferenceID; cMNERPCommentEntity.Comment = txtComment.Text.Trim(); cMNERPCommentEntity.CommentDate = System.DateTime.Now; Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { cMNERPCommentEntity.EmployeeID = employeeID; } cMNERPCommentEntity.IP = MiscUtil.GetLocalIP(); return(cMNERPCommentEntity); }
private void PrepareInitialView() { BuildDropDownList(); txtTRFNo.Text = MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED; txtRequestDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT); txtRemarks.Text = String.Empty; if (ddlRequestedByEmployeeID.Items.Count > 0) { Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { ddlRequestedByEmployeeID.SelectedValue = employeeID.ToString(); } } btnSubmit.Text = "Add"; btnAddNew.Visible = false; }
private void PrepareInitialView() { BuildDropDownList(); txtTitle.Text = String.Empty; txtDescription.Text = String.Empty; txtCompletionPercentage.Text = "0"; txtDuration.Text = String.Empty; txtExpectedStartDate.Text = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm"); txtExpectedEndDate.Text = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm"); txtActualStartDate.Text = String.Empty; txtActualEndDate.Text = String.Empty; txtNotifyBeforeMin.Text = String.Empty; txtRemarks.Text = String.Empty; if (ddlSupervisorEmployeeID != null && ddlSupervisorEmployeeID.Items.Count > 0) { Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { ddlSupervisorEmployeeID.SelectedValue = employeeID.ToString(); } } if (Action == "Edit" || Action == "EditDetails") { pnlComments.Visible = true; } else { pnlComments.Visible = false; } pnlEditMode.Visible = false; btnSubmit.Text = "Save"; btnAddNew.Visible = false; }
private CRMSurveyMasterEntity BuildCRMSurveyMasterEntity() { CRMSurveyMasterEntity cRMSurveyMasterEntity = CurrentCRMSurveyMasterEntity; cRMSurveyMasterEntity.Title = txtTitle.Text.Trim(); if (txtStartDate.Text.Trim().IsNotNullOrEmpty()) { cRMSurveyMasterEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text); } if (txtEndDate.Text.Trim().IsNotNullOrEmpty()) { cRMSurveyMasterEntity.EndDate = MiscUtil.ParseToDateTime(txtEndDate.Text); } cRMSurveyMasterEntity.CreateDate = System.DateTime.Now; cRMSurveyMasterEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(cRMSurveyMasterEntity); }
private void SavePRMMaterialReceiveEntity() { if (IsValid) { try { PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity(); #region Requisition String RequisitionNo = String.Empty; if (txtRequisition.Text.IsNotNullOrEmpty()) { RequisitionNo = "BL-" + txtRequisition.Text.ToString(); } Int64 resultRequisition = -1; Int64 resultRequisitionItem = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionNo, RequisitionNo, SQLMatchType.Equal); IList <REQRequisitionEntity> lstRequisition = FCCREQRequisition.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); REQRequisitionItemEntity rEQRequisitionItemEntity = null; if (lstRequisition != null && lstRequisition.Count > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(lstRequisition[0].RequisitionID); pRMMaterialReceiveEntity.RequisitionID = lstRequisition[0].RequisitionID; } else { REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity(); resultRequisition = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); pRMMaterialReceiveEntity.RequisitionID = resultRequisition; if (resultRequisition > 0) { rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(resultRequisition); } } if (rEQRequisitionItemEntity != null) { resultRequisitionItem = FCCREQRequisitionItem.GetFacadeCreate().Add(rEQRequisitionItemEntity, DatabaseOperationType.Add, TransactionRequired.No); } #endregion #region MRR Int64 resultOne = -1; if (pRMMaterialReceiveEntity.IsNew) { resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal); resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } #endregion if (resultOne > 0 && resultRequisitionItem > 0) { #region Material Receive Item Map Int64 resultTwo = -1; PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = BuildPRMMaterialReceiveItemMapEntity(resultOne, resultRequisitionItem); resultTwo = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Add(pRMMaterialReceiveItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No); #endregion try { #region Inventory Int64 _employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); Int64 _projectID = Int64.Parse(ddlProjectID.SelectedValue); INVStoreEntity storeEntity = INVManager.GetDefaultStore(_projectID); Int64 storeID = storeEntity.StoreID; INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeID); Int64 storeUnitID = storeUnitEntity.StoreUnitID; String fe_requisitionItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, resultRequisitionItem.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisitionItem); Int64 _itemID = 0; Decimal _rate = 0; Int64 brandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD; Int64 regionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION; Int64 countryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY; if (lst != null && lst.Count > 0) { _itemID = lst[0].ItemID; brandID = (Int64)lst[0].BrandID; regionID = (Int64)lst[0].RegionID; countryID = (Int64)lst[0].CountryID; _rate = lst[0].Rate; } Boolean invResult = INVManager.AddItemsToStoreUnit(_itemID, brandID, regionID, countryID, "", Int64.Parse(txtReceiveQty.Text.ToString()), MiscUtil.GetLocalIP(), _employeeID, _rate, txtRequisition.Text, ddlWorkOrderID.SelectedItem.Text, resultOne.ToString(), "", Int64.Parse(ddlProjectID.SelectedValue), storeID, storeUnitID); #endregion } catch (Exception ex) { } _MaterialReceiveID = resultOne; PrepareInitialViewSave(); btnAddNew.Visible = true; if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been updated successfully.", false); } } else { if (pRMMaterialReceiveEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Material Receive Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Material Receive Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void SaveWOtoACCPrePayableStatementEntity() { if (IsValid) { try { #region AccPayableStatemenet Detail IList <ACCPrePayableStatementDetailByWorkOrderNo_CustomEntity> lstACCPrePayableStatementDetail_CustomEntity = FCCACCPrePayableStatementDetailByWorkOrderNo_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlWorkOrderID.SelectedValue)); if (lstACCPrePayableStatementDetail_CustomEntity != null && lstACCPrePayableStatementDetail_CustomEntity.Count > 0) { IList <ACCPrePayableStatementDetailEntity> lstACCPrePayableStatementDetail = new List <ACCPrePayableStatementDetailEntity>(); foreach (ACCPrePayableStatementDetailByWorkOrderNo_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetail_CustomEntity) { ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity(); //if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0) //{ // ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail // where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID // // where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID // //&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID != entACCPrePayableStatementDetail_CustomEntity.RequisitionID // select s).FirstOrDefault(); // if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0) // { // //Remove Previous Item // lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail); // entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo; // //Add New Edited Item. // lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail); // continue; // } //} Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0, billAmount = 0; entACCPrePayableStatementDetail.PrePayableStatementID = ACCPrePayableStatementID; if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty()) { entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim(); } else { entACCPrePayableStatementDetail.WorkOrderNo = null; } if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue) { workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString()); entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount; } else { entACCPrePayableStatementDetail.WorkOrderAmount = null; } if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0) { entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString()); } else { entACCPrePayableStatementDetail.WorkOrderID = null; } if (entACCPrePayableStatementDetail_CustomEntity.StartDate != null) { entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate; } else { entACCPrePayableStatementDetail.WorkOrderDate = null; } Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount); //Decimal netPayableConsideringBillSecurity = (billAmount - paidAmount - securityMoney - tDSAmount); //need to discuss with Rayan vaiya. To get value from formula or anywhere else??? Decimal netPayableConsideringBillSecurity = payableAgainstWO; entACCPrePayableStatementDetail.PaidAmount = paidAmount; entACCPrePayableStatementDetail.SecurityMoney = securityMoney; entACCPrePayableStatementDetail.TDSAmount = tDSAmount; entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO; entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity; entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now; entACCPrePayableStatementDetail.ApprovedBillAmount = 0; entACCPrePayableStatementDetail.PartyReconcile = false; Int64 requisitionID = 0; Int64 projectID = 0; String projectCode = null; String requisitionNo = null; DateTime requisitionDate = System.DateTime.Now; if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0) { String fe_WOItemMap = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMWorkOrderItemMapEntity> lstWOItemMap = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_WOItemMap, DatabaseOperationType.LoadWithFilterExpression); if (lstWOItemMap != null && lstWOItemMap.Count > 0) { var distinctTypeIDs = lstWOItemMap.Select(x => x.RequisitionID).Distinct(); foreach (var ent in distinctTypeIDs) { String fe_requisition = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_RequisitionID, ent.ToString(), SQLMatchType.Equal); IList <REQRequisition_DetailedEntity> lstReqRequisition_detailed = FCCREQRequisition_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisition); if (lstReqRequisition_detailed != null && lstReqRequisition_detailed.Count > 0) { requisitionID = lstReqRequisition_detailed[0].RequisitionID; projectCode = lstReqRequisition_detailed[0].ProjectCode; requisitionNo += lstReqRequisition_detailed[0].RequisitionNo + " "; requisitionDate = lstReqRequisition_detailed[0].RequisitionDate; projectID = lstReqRequisition_detailed[0].ProjectID; } } } } entACCPrePayableStatementDetail.RequisitionID = requisitionID; entACCPrePayableStatementDetail.RequisitionNo = requisitionNo; entACCPrePayableStatementDetail.RequisitionDate = requisitionDate; entACCPrePayableStatementDetail.ProjectID = projectID; entACCPrePayableStatementDetail.ProjectCode = projectCode; //REQRequisitionEntity reqRequisitionEntity = null; //if (entACCPrePayableStatementDetail_CustomEntity.RequisitionID > 0) //{ // entACCPrePayableStatementDetail.RequisitionID = entACCPrePayableStatementDetail_CustomEntity.RequisitionID; // reqRequisitionEntity = FCCREQRequisition.GetFacadeCreate().GetByID(entACCPrePayableStatementDetail_CustomEntity.RequisitionID); // if (reqRequisitionEntity != null) // { // entACCPrePayableStatementDetail.RequisitionNo = reqRequisitionEntity.RequisitionNo; ; // entACCPrePayableStatementDetail.RequisitionDate = reqRequisitionEntity.RequisitionDate; // entACCPrePayableStatementDetail.ProjectID = reqRequisitionEntity.ProjectID; // Project ID should come from the first requisition Project ID. // } //} //else //{ // entACCPrePayableStatementDetail.RequisitionID = null; //} //if (entACCPrePayableStatementDetail_CustomEntity.RequisitionNo.IsNotNullOrEmpty()) //{ // entACCPrePayableStatementDetail.RequisitionNo = entACCPrePayableStatementDetail_CustomEntity.RequisitionNo; //} //else //{ // entACCPrePayableStatementDetail.RequisitionNo = null; //} //if (entACCPrePayableStatementDetail_CustomEntity.RequisitionDate.HasValue) //{ // entACCPrePayableStatementDetail.RequisitionDate = entACCPrePayableStatementDetail_CustomEntity.RequisitionDate; //} //else //{ // entACCPrePayableStatementDetail.RequisitionDate = null; //} //entACCPrePayableStatementDetail.ProjectID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.ProjectID.ToString()); entACCPrePayableStatementDetail.BillID = null; entACCPrePayableStatementDetail.BillDate = null; entACCPrePayableStatementDetail.BillNo = null; entACCPrePayableStatementDetail.VendorCategoryID = MasterDataConstants.MDVendorCategory.VENDOR; entACCPrePayableStatementDetail.FromVendorID = entACCPrePayableStatementDetail_CustomEntity.SupplierID; entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); entACCPrePayableStatementDetail.Ref = null; entACCPrePayableStatementDetail.DueDate = DateTime.Now; entACCPrePayableStatementDetail.PlannedDate = null; entACCPrePayableStatementDetail.Remarks = null; entACCPrePayableStatementDetail.AdditionalRemarks = null; entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT; entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED; entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR; entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS; entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL; entACCPrePayableStatementDetail.IsRemoved = false; entACCPrePayableStatementDetail.IsLocked = false; lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail); break; } #region Insert To Payable Detail if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0) { foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail) { FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } #endregion MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false); } #endregion _PrePayableStatementID = 0; _ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity(); PrepareInitialView(); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void SaveBilltoACCPrePayableStatementEntity() { if (IsValid) { try { #region AccPayableStatemenet Detail IList <ACCPrePayableStatementDetailByBill_CustomEntity> lstACCPrePayableStatementDetail_CustomEntity = FCCACCPrePayableStatementDetailByBill_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlBillID.SelectedValue)); if (lstACCPrePayableStatementDetail_CustomEntity != null && lstACCPrePayableStatementDetail_CustomEntity.Count > 0) { IList <ACCPrePayableStatementDetailEntity> lstACCPrePayableStatementDetail = new List <ACCPrePayableStatementDetailEntity>(); foreach (ACCPrePayableStatementDetailByBill_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetail_CustomEntity) { ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity(); if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0) { ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID // where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID //&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID != entACCPrePayableStatementDetail_CustomEntity.RequisitionID select s).FirstOrDefault(); if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0) { //Remove Previous Item lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail); entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo; //Add New Edited Item. lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail); continue; } } Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0; entACCPrePayableStatementDetail.PrePayableStatementID = ACCPrePayableStatementID; if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty()) { entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim(); } else { entACCPrePayableStatementDetail.WorkOrderNo = null; } if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue) { workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString()); entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount; } else { entACCPrePayableStatementDetail.WorkOrderAmount = null; } if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0) { entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString()); } else { entACCPrePayableStatementDetail.WorkOrderID = null; } if (entACCPrePayableStatementDetail_CustomEntity.StartDate.HasValue) { entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate; } else { entACCPrePayableStatementDetail.WorkOrderDate = null; } Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount); Decimal netPayableConsideringBillSecurity = (payableAgainstWO - paidAmount - securityMoney - tDSAmount); entACCPrePayableStatementDetail.PaidAmount = paidAmount; entACCPrePayableStatementDetail.SecurityMoney = securityMoney; entACCPrePayableStatementDetail.TDSAmount = tDSAmount; entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO; entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity; entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now; if (entACCPrePayableStatementDetail_CustomEntity.BillAmount.HasValue) { entACCPrePayableStatementDetail.ApprovedBillAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.BillAmount.ToString()); } else { entACCPrePayableStatementDetail.ApprovedBillAmount = null; } entACCPrePayableStatementDetail.PartyReconcile = false; if (entACCPrePayableStatementDetail_CustomEntity.RequisitionID > 0) { entACCPrePayableStatementDetail.RequisitionID = entACCPrePayableStatementDetail_CustomEntity.RequisitionID; } else { entACCPrePayableStatementDetail.RequisitionID = null; } if (entACCPrePayableStatementDetail_CustomEntity.RequisitionNo.IsNotNullOrEmpty()) { entACCPrePayableStatementDetail.RequisitionNo = entACCPrePayableStatementDetail_CustomEntity.RequisitionNo; } else { entACCPrePayableStatementDetail.RequisitionNo = null; } if (entACCPrePayableStatementDetail_CustomEntity.RequisitionDate.HasValue) { entACCPrePayableStatementDetail.RequisitionDate = entACCPrePayableStatementDetail_CustomEntity.RequisitionDate; } else { entACCPrePayableStatementDetail.RequisitionDate = null; } entACCPrePayableStatementDetail.ProjectID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.ProjectID.ToString()); entACCPrePayableStatementDetail.BillID = entACCPrePayableStatementDetail_CustomEntity.BillID; entACCPrePayableStatementDetail.BillDate = entACCPrePayableStatementDetail_CustomEntity.billlDate; entACCPrePayableStatementDetail.BillNo = entACCPrePayableStatementDetail_CustomEntity.BillNo; entACCPrePayableStatementDetail.VendorCategoryID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.VendorCategory.ToString()); entACCPrePayableStatementDetail.FromVendorID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.Vendor.ToString()); entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); entACCPrePayableStatementDetail.Ref = null; entACCPrePayableStatementDetail.DueDate = DateTime.Now; entACCPrePayableStatementDetail.PlannedDate = null; entACCPrePayableStatementDetail.Remarks = null; entACCPrePayableStatementDetail.AdditionalRemarks = null; entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT; entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED; entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR; entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS; entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL; entACCPrePayableStatementDetail.IsRemoved = false; entACCPrePayableStatementDetail.IsLocked = false; lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail); } #region Insert To Payable Detail if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0) { foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail) { FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No); } } #endregion } #endregion _PrePayableStatementID = 0; _ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity(); PrepareInitialView(); MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false); } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void btnForward_Click(object sender, EventArgs e) { if (chbxAutoForwardTo.Checked) { APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.BILL, CMBillID); IList <APMemberFeedbackEntity> feedbackList = APRobot.GetAllMemberFeedbacks(aPApprovalProcessEntity.APApprovalProcessID); IList <APMemberFeedbackEntity> ordered_list = feedbackList.OrderBy(x => x.SequenceNo).ToList(); APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(Int64.Parse(ddlForwardTo.SelectedValue)); var existsInfo = (from s in ordered_list where s.EmployeeID.ToString() == aPPanelForwardMemberEntity.EmployeeID.ToString() select s); if (existsInfo != null && existsInfo.Count() > 0) { MiscUtil.ShowMessage(lblMessage, "Member Already Exists in the Approval Panel", true); return; } APMemberFeedbackEntity currentEmployeeInfo = (from r in ordered_list where r.EmployeeID.ToString() == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString() select r).FirstOrDefault(); if (currentEmployeeInfo != null) { ordered_list = (from m in ordered_list where m.SequenceNo > currentEmployeeInfo.SequenceNo select m).ToList(); APMemberFeedbackEntity aPMemberFeedbackEntity = new APMemberFeedbackEntity(); aPMemberFeedbackEntity.APApprovalProcessID = aPApprovalProcessEntity.APApprovalProcessID; aPMemberFeedbackEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID; aPMemberFeedbackEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID; aPMemberFeedbackEntity.SequenceNo = currentEmployeeInfo.SequenceNo + 1; aPMemberFeedbackEntity.APFeedbackID = MasterDataConstants.APFeedback.NOT_YET_REQUESTED; aPMemberFeedbackEntity.FeedbackRequestDate = DateTime.Now; aPMemberFeedbackEntity.FeedbackLastResponseDate = null; aPMemberFeedbackEntity.FeedbackSubmitDate = null; aPMemberFeedbackEntity.IsProxyEmployeeEnabled = false; aPMemberFeedbackEntity.ProxyEmployeeID = null; Int64 aPMemberFeedbackID = FCCAPMemberFeedback.GetFacadeCreate().Add(aPMemberFeedbackEntity, DatabaseOperationType.Add, TransactionRequired.No); foreach (APMemberFeedbackEntity ent in ordered_list) { String fe = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), SQLMatchType.Equal); ent.SequenceNo += 1; FCCAPMemberFeedback.GetFacadeCreate().Update(ent, fe, DatabaseOperationType.Update, TransactionRequired.No); } APRobot.UpdateApprovalProcessFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.APPROVED, MasterDataConstants.APType.BILL, CMBillID); String remarks = txtRemarks.Text.Trim(); if (remarks.IsNullOrEmpty()) { remarks = "Approved"; } remarks = AddProxyMemberInfo(remarks); APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks); EnableDisableApprovalButtons(); MiscUtil.ShowMessage(lblMessage, "You have Approved Successfully", UIConstants.MessageType.GREEN); PrepareInitialView(); BindList(); RedirectPageToPendingList(); } } //Previous Code else { if (ddlRejectTo.Items.Count > 0) { APRobot.UpdateMemberFeedbackFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.FORWARDED); APRobot.UpdateMemberFeedbackLastResponseDate(APMemberFeedbackID, DateTime.Now); String remarks = txtRemarks.Text.Trim(); if (remarks.IsNullOrEmpty()) { remarks = "Forwarded"; } remarks = AddProxyMemberInfo(remarks); Int64 aPMemberFeedbackRemarksID = APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks); Int64 aPPanelForwardMemberID = Int64.Parse(ddlForwardTo.SelectedValue); APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(aPPanelForwardMemberID); APForwardInfoEntity aPForwardInfoEntity = new APForwardInfoEntity(); aPForwardInfoEntity.APMemberFeedbackID = APMemberFeedbackID; aPForwardInfoEntity.APApprovalProcessID = APApprovalProcessID; aPForwardInfoEntity.APMemberFeedbackRemarksID = aPMemberFeedbackRemarksID; aPForwardInfoEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID; aPForwardInfoEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID; aPForwardInfoEntity.CommentRequestDate = DateTime.Now; aPForwardInfoEntity.CommentSubmitDate = null; aPForwardInfoEntity.APMemberComment = txtForwardRemarks.Text.Trim(); aPForwardInfoEntity.APForwardMemberComment = String.Empty; FCCAPForwardInfo.GetFacadeCreate().Add(aPForwardInfoEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "You have forwarded the thread successfully", UIConstants.MessageType.GREEN); PrepareInitialView(); BindList(); #region Forwarded Mail String MailBody = String.Empty; String Subject = String.Empty; StringBuilder sb = new StringBuilder(); sb.Append("Dear Sir,"); sb.Append("<br/>"); sb.Append("This is a auto generated mail from the ERP."); sb.Append("<br/>"); sb.Append("A Bill Request is Forwarded Request is waiting for your approval"); sb.Append("<br/>"); sb.Append("<br/>"); sb.Append("-"); sb.Append("<br/>"); sb.Append("Thanks"); sb.Append("<br/>"); sb.Append("ERP System"); MailBody = sb.ToString(); Subject = "ERP, Bill, Forwarded"; MailBody = @"Please note that a Bill is Forwarded.-Thanks ERP System"; HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(aPForwardInfoEntity.EmployeeID); if (_hREmployeeEntity != null) { String[] sendToMail = new String[] { _hREmployeeEntity.PrimaryEmail }; MiscUtil.SendMail(sendToMail, Subject, MailBody); } #endregion //RedirectPageToForwardList(); } else { MiscUtil.ShowMessage(lblMessage, "Failed to forward", UIConstants.MessageType.RED); } } }
private CRMBuyerBasicInfoEntity BuildCRMBuyerBasicInfoEntity() { CRMBuyerBasicInfoEntity cRMBuyerBasicInfoEntity = CurrentCRMBuyerBasicInfoEntity; if (ddlBuyerTypeID.Items.Count > 0) { if (ddlBuyerTypeID.SelectedValue == "0") { } else { cRMBuyerBasicInfoEntity.BuyerTypeID = Int64.Parse(ddlBuyerTypeID.SelectedValue); } } cRMBuyerBasicInfoEntity.ContactFullName = txtContactFullName.Text.Trim(); cRMBuyerBasicInfoEntity.CompanyName = txtCompanyName.Text.Trim(); cRMBuyerBasicInfoEntity.Designation = txtDesignation.Text.Trim(); #region Image String ImageUrlpath; if (fuImageUrl.HasFile == true && cRMBuyerBasicInfoEntity.ImageUrl.IsNotNullOrEmpty()) { if (File.Exists(Server.MapPath(cRMBuyerBasicInfoEntity.ImageUrl))) { File.Delete(Server.MapPath(cRMBuyerBasicInfoEntity.ImageUrl)); } ImageUrlpath = FileUploadConstants.CRM.Buyer + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(ImageUrlpath)); cRMBuyerBasicInfoEntity.ImageUrl = ImageUrlpath; } if (cRMBuyerBasicInfoEntity.ImageUrl.IsNotNullOrEmpty() && fuImageUrl.HasFile == false) { cRMBuyerBasicInfoEntity.ImageUrl = cRMBuyerBasicInfoEntity.ImageUrl; } if (fuImageUrl.HasFile == false && cRMBuyerBasicInfoEntity.ImageUrl.IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.ImageUrl = null; } if (fuImageUrl.HasFile == true && cRMBuyerBasicInfoEntity.ImageUrl.IsNullOrEmpty()) { ImageUrlpath = FileUploadConstants.CRM.Buyer + Guid.NewGuid() + fuImageUrl.FileName; fuImageUrl.SaveAs(Server.MapPath(ImageUrlpath)); cRMBuyerBasicInfoEntity.ImageUrl = ImageUrlpath; } #endregion Image if (ddlInterestedProjectCategoryID.Items.Count > 0) { if (ddlInterestedProjectCategoryID.SelectedValue == "0") { } else { cRMBuyerBasicInfoEntity.InterestedProjectCategoryID = Int64.Parse(ddlInterestedProjectCategoryID.SelectedValue); } } cRMBuyerBasicInfoEntity.MobileNo = txtMobileNo.Text.Trim(); cRMBuyerBasicInfoEntity.MobileNo2 = txtMobileNo2.Text.Trim(); cRMBuyerBasicInfoEntity.LandPhone = txtLandPhone.Text.Trim(); cRMBuyerBasicInfoEntity.LandPhoneOffice = txtLandPhoneOffice.Text.Trim(); cRMBuyerBasicInfoEntity.FaxNumber = txtFaxNumber.Text.Trim(); cRMBuyerBasicInfoEntity.PresentAddress = txtPresentAddress.Text.Trim(); cRMBuyerBasicInfoEntity.PresentAddressOffice = txtPresentAddressOffice.Text.Trim(); cRMBuyerBasicInfoEntity.Email = txtEmail.Text.Trim(); cRMBuyerBasicInfoEntity.Email2 = txtEmail2.Text.Trim(); if (txtDOB.Text.Trim().IsNotNullOrEmpty()) { cRMBuyerBasicInfoEntity.DOB = MiscUtil.ParseToDateTime(txtDOB.Text); } else { cRMBuyerBasicInfoEntity.DOB = null; } if (!txtNoOfChildren.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.NoOfChildren = Decimal.Parse(txtNoOfChildren.Text.Trim()); } else { cRMBuyerBasicInfoEntity.NoOfChildren = null; } if (ddlInterestedLandLocationID.Items.Count > 0) { if (ddlInterestedLandLocationID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.InterestedLandLocationID = null; } else { cRMBuyerBasicInfoEntity.InterestedLandLocationID = Int64.Parse(ddlInterestedLandLocationID.SelectedValue); } } if (ddlCityID.Items.Count > 0) { if (ddlCityID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.CityID = null; } else { cRMBuyerBasicInfoEntity.CityID = Int64.Parse(ddlCityID.SelectedValue); } } if (!txtAreaNeededFrom.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.AreaNeededFrom = Decimal.Parse(txtAreaNeededFrom.Text.Trim()); } else { cRMBuyerBasicInfoEntity.AreaNeededFrom = null; } if (!txtAreaNeededTo.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.AreaNeededTo = Decimal.Parse(txtAreaNeededTo.Text.Trim()); } else { cRMBuyerBasicInfoEntity.AreaNeededTo = null; } if (!txtParkingNeeded.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.ParkingNeeded = Decimal.Parse(txtParkingNeeded.Text.Trim()); } else { cRMBuyerBasicInfoEntity.ParkingNeeded = null; } if (ddlAreaUnitID.Items.Count > 0) { if (ddlAreaUnitID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.AreaUnitID = null; } else { cRMBuyerBasicInfoEntity.AreaUnitID = Int64.Parse(ddlAreaUnitID.SelectedValue); } } if (!txtToiletNeeded.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.ToiletNeeded = Decimal.Parse(txtToiletNeeded.Text.Trim()); } else { cRMBuyerBasicInfoEntity.ToiletNeeded = null; } if (!txtUnitNeeded.Text.Trim().IsNullOrEmpty()) { cRMBuyerBasicInfoEntity.UnitNeeded = Decimal.Parse(txtUnitNeeded.Text.Trim()); } else { cRMBuyerBasicInfoEntity.UnitNeeded = null; } if (ddlAdvertiseWayID.Items.Count > 0) { if (ddlAdvertiseWayID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.AdvertiseWayID = null; } else { cRMBuyerBasicInfoEntity.AdvertiseWayID = Int64.Parse(ddlAdvertiseWayID.SelectedValue); } } if (ddlLeadGeneratedByEmployeeID.Items.Count > 0) { if (ddlLeadGeneratedByEmployeeID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.LeadGeneratedByEmployeeID = null; } else { cRMBuyerBasicInfoEntity.LeadGeneratedByEmployeeID = Int64.Parse(ddlLeadGeneratedByEmployeeID.SelectedValue); } } if (ddlLeadManagedByOneEmployeeID.Items.Count > 0) { if (ddlLeadManagedByOneEmployeeID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.LeadManagedByOneEmployeeID = null; } else { cRMBuyerBasicInfoEntity.LeadManagedByOneEmployeeID = Int64.Parse(ddlLeadManagedByOneEmployeeID.SelectedValue); } } if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0) { if (ddlLeadManagedByTwoEmployeeID.SelectedValue == "0") { cRMBuyerBasicInfoEntity.LeadManagedByTwoEmployeeID = null; } else { cRMBuyerBasicInfoEntity.LeadManagedByTwoEmployeeID = Int64.Parse(ddlLeadManagedByTwoEmployeeID.SelectedValue); } } if (txtLeadConversionDate.Text.Trim().IsNotNullOrEmpty()) { cRMBuyerBasicInfoEntity.LeadConversionDate = MiscUtil.ParseToDateTime(txtLeadConversionDate.Text); } else { cRMBuyerBasicInfoEntity.LeadConversionDate = null; } if (ddlProspectForProject.Items.Count > 0) { if (ddlProspectForProject.SelectedValue == "0") { cRMBuyerBasicInfoEntity.ProspectForProject = null; } else { cRMBuyerBasicInfoEntity.ProspectForProject = Int64.Parse(ddlProspectForProject.SelectedValue); } } cRMBuyerBasicInfoEntity.Remarks = txtRemarks.Text.Trim(); Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (currentEmployeeID > 0) { cRMBuyerBasicInfoEntity.CreatedByEmployeeID = currentEmployeeID; } cRMBuyerBasicInfoEntity.IP = MiscUtil.GetLocalIP(); cRMBuyerBasicInfoEntity.CreateDate = System.DateTime.Now; return(cRMBuyerBasicInfoEntity); }
protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = String.Empty; switch (PageAPType) { case MasterDataConstants.IssuePageType.ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Adhoc Issue List"; break; case MasterDataConstants.IssuePageType.PROJECT_ADHOC_ISSUE: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); lblIssueList.Text = "Project Issue List"; break; case MasterDataConstants.IssuePageType.MY_ISSUE_LIST: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal); Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); if (employeeID > 0) { String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, employeeID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee); String fe_resource1 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.EMPLOYEE.ToString(), SQLMatchType.Equal); String fe_resource2 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, employeeID.ToString(), SQLMatchType.Equal); String fe_resource = SqlExpressionBuilder.PrepareFilterExpression(fe_resource1, SQLJoinType.AND, fe_resource2); IList <ResourceEntity> lstResource = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_resource, DatabaseOperationType.LoadWithFilterExpression); if (lstResource != null && lstResource.Count > 0) { String fe_Assigned_Issue = SqlExpressionBuilder.PrepareFilterExpression(OTIssueAssignedResourceEntity.FLD_NAME_ResourceID, lstResource[0].ResourceID.ToString(), SQLMatchType.Equal); IList <OTIssueAssignedResourceEntity> lstIssueAssignedResource = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_Assigned_Issue, DatabaseOperationType.LoadWithFilterExpression); if (lstIssueAssignedResource != null && lstIssueAssignedResource.Count > 0) { String compositeIssueID = String.Empty; foreach (OTIssueAssignedResourceEntity ent in lstIssueAssignedResource) { compositeIssueID += ent.IssueID + ","; } if (compositeIssueID.IsNotNullOrEmpty()) { compositeIssueID = compositeIssueID.Substring(0, compositeIssueID.Length - 1); String fe_issue = "OTIssue.IssueID in(" + compositeIssueID + ")"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_issue); } } } } lblIssueList.Text = "My Issue List"; break; default: fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal); break; } if (chbxFilter.Checked) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.Title", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath); String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDIssuePriority.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); String fe3 = SqlExpressionBuilder.PrepareFilterExpression("MDIssueStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath); Int64 issueID; Int64.TryParse(txtSearchText.Text.Trim().ToString(), out issueID); String fe6 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.IssueID", issueID.ToString(), SQLMatchType.Equal); String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2); String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4); String fe7 = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe7); } e.InputParameters["filterExpression"] = fe; }
private CRMSurveyEntity BuildCRMSurveyEntity() { CRMSurveyEntity cRMSurveyEntity = CurrentCRMSurveyEntity; cRMSurveyEntity.SurveyMasterID = OverviewSurveryMasterID; if (ddlSurveyOwnerID.Items.Count > 0) { if (ddlSurveyOwnerID.SelectedValue == "0") { } else { cRMSurveyEntity.SurveyOwnerID = Int64.Parse(ddlSurveyOwnerID.SelectedValue); } } if (ddlAreaID.Items.Count > 0) { if (ddlAreaID.SelectedValue == "0") { } else { cRMSurveyEntity.AreaID = Int64.Parse(ddlAreaID.SelectedValue); } } cRMSurveyEntity.Description = txtDescription.Text.Trim(); cRMSurveyEntity.PlotAddress = txtPlotAddress.Text.Trim(); if (!txtApproximatePlotSize.Text.Trim().IsNullOrEmpty()) { cRMSurveyEntity.ApproximatePlotSize = Decimal.Parse(txtApproximatePlotSize.Text.Trim()); } if (ddlAreaUnitID.Items.Count > 0) { if (ddlAreaUnitID.SelectedValue == "0") { } else { cRMSurveyEntity.AreaUnitID = Int64.Parse(ddlAreaUnitID.SelectedValue); } } if (!txtApproximateFloorSizeSft.Text.Trim().IsNullOrEmpty()) { cRMSurveyEntity.ApproximateFloorSizeSft = Decimal.Parse(txtApproximateFloorSizeSft.Text.Trim()); } if (!txtFloors.Text.Trim().IsNullOrEmpty()) { cRMSurveyEntity.Floors = Decimal.Parse(txtFloors.Text.Trim()); } if (!txtApproximateTotalSpaceSft.Text.Trim().IsNullOrEmpty()) { cRMSurveyEntity.ApproximateTotalSpaceSft = Decimal.Parse(txtApproximateTotalSpaceSft.Text.Trim()); } cRMSurveyEntity.Basements = txtBasements.Text.Trim(); cRMSurveyEntity.NoOfCarParking = txtNoOfCarParking.Text.Trim(); cRMSurveyEntity.ACSystem = txtACSystem.Text.Trim(); cRMSurveyEntity.GeneratorBackup = txtGeneratorBackup.Text.Trim(); cRMSurveyEntity.LiftsCapacity = txtLiftsCapacity.Text.Trim(); cRMSurveyEntity.ToiletsPerFloor = txtToiletsPerFloor.Text.Trim(); cRMSurveyEntity.AvailableFloorSft = txtAvailableFloorSft.Text.Trim(); cRMSurveyEntity.AvailableForOccupancy = txtAvailableForOccupancy.Text.Trim(); cRMSurveyEntity.RentalRateBDTPerSft = txtRentalRateBDTPerSft.Text.Trim(); cRMSurveyEntity.SellingRateBDTPerSft = txtSellingRateBDTPerSft.Text.Trim(); cRMSurveyEntity.HandoverTime = txtHandoverTime.Text.Trim(); if (ddlSurveyBuildingStatusID.Items.Count > 0) { if (ddlSurveyBuildingStatusID.SelectedValue == "0") { } else { cRMSurveyEntity.SurveyBuildingStatusID = Int64.Parse(ddlSurveyBuildingStatusID.SelectedValue); } } if (ddlSurveySourceInformationID.Items.Count > 0) { if (ddlSurveySourceInformationID.SelectedValue == "0") { } else { cRMSurveyEntity.SurveySourceInformationID = Int64.Parse(ddlSurveySourceInformationID.SelectedValue); } } cRMSurveyEntity.SourcePersonInformation = txtSourcePersonInformation.Text.Trim(); cRMSurveyEntity.ContactInfo = txtContactInfo.Text.Trim(); cRMSurveyEntity.Remarks = txtRemarks.Text.Trim(); cRMSurveyEntity.AdditionalRemarks = txtAdditionalRemarks.Text.Trim(); cRMSurveyEntity.OthersRemarks = txtOthersRemarks.Text.Trim(); cRMSurveyEntity.CreateDate = System.DateTime.Now; if (txtSurveyDate.Text.Trim().IsNotNullOrEmpty()) { cRMSurveyEntity.SurveyDate = MiscUtil.ParseToDateTime(txtSurveyDate.Text); } cRMSurveyEntity.IP = MiscUtil.GetLocalIP(); cRMSurveyEntity.SurveyByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); cRMSurveyEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); return(cRMSurveyEntity); }
protected void btnPnlSaveAdditionalQty_Click(object sender, EventArgs e) { PRMBOQDetailEntity pRMBOQDetailEntity = FCCPRMBOQDetail.GetFacadeCreate().GetByID(_CurrentBOQDetailIDPopup); if (pRMBOQDetailEntity != null && pRMBOQDetailEntity.BOQDetailID > 0) { Decimal additionalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out additionalQty); PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = _CurrentBOQDetailIDPopup; pRMAvailableBOQQtyForRequisitionEntity.ItemID = pRMBOQDetailEntity.ItemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = additionalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); PRMBOQEntity pRMBOQEntity = FCCPRMBOQ.GetFacadeCreate().GetByID(pRMBOQDetailEntity.BOQID); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = pRMBOQEntity.ProjectID; Int64 result = -1; result = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal); pRMBOQDetailEntity.TotalQty = pRMBOQDetailEntity.TotalQty + additionalQty; FCCPRMBOQDetail.GetFacadeCreate().Update(pRMBOQDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); IList <ListViewDataItem> list = lvPRMBOQDetail.Items; if (list != null && list.Count > 0) { Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++]; Int64 intBOQDetailID = (Int64)currentDataKey["BOQDetailID"]; if (_CurrentBOQDetailIDPopup == intBOQDetailID) { TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtTotalQtyLV"); txtTotalQtyLV.Text = pRMBOQDetailEntity.TotalQty.ToString(); } } } BindPRMBOQDetailList(); #region BOQ Floor Detail String fe_projectFloor = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal); IList <PRMBOQFloorDetailEntity> lstPRMBOQFloorDetail = FCCPRMBOQFloorDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_projectFloor, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQFloorDetail != null && lstPRMBOQFloorDetail.Count > 0) { Int64 totalfloorCount = lstPRMBOQFloorDetail.Count; Decimal avgQty = pRMBOQDetailEntity.TotalQty / totalfloorCount; foreach (PRMBOQFloorDetailEntity ent in lstPRMBOQFloorDetail) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, ent.BOQFloorDetailID.ToString(), SQLMatchType.Equal); ent.Qty = avgQty; FCCPRMBOQFloorDetail.GetFacadeCreate().Update(ent, fe1, DatabaseOperationType.Update, TransactionRequired.No); } } #endregion this.ModalPopupExtender1.Hide(); } } }
protected void btnAddToProject_Click(object sender, EventArgs e) { if (ddlProjectID.Items.Count > 0 && ddlProjectID.SelectedValue != "0") { Int64 itemID = 0; if (ViewState["LastUpdatedItemID"] != null) { itemID = (Int64)ViewState["LastUpdatedItemID"]; } if (itemID > 0) { String fe_itemDefault = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal); IList <MDItemDefaultEntity> lstmDItemDefaultEntity = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemDefault, DatabaseOperationType.LoadWithFilterExpression); String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (preBOQList != null && preBOQList.Count > 0) { Int64 preBOQID = preBOQList[0].PreBOQID; Decimal totalQty = 0; Decimal.TryParse(txtQty.Text.Trim().ToString(), out totalQty); Decimal currentPrice = MiscUtil.GetCurrentPrice(itemID, lstmDItemDefaultEntity[0].BrandID, lstmDItemDefaultEntity[0].SupplierID, lstmDItemDefaultEntity[0].RegionID, lstmDItemDefaultEntity[0].CountryID); switch (preBOQList[0].IsLocked) { case true: #region Add Item to BOQ try { String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMBOQ != null && lstPRMBOQ.Count > 0) { PRMBOQDetailEntity pRMBOQDeatEntity = new PRMBOQDetailEntity(); pRMBOQDeatEntity.BOQID = lstPRMBOQ[0].BOQID; pRMBOQDeatEntity.ItemID = itemID; pRMBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMBOQDeatEntity.Remarks = "Directly Added From Item"; pRMBOQDeatEntity.IsRemoved = false; pRMBOQDeatEntity.Rate = currentPrice; pRMBOQDeatEntity.EntryDate = System.DateTime.Now; pRMBOQDeatEntity.TotalQty = totalQty; Int64 result_boq = -1; result_boq = FCCPRMBOQDetail.GetFacadeCreate().Add(pRMBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_boq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_boq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to Project Cost.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; case false: #region Add Item to Pre-BOQ try { String fe_preBOQ = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal); IList <PRMPreBOQEntity> lstPRMPreBOQ = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQ, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMPreBOQ != null && lstPRMPreBOQ.Count > 0) { PRMPreBOQDetailEntity pRMPreBOQDeatEntity = new PRMPreBOQDetailEntity(); pRMPreBOQDeatEntity.PreBOQID = lstPRMPreBOQ[0].PreBOQID; pRMPreBOQDeatEntity.ItemID = itemID; pRMPreBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID; pRMPreBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID; pRMPreBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID; pRMPreBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID; pRMPreBOQDeatEntity.TotalQty = totalQty; pRMPreBOQDeatEntity.Remarks = "Directly Added From Item"; pRMPreBOQDeatEntity.IsRemoved = false; pRMPreBOQDeatEntity.Rate = currentPrice; pRMPreBOQDeatEntity.EntryDate = System.DateTime.Now; Int64 result_preboq = -1; result_preboq = FCCPRMPreBOQDetail.GetFacadeCreate().Add(pRMPreBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No); if (result_preboq > 0) { PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity(); pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = false; pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_preboq; pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID; pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty; pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now; pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember); pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); Int64 result_available = -1; result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No); MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to BOQ.", false); } } } catch (Exception) { MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true); } #endregion break; default: break; } } } } }