private void BuildDropDownList() { BuildREQRequisitionItem(); #region Approval Dropdown if (!(APForwardInfoID > 0)) { ddlAction.Items.Add(new ListItem("Approve", "1")); ddlAction.Items.Add(new ListItem("Back", "2")); ddlAction.Items.Add(new ListItem("Forward", "3")); APMemberFeedbackEntity ent = APRobot.GetAPMemberFeedbackByID(APMemberFeedbackID); ddlRejectTo.Items.Clear(); ddlRejectTo.DataTextField = APMemberFeedback_DetailedEntity.FLD_NAME_MemberFullName; ddlRejectTo.DataValueField = APMemberFeedback_DetailedEntity.FLD_NAME_APMemberFeedbackID; ddlRejectTo.DataSource = APRobot.GetRejectToMemberFeedbacks_Detailed(APApprovalProcessID, ent.EmployeeID); ddlRejectTo.DataBind(); ListItem pleaseSelectListItem = new ListItem("Please Select", "0"); ddlRejectTo.Items.Insert(0, pleaseSelectListItem); ddlForwardTo.Items.Clear(); ddlForwardTo.DataTextField = APPanelForwardMember_DetailedEntity.FLD_NAME_MemberFullName; ddlForwardTo.DataValueField = APPanelForwardMember_DetailedEntity.FLD_NAME_APPanelForwardMemberID; ddlForwardTo.DataSource = APRobot.GetAPPanelForwardMemberByApprovalProcessTypeAndReferenceID(MasterDataConstants.APType.WORK_ORDER, PRMWorkOrderID); ddlForwardTo.DataBind(); } else { ddlAction.Items.Add(new ListItem("Comment", "4")); } #endregion }
private Int64 UpdateTran(APMemberFeedbackEntity aPMemberFeedbackEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.APMemberFeedback_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option, db); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); db.AddInParameter(cmd, "@APMemberFeedbackID", DbType.Int64, aPMemberFeedbackEntity.APMemberFeedbackID); db.AddInParameter(cmd, "@APApprovalProcessID", DbType.Int64, aPMemberFeedbackEntity.APApprovalProcessID); db.AddInParameter(cmd, "@DepartmentID", DbType.Int64, aPMemberFeedbackEntity.DepartmentID); db.AddInParameter(cmd, "@EmployeeID", DbType.Int64, aPMemberFeedbackEntity.EmployeeID); db.AddInParameter(cmd, "@SequenceNo", DbType.Int32, aPMemberFeedbackEntity.SequenceNo); db.AddInParameter(cmd, "@APFeedbackID", DbType.Int64, aPMemberFeedbackEntity.APFeedbackID); db.AddInParameter(cmd, "@FeedbackRequestDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackRequestDate); db.AddInParameter(cmd, "@FeedbackLastResponseDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackLastResponseDate); db.AddInParameter(cmd, "@FeedbackSubmitDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackSubmitDate); db.AddInParameter(cmd, "@ProxyEmployeeID", DbType.Int64, aPMemberFeedbackEntity.ProxyEmployeeID); db.AddInParameter(cmd, "@IsProxyEmployeeEnabled", DbType.Boolean, aPMemberFeedbackEntity.IsProxyEmployeeEnabled); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode > 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
Int64 IAPMemberFeedbackDataAccess.Add(APMemberFeedbackEntity aPMemberFeedbackEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(aPMemberFeedbackEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(aPMemberFeedbackEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void BuildDropDownListAP() { if (!(APForwardInfoID > 0)) { ddlAction.Items.Add(new ListItem("Approve", "1")); ddlAction.Items.Add(new ListItem("Reject", "2")); ddlAction.Items.Add(new ListItem("Forward", "3")); // ddlAction.Items.Add(new ListItem("Canceled & Return To Initiator", "4")); APMemberFeedbackEntity ent = APRobot.GetAPMemberFeedbackByID(APMemberFeedbackID); ddlRejectTo.Items.Clear(); ddlRejectTo.DataTextField = APMemberFeedback_DetailedEntity.FLD_NAME_MemberFullName; ddlRejectTo.DataValueField = APMemberFeedback_DetailedEntity.FLD_NAME_APMemberFeedbackID; ddlRejectTo.DataSource = APRobot.GetRejectToMemberFeedbacks_Detailed(APApprovalProcessID, ent.EmployeeID); ddlRejectTo.DataBind(); ListItem pleaseSelectListItem = new ListItem("Please Select", "0"); ddlRejectTo.Items.Insert(0, pleaseSelectListItem); ddlForwardTo.Items.Clear(); ddlForwardTo.DataTextField = APPanelForwardMember_DetailedEntity.FLD_NAME_MemberFullName; ddlForwardTo.DataValueField = APPanelForwardMember_DetailedEntity.FLD_NAME_APPanelForwardMemberID; ddlForwardTo.DataSource = APRobot.GetAPPanelForwardMemberByApprovalProcessTypeAndReferenceID(MasterDataConstants.APType.AGREEMENT, OverviewAgreementID); ddlForwardTo.DataBind(); } else { ddlAction.Items.Add(new ListItem("Comment", "4")); } }
private void EnableDisableApprovalButtons() { if (!(APForwardInfoID > 0)) { APMemberFeedbackEntity ent = APRobot.GetAPMemberFeedbackByID(APMemberFeedbackID); if (ent.APFeedbackID == MasterDataConstants.APFeedback.APPROVED || ent.APFeedbackID == MasterDataConstants.APFeedback.REJECTED || ent.APFeedbackID == MasterDataConstants.APFeedback.NOT_YET_REQUESTED || ent.APFeedbackID == MasterDataConstants.APFeedback.CANCELED) { btnApprove.Enabled = false; btnReject.Enabled = false; btnForward.Enabled = false; } else { btnApprove.Enabled = true; btnReject.Enabled = true; btnForward.Enabled = true; } Boolean isAPFirstMember = APRobot.IsFirstMemberFeedback(APMemberFeedbackID); if (isAPFirstMember) { if (ent.APFeedbackID == MasterDataConstants.APFeedback.APPROVED || ent.APFeedbackID == MasterDataConstants.APFeedback.REJECTED || ent.APFeedbackID == MasterDataConstants.APFeedback.NOT_YET_REQUESTED || ent.APFeedbackID == MasterDataConstants.APFeedback.CANCELED) { //addPanel.Visible = false; //btnSubmit.Visible = false; } else { //addPanel.Visible = true; //btnSubmit.Visible = true; } } else { //addPanel.Visible = false; //btnSubmit.Visible = false; } } else { btnApprove.Enabled = false; btnReject.Enabled = false; btnForward.Enabled = false; //addPanel.Visible = false; //btnSubmit.Visible = false; } }
private void SaveAPMemberFeedbackEntity() { if (IsValid) { try { APMemberFeedbackEntity aPMemberFeedbackEntity = BuildAPMemberFeedbackEntity(); Int64 result = -1; if (aPMemberFeedbackEntity.IsNew) { result = FCCAPMemberFeedback.GetFacadeCreate().Add(aPMemberFeedbackEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, aPMemberFeedbackEntity.APMemberFeedbackID.ToString(), SQLMatchType.Equal); result = FCCAPMemberFeedback.GetFacadeCreate().Update(aPMemberFeedbackEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _APMemberFeedbackID = 0; _APMemberFeedbackEntity = new APMemberFeedbackEntity(); PrepareInitialView(); BindAPMemberFeedbackList(); if (aPMemberFeedbackEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Approval Process Member Feedback Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Approval Process Member Feedback Information has been updated successfully.", false); } } else { if (aPMemberFeedbackEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Approval Process Member Feedback Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Approval Process Member Feedback Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvAPMemberFeedback_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 APMemberFeedbackID; Int64.TryParse(e.CommandArgument.ToString(), out APMemberFeedbackID); if (APMemberFeedbackID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _APMemberFeedbackID = APMemberFeedbackID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, APMemberFeedbackID.ToString(), SQLMatchType.Equal); APMemberFeedbackEntity aPMemberFeedbackEntity = new APMemberFeedbackEntity(); result = FCCAPMemberFeedback.GetFacadeCreate().Delete(aPMemberFeedbackEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _APMemberFeedbackID = 0; _APMemberFeedbackEntity = new APMemberFeedbackEntity(); PrepareInitialView(); BindAPMemberFeedbackList(); MiscUtil.ShowMessage(lblMessage, "Approval Process Member Feedback has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Approval Process Member Feedback.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(APMemberFeedbackEntity aPMemberFeedbackEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.APMemberFeedback_SET"; Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd, db); AddFilterExpressionParameter(cmd, filterExpression, db); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { using (IDataReader reader = db.ExecuteReader(cmd, transaction)) { returnCode = GetReturnCodeFromParameter(cmd); } if (returnCode >= 0) { transaction.Commit(); } else { throw new ArgumentException("Error Code." + returnCode.ToString()); } } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { transaction.Dispose(); connection.Close(); connection = null; } } return(returnCode); }
private Int64 Update(APMemberFeedbackEntity aPMemberFeedbackEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.APMemberFeedback_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@APMemberFeedbackID", DbType.Int64, aPMemberFeedbackEntity.APMemberFeedbackID); Database.AddInParameter(cmd, "@APApprovalProcessID", DbType.Int64, aPMemberFeedbackEntity.APApprovalProcessID); Database.AddInParameter(cmd, "@DepartmentID", DbType.Int64, aPMemberFeedbackEntity.DepartmentID); Database.AddInParameter(cmd, "@EmployeeID", DbType.Int64, aPMemberFeedbackEntity.EmployeeID); Database.AddInParameter(cmd, "@SequenceNo", DbType.Int32, aPMemberFeedbackEntity.SequenceNo); Database.AddInParameter(cmd, "@APFeedbackID", DbType.Int64, aPMemberFeedbackEntity.APFeedbackID); Database.AddInParameter(cmd, "@FeedbackRequestDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackRequestDate); Database.AddInParameter(cmd, "@FeedbackLastResponseDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackLastResponseDate); Database.AddInParameter(cmd, "@FeedbackSubmitDate", DbType.DateTime, aPMemberFeedbackEntity.FeedbackSubmitDate); Database.AddInParameter(cmd, "@ProxyEmployeeID", DbType.Int64, aPMemberFeedbackEntity.ProxyEmployeeID); Database.AddInParameter(cmd, "@IsProxyEmployeeEnabled", DbType.Boolean, aPMemberFeedbackEntity.IsProxyEmployeeEnabled); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("APMemberFeedbackEntity already exists. Please specify another APMemberFeedbackEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("APMemberFeedbackEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("APMemberFeedbackEntity already exists. Please specify another APMemberFeedbackEntity."); } } } } return(returnCode); }
protected void btnPnlCancelWO_Click(object sender, EventArgs e) { PRMWorkOrderEntity pRMWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(PRMWorkOrderID); pRMWorkOrderEntity.WorkOrderStatusID = MasterDataConstants.WorkOrderStatus.CANCELED; pRMWorkOrderEntity.Remarks = txtWOCancelRemarks.Text.Trim().ToString(); Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal); result = FCCPRMWorkOrder.GetFacadeCreate().Update(pRMWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); if (result > 0) { #region AP Update APApprovalProcessEntity aPApprovalProcessEntity = FCCAPApprovalProcess.GetFacadeCreate().GetByID(APApprovalProcessID); if (aPApprovalProcessEntity != null && aPApprovalProcessEntity.APApprovalProcessID > 0) { aPApprovalProcessEntity.APStatusID = MasterDataConstants.APStatus.CANCELED; Int64 resultOne = -1; String fe_one = SqlExpressionBuilder.PrepareFilterExpression(APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, APApprovalProcessID.ToString(), SQLMatchType.Equal); resultOne = FCCAPApprovalProcess.GetFacadeCreate().Update(aPApprovalProcessEntity, fe_one, DatabaseOperationType.Update, TransactionRequired.No); if (resultOne > 0) { APMemberFeedbackEntity aPMemberFeedbackEntity = FCCAPMemberFeedback.GetFacadeCreate().GetByID(APMemberFeedbackID); if (aPMemberFeedbackEntity != null && aPMemberFeedbackEntity.APMemberFeedbackID > 0) { aPMemberFeedbackEntity.APFeedbackID = MasterDataConstants.APFeedback.CANCELED; Int64 resultC = -1; String fe_memberfeedback = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, APMemberFeedbackID.ToString(), SQLMatchType.Equal); resultC = FCCAPMemberFeedback.GetFacadeCreate().Update(aPMemberFeedbackEntity, fe_memberfeedback, DatabaseOperationType.Update, TransactionRequired.No); RedirectPageToPendingList(); } } } #endregion } }
protected void lvAPMemberFeedback_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; APMemberFeedbackEntity ent = (APMemberFeedbackEntity)dataItem.DataItem; APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByID(ent.APApprovalProcessID); HyperLink lnkViewDetails = (HyperLink)e.Item.FindControl("lnkViewDetails"); HiddenField hydAPApprovalProcessID = (HiddenField)e.Item.FindControl("hydAPApprovalProcessID"); Label lblTitle = (Label)e.Item.FindControl("lblTitle"); if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.REQUISITION) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/REQ/REQRequisitionDetailsWithApproval.aspx", string.Empty, UrlConstants.REQUISITION_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString() ).ToString(); } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.WORK_ORDER) { lnkViewDetails.NavigateUrl = UrlHelper.BuildSecureUrl( "~/PRM/PRMWorkOrderViewWithApproval.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, aPApprovalProcessEntity.ReferenceID.ToString(), APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString() ).ToString(); } else if (aPApprovalProcessEntity.APTypeID == MasterDataConstants.APType.CUSTOM) { lnkViewDetails.NavigateUrl = "#"; } lnkViewDetails.Target = "_blank"; } }
private Int64 Delete(APMemberFeedbackEntity aPMemberFeedbackEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.APMemberFeedback_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("APMemberFeedbackEntity already exists. Please specify another APMemberFeedbackEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("APMemberFeedbackEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("APMemberFeedbackEntity already exists. Please specify another APMemberFeedbackEntity."); } } } } return(returnCode); }
private void PrepareEditView() { APMemberFeedbackEntity aPMemberFeedbackEntity = CurrentAPMemberFeedbackEntity; if (!aPMemberFeedbackEntity.IsNew) { if (ddlAPApprovalProcessID.Items.Count > 0 && aPMemberFeedbackEntity.APApprovalProcessID != null) { ddlAPApprovalProcessID.SelectedValue = aPMemberFeedbackEntity.APApprovalProcessID.ToString(); } if (ddlDepartmentID.Items.Count > 0 && aPMemberFeedbackEntity.DepartmentID != null) { ddlDepartmentID.SelectedValue = aPMemberFeedbackEntity.DepartmentID.ToString(); } if (ddlEmployeeID.Items.Count > 0 && aPMemberFeedbackEntity.EmployeeID != null) { ddlEmployeeID.SelectedValue = aPMemberFeedbackEntity.EmployeeID.ToString(); } txtSequenceNo.Text = aPMemberFeedbackEntity.SequenceNo.ToString(); if (ddlAPFeedbackID.Items.Count > 0 && aPMemberFeedbackEntity.APFeedbackID != null) { ddlAPFeedbackID.SelectedValue = aPMemberFeedbackEntity.APFeedbackID.ToString(); } txtFeedbackRequestDate.Text = aPMemberFeedbackEntity.FeedbackRequestDate.ToStringDefault(); txtFeedbackLastResponseDate.Text = aPMemberFeedbackEntity.FeedbackLastResponseDate.ToStringDefault(); txtFeedbackSubmitDate.Text = aPMemberFeedbackEntity.FeedbackSubmitDate.ToStringDefault(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
protected void btnAddNew_Click(object sender, EventArgs e) { _APMemberFeedbackID = 0; _APMemberFeedbackEntity = new APMemberFeedbackEntity(); PrepareInitialView(); }
Int64 IAPMemberFeedbackFacade.Delete(APMemberFeedbackEntity aPMemberFeedbackEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateAPMemberFeedbackDataAccess().Delete(aPMemberFeedbackEntity, filterExpression, option, reqTran)); }
Int64 IAPMemberFeedbackFacade.Add(APMemberFeedbackEntity aPMemberFeedbackEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateAPMemberFeedbackDataAccess().Add(aPMemberFeedbackEntity, option, reqTran)); }
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 APMemberFeedbackEntity BuildAPMemberFeedbackEntity() { APMemberFeedbackEntity aPMemberFeedbackEntity = CurrentAPMemberFeedbackEntity; if (ddlAPApprovalProcessID.Items.Count > 0) { if (ddlAPApprovalProcessID.SelectedValue == "0") { } else { aPMemberFeedbackEntity.APApprovalProcessID = Int64.Parse(ddlAPApprovalProcessID.SelectedValue); } } if (ddlDepartmentID.Items.Count > 0) { if (ddlDepartmentID.SelectedValue == "0") { } else { aPMemberFeedbackEntity.DepartmentID = Int64.Parse(ddlDepartmentID.SelectedValue); } } if (ddlEmployeeID.Items.Count > 0) { if (ddlEmployeeID.SelectedValue == "0") { } else { aPMemberFeedbackEntity.EmployeeID = Int64.Parse(ddlEmployeeID.SelectedValue); } } if (!txtSequenceNo.Text.Trim().IsNullOrEmpty()) { aPMemberFeedbackEntity.SequenceNo = Int32.Parse(txtSequenceNo.Text.Trim()); } if (ddlAPFeedbackID.Items.Count > 0) { if (ddlAPFeedbackID.SelectedValue == "0") { } else { aPMemberFeedbackEntity.APFeedbackID = Int64.Parse(ddlAPFeedbackID.SelectedValue); } } if (txtFeedbackRequestDate.Text.Trim().IsNotNullOrEmpty()) { aPMemberFeedbackEntity.FeedbackRequestDate = MiscUtil.ParseToDateTime(txtFeedbackRequestDate.Text); } else { aPMemberFeedbackEntity.FeedbackRequestDate = null; } if (txtFeedbackLastResponseDate.Text.Trim().IsNotNullOrEmpty()) { aPMemberFeedbackEntity.FeedbackLastResponseDate = MiscUtil.ParseToDateTime(txtFeedbackLastResponseDate.Text); } else { aPMemberFeedbackEntity.FeedbackLastResponseDate = null; } if (txtFeedbackSubmitDate.Text.Trim().IsNotNullOrEmpty()) { aPMemberFeedbackEntity.FeedbackSubmitDate = MiscUtil.ParseToDateTime(txtFeedbackSubmitDate.Text); } else { aPMemberFeedbackEntity.FeedbackSubmitDate = null; } return(aPMemberFeedbackEntity); }