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;
}
}
}
}
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");
}
}
}
}
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);
}
}
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);
}
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);
}
}
}
}
}
}
public void UpdateCashPaymentRequestExportStatus(CashPaymentRequest CashPaymentRequest)
{
_controller.SaveOrUpdateEntity(CashPaymentRequest);
}
public void DeleteCashPaymentRequest(CashPaymentRequest CashPaymentRequest)
{
_controller.DeleteEntity(CashPaymentRequest);
}
public void SaveOrUpdateCashPaymentRequest(CashPaymentRequest cashPaymentRequest)
{
_controller.SaveOrUpdateEntity(cashPaymentRequest);
_controller.CurrentObject = null;
}
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);
}
}
}
}
}
}
}
}
public void SaveOrUpdateCashPaymentRequest(CashPaymentRequest cashPaymentRequest)
{
_controller.SaveOrUpdateEntity(cashPaymentRequest);
}
