protected void grvCashPaymentRequestList_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Button             btnStatus = e.Row.FindControl("btnStatus") as Button;
            CashPaymentRequest CPR       = e.Row.DataItem as CashPaymentRequest;

            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if (CPR != null)
                {
                    if (CPR.ProgressStatus == ProgressStatus.InProgress.ToString())
                    {
                        btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFF6C");
                    }
                    else if (CPR.CashPaymentRequestStatuses.Last().PaymentType == "Bank Payment" && !IsCashPaymentRequested(CPR.Id) && CPR.CurrentStatus != ApprovalStatus.Rejected.ToString())
                    {
                        btnStatus.BackColor = System.Drawing.Color.Green;
                    }
                    else if (CPR.ProgressStatus == ProgressStatus.Completed.ToString())
                    {
                        btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF7251");
                    }

                    if (ddlSrchProgressStatus.SelectedValue == "Reviewed")
                    {
                        e.Row.Cells[8].Enabled = false;
                    }
                }
            }
        }
Ejemplo n.º 2
0
        protected void grvCashPaymentRequestList_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            Button             btnStatus = e.Row.FindControl("btnStatus") as Button;
            CashPaymentRequest CSR       = e.Row.DataItem as CashPaymentRequest;

            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if (CSR != null)
                {
                    if (e.Row.RowType == DataControlRowType.DataRow)
                    {
                        if (CSR.CurrentLevel == CSR.CashPaymentRequestStatuses.Count && CSR.ProgressStatus == "Completed")
                        {
                            e.Row.Cells[8].Visible = true;
                        }
                        else
                        {
                            e.Row.Cells[8].Visible = false;
                        }
                    }

                    if (CSR.ProgressStatus == ProgressStatus.InProgress.ToString())
                    {
                        btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFF6C");
                    }
                    else if (CSR.ProgressStatus == ProgressStatus.Completed.ToString())
                    {
                        btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF7251");
                    }
                }
            }
        }
Ejemplo n.º 3
0
 protected void grvBankProgress_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (_presenter.ListBankPaymentApprovalProgress() != null)
     {
         if (e.Row.RowType == DataControlRowType.DataRow)
         {
             OperationalControlRequest theBankPayment = _presenter.ListBankPaymentApprovalProgress()[e.Row.RowIndex];
             if (theBankPayment.CurrentApprover != 0)
             {
                 e.Row.Cells[3].Text = _presenter.GetUser(theBankPayment.CurrentApprover).FullName;
             }
             if (theBankPayment.PaymentId > 0)
             {
                 CashPaymentRequest thePayment = _presenter.GetCashPaymentRequest(theBankPayment.PaymentId);
                 e.Row.Cells[2].Text = Guard.Against.Null(Guard.Against.Null(thePayment, " CashPaymentRequest ID: " + theBankPayment.PaymentId.ToString()).AppUser, " AppUser").FullName;
             }
             else if (theBankPayment.TravelAdvanceId > 0)
             {
                 TravelAdvanceRequest theTravel = _presenter.GetTravelAdvanceRequest(theBankPayment.TravelAdvanceId);
                 e.Row.Cells[2].Text = Guard.Against.Null(Guard.Against.Null(theTravel, " TravelAdvanceRequest ID: " + theBankPayment.TravelAdvanceId.ToString()).AppUser, " AppUser").FullName;
             }
             else if (theBankPayment.LiquidationId > 0)
             {
                 ExpenseLiquidationRequest theLiquidation = _presenter.GetExpenseLiquidationRequest(theBankPayment.LiquidationId);
                 e.Row.Cells[2].Text = Guard.Against.Null(Guard.Against.Null(theLiquidation, " ExpenseLiquidationRequest ID: " + theBankPayment.LiquidationId.ToString()).TravelAdvanceRequest.AppUser, " AppUser").FullName;
             }
             else if (theBankPayment.SettlementId > 0)
             {
                 PaymentReimbursementRequest theReimbursement = _presenter.GetPaymentReimbursementRequest(theBankPayment.SettlementId);
                 e.Row.Cells[2].Text = Guard.Against.Null(Guard.Against.Null(theReimbursement, " PaymentReimbursement ID: " + theBankPayment.SettlementId.ToString()).CashPaymentRequest.AppUser, " AppUser").FullName;
             }
         }
     }
 }
        private void UpdateExportStatus(DataTable dt)

        {
            foreach (DataRow DR in dt.Rows)
            {
                CashPaymentRequest Request = _presenter.GetCashPaymentRequestRequest(DR.Field <string>("RefNumber"));
                Request.ExportStatus = "Exported";
                _presenter.UpdateCashPaymentRequestExportStatus(Request);
            }
        }
Ejemplo n.º 5
0
 protected void grvCashPaymentRequestList_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.DataItem != null)
     {
         CashPaymentRequest cashPayment = e.Row.DataItem as CashPaymentRequest;
         if (cashPayment.CurrentStatus == "Rejected")
         {
             e.Row.ForeColor = System.Drawing.Color.Red;
         }
     }
 }
        public void SaveOrUpdateCashPaymentRequest()
        {
            CashPaymentRequest cashPaymentRequest = CurrentCashPaymentRequest;

            if (cashPaymentRequest.Id <= 0)
            {
                cashPaymentRequest.RequestNo = View.GetRequestNo;
                cashPaymentRequest.VoucherNo = View.GetVoucherNo;
            }
            cashPaymentRequest.RequestDate    = Convert.ToDateTime(DateTime.Today.ToShortDateString());
            cashPaymentRequest.Description    = View.GetDescription;
            cashPaymentRequest.AmountType     = View.GetAmountType;
            cashPaymentRequest.RequestType    = View.GetRequestType;
            cashPaymentRequest.Program        = _settingController.GetProgram(View.GetProgram);
            cashPaymentRequest.ProgressStatus = ProgressStatus.InProgress.ToString();
            cashPaymentRequest.AppUser        = _adminController.GetUser(CurrentUser().Id);
            //Check if the Payee is the logged in employee or a supplier
            if (View.GetPayee == -1)
            {
                cashPaymentRequest.Payee = CurrentUser().FullName;
            }
            else
            {
                cashPaymentRequest.Supplier = _settingController.GetSupplier(View.GetPayee);
            }

            if (View.GetAmountType != "Actual Amount")
            {
                cashPaymentRequest.PaymentReimbursementStatus = "Not Retired";
            }
            else
            {
                cashPaymentRequest.PaymentReimbursementStatus = "Retired";
                cashPaymentRequest.TotalActualExpendture      = cashPaymentRequest.TotalAmount;
            }

            cashPaymentRequest.ExportStatus = "Not Exported";
            cashPaymentRequest.IsLiquidated = false;

            if (CurrentCashPaymentRequest.CashPaymentRequestStatuses.Count == 0)
            {
                SaveCashPaymentRequestStatus();
            }

            GetCurrentApprover();

            _controller.SaveOrUpdateEntity(cashPaymentRequest);
        }
Ejemplo n.º 7
0
        public void SaveOrUpdateCashPaymentRequest()
        {
            CashPaymentRequest CashPaymentRequest = CurrentCashPaymentRequest;

            if (CashPaymentRequest.Id <= 0)
            {
                CashPaymentRequest.RequestNo = View.GetRequestNo;
                CashPaymentRequest.VoucherNo = View.GetVoucherNo;
            }
            CashPaymentRequest.RequestDate    = Convert.ToDateTime(DateTime.Today.ToShortDateString());
            CashPaymentRequest.Payee          = "";
            CashPaymentRequest.Description    = View.GetDescription;
            CashPaymentRequest.AmountType     = View.GetAmountType;
            CashPaymentRequest.PaymentMethod  = View.GetPaymentMethod;
            CashPaymentRequest.ProgressStatus = ProgressStatus.InProgress.ToString();
            CashPaymentRequest.AppUser        = _adminController.GetUser(CurrentUser().Id);
            CashPaymentRequest.Supplier       = _settingController.GetSupplier(View.GetPayee);
            if (View.GetAmountType != "Actual Amount")
            {
                CashPaymentRequest.PaymentReimbursementStatus = "Not Retired";
            }
            else
            {
                CashPaymentRequest.PaymentReimbursementStatus = "Retired";
                CashPaymentRequest.TotalActualExpendture      = CashPaymentRequest.TotalAmount;
            }

            CashPaymentRequest.ExportStatus = "Not Exported";
            if (CurrentCashPaymentRequest.CashPaymentRequestStatuses.Count == 0)
            {
                SaveCashPaymentRequestStatus();
            }

            GetCurrentApprover();

            _controller.SaveOrUpdateEntity(CashPaymentRequest);
        }
        private void PopulateBankPaymentDetail()
        {
            if (Request.QueryString["PaymentId"] != null)
            {
                CashPaymentRequest CPR = _presenter.GetCashPaymentRequest(Convert.ToInt32(Request.QueryString["PaymentId"]));
                if (CPR != null)
                {
                    _presenter.CurrentOperationalControlRequest.Description = CPR.Description;
                    foreach (CashPaymentRequestDetail CPRD in CPR.CashPaymentRequestDetails)
                    {
                        OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                        OCRD.ItemAccount      = CPRD.ItemAccount;
                        OCRD.Project          = CPRD.Project;
                        OCRD.Grant            = CPRD.Grant;
                        OCRD.Amount           = CPRD.Amount;
                        OCRD.ActualExpendture = CPRD.Amount;
                        OCRD.AccountCode      = CPRD.AccountCode;
                        _presenter.CurrentOperationalControlRequest.TotalAmount           += OCRD.Amount;
                        _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                        OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                        _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);

                        if (CPRD.CPRAttachments.Count > 0)
                        {
                            foreach (CPRAttachment CP in CPRD.CPRAttachments)
                            {
                                OCRAttachment OPA = new OCRAttachment();

                                OPA.FilePath = CP.FilePath;
                                OPA.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                            }
                        }
                    }
                }
            }
        }
Ejemplo n.º 9
0
 public void UpdateCashPaymentRequestExportStatus(CashPaymentRequest CashPaymentRequest)
 {
     _controller.SaveOrUpdateEntity(CashPaymentRequest);
 }
Ejemplo n.º 10
0
 public void DeleteCashPaymentRequest(CashPaymentRequest CashPaymentRequest)
 {
     _controller.DeleteEntity(CashPaymentRequest);
 }
Ejemplo n.º 11
0
 public void SaveOrUpdateCashPaymentRequest(CashPaymentRequest cashPaymentRequest)
 {
     _controller.SaveOrUpdateEntity(cashPaymentRequest);
     _controller.CurrentObject = null;
 }
Ejemplo n.º 12
0
        private void PopulateBankPaymentDetail()
        {
            if (Request.QueryString["Page"] != null)
            {
                if (Request.QueryString["Page"].Contains("CashPayment"))
                {
                    CashPaymentRequest CPR = _presenter.GetCashPaymentRequest(Convert.ToInt32(Request.QueryString["PaymentId"]));
                    if (CPR != null)
                    {
                        foreach (CashPaymentRequestDetail CPRD in CPR.CashPaymentRequestDetails)
                        {
                            OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                            OCRD.ItemAccount      = CPRD.ItemAccount;
                            OCRD.Project          = CPRD.Project;
                            OCRD.Grant            = CPRD.Grant;
                            OCRD.Amount           = CPRD.Amount;
                            OCRD.ActualExpendture = CPRD.Amount;
                            OCRD.AccountCode      = CPRD.AccountCode;
                            _presenter.CurrentOperationalControlRequest.TotalAmount           += OCRD.Amount;
                            _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                            OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                            _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                        }
                        if (CPR.CPRAttachments.Count > 0)
                        {
                            foreach (CPRAttachment CP in CPR.CPRAttachments)
                            {
                                OCRAttachment OPA = new OCRAttachment();

                                OPA.FilePath = CP.FilePath;
                                OPA.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                            }
                        }
                    }
                }

                else if (Request.QueryString["Page"].Contains("CostSharing"))
                {
                    CostSharingRequest CPR = _presenter.GetCostSharingPaymentRequest(Convert.ToInt32(Request.QueryString["PaymentId"]));
                    if (CPR != null)
                    {
                        foreach (CostSharingRequestDetail CPRD in CPR.CostSharingRequestDetails)
                        {
                            OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                            OCRD.ItemAccount      = CPRD.CostSharingRequest.ItemAccount;
                            OCRD.Project          = CPRD.Project;
                            OCRD.Grant            = CPRD.Grant;
                            OCRD.Amount           = CPRD.SharedAmount;
                            OCRD.ActualExpendture = CPRD.SharedAmount;
                            OCRD.AccountCode      = CPRD.CostSharingRequest.ItemAccount.AccountCode;
                            _presenter.CurrentOperationalControlRequest.TotalAmount           += OCRD.Amount;
                            _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                            OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                            _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                        }
                        if (CPR.CSRAttachments.Count > 0)
                        {
                            foreach (CSRAttachment CP in CPR.CSRAttachments)
                            {
                                OCRAttachment OPA = new OCRAttachment();
                                OPA.FilePath = CP.FilePath;
                                OPA.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                            }
                        }
                    }
                }

                /*else if (Request.QueryString["Page"].Contains("TravelAdvance"))
                 * {
                 *  CostSharingRequest CPR = _presenter.GetCostSharingPaymentRequest(Convert.ToInt32(Request.QueryString["PaymentId"]));
                 *  if (CPR != null)
                 *  {
                 *
                 *
                 *      foreach (CostSharingRequestDetail CPRD in CPR.CostSharingRequestDetails)
                 *      {
                 *          OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                 *          OCRD.ItemAccount = CPRD.CostSharingRequest.ItemAccount;
                 *          OCRD.Project = CPRD.Project;
                 *          OCRD.Grant = CPRD.Grant;
                 *          OCRD.Amount = CPRD.SharedAmount;
                 *          OCRD.ActualExpendture = CPRD.SharedAmount;
                 *          OCRD.AccountCode = CPRD.CostSharingRequest.ItemAccount.AccountCode;
                 *          _presenter.CurrentOperationalControlRequest.TotalAmount += OCRD.Amount;
                 *          _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                 *          OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                 *          _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                 *      }
                 *      if (CPR.CSRAttachments.Count > 0)
                 *      {
                 *          foreach (CSRAttachment CP in CPR.CSRAttachments)
                 *          {
                 *              OCRAttachment OPA = new OCRAttachment();
                 *              OPA.FilePath = CP.FilePath;
                 *              OPA.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                 *              _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                 *          }
                 *      }
                 *  }
                 * }*/
            }
        }
        private void PopulateBankPaymentDetail()
        {
            if (Request.QueryString["Page"] != null)
            {
                if (Request.QueryString["Page"].Contains("CashPayment"))
                {
                    if (Request.QueryString["PaymentId"] != null)
                    {
                        int paymentId          = Convert.ToInt32(Request.QueryString["PaymentId"]);
                        CashPaymentRequest CPR = _presenter.GetCashPaymentRequest(paymentId);
                        if (CPR != null)
                        {
                            _presenter.CurrentOperationalControlRequest.Description = CPR.Description;
                            _presenter.CurrentOperationalControlRequest.PaymentId   = paymentId;
                            _presenter.CurrentOperationalControlRequest.Supplier    = CPR.Supplier;
                            txtOriginalRequester.Text = CPR.AppUser.FullName;
                            txtDescription.Text       = CPR.Description;

                            foreach (CashPaymentRequestDetail CPRD in CPR.CashPaymentRequestDetails)
                            {
                                OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                                OCRD.ItemAccount      = CPRD.ItemAccount;
                                OCRD.Project          = CPRD.Project;
                                OCRD.Grant            = CPRD.Grant;
                                OCRD.Amount           = CPRD.Amount;
                                OCRD.ActualExpendture = CPRD.Amount;
                                OCRD.AccountCode      = CPRD.AccountCode;
                                _presenter.CurrentOperationalControlRequest.TotalAmount           += OCRD.Amount;
                                _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                                OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);

                                if (CPRD.CPRAttachments.Count > 0)
                                {
                                    foreach (CPRAttachment CP in CPRD.CPRAttachments)
                                    {
                                        OCRAttachment OPA = new OCRAttachment();

                                        OPA.FilePath = CP.FilePath;
                                        OPA.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                        _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                                    }
                                }
                            }
                        }
                    }
                }
                else if (Request.QueryString["Page"].Contains("TravelAdvance"))
                {
                    if (Request.QueryString["PaymentId"] != null)
                    {
                        int travelAdvId          = Convert.ToInt32(Request.QueryString["PaymentId"]);
                        TravelAdvanceRequest TAR = _presenter.GetTravelAdvanceRequest(travelAdvId);
                        if (TAR != null)
                        {
                            _presenter.CurrentOperationalControlRequest.Description     = TAR.PurposeOfTravel;
                            _presenter.CurrentOperationalControlRequest.TravelAdvanceId = travelAdvId;
                            txtOriginalRequester.Text = TAR.AppUser.FullName;
                            txtDescription.Text       = TAR.PurposeOfTravel;

                            foreach (TravelAdvanceRequestDetail TARD in TAR.TravelAdvanceRequestDetails)
                            {
                                foreach (TravelAdvanceCost TAC in TARD.TravelAdvanceCosts)
                                {
                                    OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                                    OCRD.ItemAccount      = TAC.ItemAccount;
                                    OCRD.AccountCode      = TAC.AccountCode;
                                    OCRD.Project          = TAR.Project;
                                    OCRD.Grant            = TAR.Grant;
                                    OCRD.Amount           = TAC.Total;
                                    OCRD.ActualExpendture = TAC.Total;
                                    _presenter.CurrentOperationalControlRequest.TotalAmount           += OCRD.Amount;
                                    _presenter.CurrentOperationalControlRequest.TotalActualExpendture += OCRD.Amount;
                                    OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                    _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                                }
                            }
                        }
                    }
                }
                else if (Request.QueryString["Page"].Contains("ExpenseLiquidation"))
                {
                    if (Request.QueryString["PaymentId"] != null)
                    {
                        int liquidationId             = Convert.ToInt32(Request.QueryString["PaymentId"]);
                        ExpenseLiquidationRequest ELR = _presenter.GetExpenseLiquidation(liquidationId);
                        if (ELR != null)
                        {
                            _presenter.CurrentOperationalControlRequest.LiquidationId = liquidationId;
                            txtOriginalRequester.Text = ELR.TravelAdvanceRequest.AppUser.FullName;
                            txtDescription.Text       = ELR.AdditionalComment;

                            OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail
                            {
                                Amount      = ELR.TotalActualExpenditure - ELR.TotalTravelAdvance,
                                ItemAccount = _presenter.GetDefaultItemAccount(),
                                Project     = ELR.ExpenseLiquidationRequestDetails[0].Project,
                                Grant       = ELR.ExpenseLiquidationRequestDetails[0].Grant
                            };

                            _presenter.CurrentOperationalControlRequest.TotalAmount           = OCRD.Amount;
                            _presenter.CurrentOperationalControlRequest.TotalActualExpendture = OCRD.Amount;
                            OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                            _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                        }
                    }
                }
                else if (Request.QueryString["Page"].Contains("Settlement"))
                {
                    if (Request.QueryString["SettlementId"] != null)
                    {
                        int SettlementId = Convert.ToInt32(Request.QueryString["SettlementId"]);
                        PaymentReimbursementRequest PRR = _presenter.GetReimbursementRequest(SettlementId);
                        if (PRR != null)
                        {
                            _presenter.CurrentOperationalControlRequest.Description  = PRR.Comment;
                            _presenter.CurrentOperationalControlRequest.SettlementId = SettlementId;
                            txtDescription.Text = PRR.Comment;

                            foreach (PaymentReimbursementRequestDetail detail in PRR.PaymentReimbursementRequestDetails)
                            {
                                OperationalControlRequestDetail OCRD = new OperationalControlRequestDetail();
                                OCRD.ItemAccount = PRR.CashPaymentRequest.CashPaymentRequestDetails[0].ItemAccount;//  detail.ItemAccount;
                                OCRD.Amount      = PRR.ReceivableAmount - PRR.TotalAmount;
                                OCRD.Project     = PRR.Project;
                                OCRD.Grant       = PRR.Grant;
                                _presenter.CurrentOperationalControlRequest.TotalAmount           = PRR.ReceivableAmount;
                                _presenter.CurrentOperationalControlRequest.TotalActualExpendture = PRR.TotalAmount;
                                OCRD.OperationalControlRequest = _presenter.CurrentOperationalControlRequest;
                                _presenter.CurrentOperationalControlRequest.OperationalControlRequestDetails.Add(OCRD);
                                if (detail.PRAttachments.Count > 0)
                                {
                                    foreach (PRAttachment CP in detail.PRAttachments)
                                    {
                                        OCRAttachment OPA = new OCRAttachment
                                        {
                                            FilePath = CP.FilePath,
                                            OperationalControlRequest = _presenter.CurrentOperationalControlRequest
                                        };
                                        _presenter.CurrentOperationalControlRequest.OCRAttachments.Add(OPA);
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
Ejemplo n.º 14
0
 public void SaveOrUpdateCashPaymentRequest(CashPaymentRequest cashPaymentRequest)
 {
     _controller.SaveOrUpdateEntity(cashPaymentRequest);
 }