protected void odsPRMWorkOrderPaymentTerm_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderPaymentTermEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal);
e.InputParameters["filterExpression"] = fe;
}
private void PrepareInitialView()
{
BuildDropDownList();
lblWorkOrderNo.Text = PRMWorkOrderNo.ToString();
txtPaymentPercentage.Text = "0";
txtCompletionPercentage.Text = "0";
txtCompletionNote.Text = String.Empty;
txtPaymentDate.Text = String.Empty;
btnSubmit.Text = "Add";
btnAddNew.Visible = false;
#region Build Hyperlink
hypWorkOrder.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrder.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString()).ToString();
hypWorkOrderItem.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderItemMap.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, PRMWorkOrderNo.ToString()).ToString();
hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "WorkOrderReport", UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString()).ToString();
hypReport.Target = "_blank";
#endregion
#region Approval Process
EnableDisableApprovalProcessCheck();
#endregion
}
private void PrepareInitialView()
{
BuildDropDownList();
lblWorkOrderNo.Text = CurrentWorkOrderEntity.WorkOrderNo.ToString();
BuildGrandTotalLabel();
#region Build Hyperlink
if (CurrentWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED)
{
hypWorkOrder.NavigateUrl = String.Empty;
hypWorkOrderItem.NavigateUrl = String.Empty;
hypWorkOrderPaymentTerm.NavigateUrl = String.Empty;
}
else
{
hypWorkOrder.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrder.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString()).ToString();;
hypWorkOrderItem.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderItemMap.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, CurrentWorkOrderEntity.WorkOrderNo).ToString();
hypWorkOrderPaymentTerm.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderPaymentTerm.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, CurrentWorkOrderEntity.WorkOrderNo).ToString();
}
hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "WorkOrderReport", UrlConstants.OVERVIEW_WORKORDER_ID, PRMWorkOrderID.ToString()).ToString();
hypReport.Target = "_blank";
if (CurrentWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.CANCELED ||
CurrentWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED ||
CurrentWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.REJECTED)
{
btnCancelWO.Enabled = false;
}
#endregion
#region Approval
lvAPMemberFeedbackRemarks.DataSource = APRobot.GetMemberFeedbackRemarks_DetailedByApprovalProcessID(APApprovalProcessID);
lvAPMemberFeedbackRemarks.DataBind();
EnableDisableApprovalButtons();
PrepareInitialViewPopup();
#endregion
}
private void BuildGrandTotalLabel()
{
if (PRMWorkOrderID > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMapEntity> lst = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
var transinfo = (from transaction in lst
select transaction.RequiredQty * transaction.Rate).Sum(val => val);
PRMWorkOrderEntity pRMWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(PRMWorkOrderID);
Decimal totalPrice = transinfo;
Decimal AIT, Discount, Vat, Tax, CarryingCharge;
Decimal.TryParse(pRMWorkOrderEntity.AIT.ToString(), out AIT);
Decimal.TryParse(pRMWorkOrderEntity.Discount.ToString(), out Discount);
Decimal.TryParse(pRMWorkOrderEntity.CarryingCharge.ToString(), out CarryingCharge);
Decimal.TryParse(pRMWorkOrderEntity.VAT.ToString(), out Vat);
Decimal.TryParse(pRMWorkOrderEntity.Tax.ToString(), out Tax);
totalPrice += AIT;
totalPrice += Discount;
totalPrice -= Vat;
totalPrice -= Tax;
totalPrice -= CarryingCharge;
//lblGrandTotal.Text = Math.Round(transinfo,2).ToString();
lblGrandTotal.Text = MiscUtil.NumericCommaSeperatedFormat((Decimal)totalPrice);
}
}
}
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
}
}
