public void SaveOrUpdateTARequest()
{
TravelAdvanceRequest TravelAdvanceRequest = CurrentTravelAdvanceRequest;
TravelAdvanceRequest.TravelAdvanceNo = View.GetRequestNo;
TravelAdvanceRequest.RequestDate = View.GetRequestDate;
TravelAdvanceRequest.VisitingTeam = View.GetVisitingTeam;
TravelAdvanceRequest.PurposeOfTravel = View.GetPurposeOfTravel;
TravelAdvanceRequest.Comments = View.GetComments;
TravelAdvanceRequest.ProgressStatus = ProgressStatus.InProgress.ToString();
TravelAdvanceRequest.ExportStatus = "Not Exported";
TravelAdvanceRequest.AppUser = _adminController.GetUser(CurrentUser().Id);
if (View.GetProjectId != 0)
{
TravelAdvanceRequest.Project = _settingController.GetProject(View.GetProjectId);
}
if (View.GetGrantId != 0)
{
TravelAdvanceRequest.Grant = _settingController.GetGrant(View.GetGrantId);
}
if (CurrentTravelAdvanceRequest.TravelAdvanceRequestStatuses.Count == 0)
{
SaveTravelAdvanceRequestStatus();
}
GetCurrentApprover();
_controller.SaveOrUpdateEntity(TravelAdvanceRequest);
_controller.CurrentObject = null;
}
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;
}
}
}
}
protected void grvTravelAdvanceRequestList_RowDataBound(object sender, GridViewRowEventArgs e)
{
Button btnStatus = e.Row.FindControl("btnStatus") as Button;
TravelAdvanceRequest TAR = e.Row.DataItem as TravelAdvanceRequest;
if (TAR != null)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (TAR.ProgressStatus == ProgressStatus.InProgress.ToString())
{
btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFF6C");
}
else if (TAR.TravelAdvanceRequestStatuses.Last().ApprovalStatus == "Bank Payment" && !IsBankPaymentRequested(TAR.Id) && TAR.CurrentStatus != ApprovalStatus.Rejected.ToString())
{
btnStatus.BackColor = System.Drawing.Color.Green;
}
else if (TAR.ProgressStatus == ProgressStatus.Completed.ToString())
{
btnStatus.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF7251");
}
if (ddlSrchProgressStatus.SelectedValue == "Reviewed")
{
e.Row.Cells[9].Enabled = false;
}
}
}
}
private void UpdateExportStatus(DataTable dt)
{
foreach (DataRow DR in dt.Rows)
{
TravelAdvanceRequest Request = _presenter.GetTravelAdvanceRequestRequest(DR.Field <string>("RefNumber"));
Request.ExportStatus = "Exported";
_presenter.UpdateTravelAdvanceRequestExportStatus(Request);
}
}
private void PrintTransaction()
{
TravelAdvanceRequest taRequest = _presenter.GetTravelAdvanceRequest(_presenter.CurrentExpenseLiquidationRequest.Id);
lblRequestNoResult.Text = taRequest.TravelAdvanceNo;
lblRequestedDateResult.Text = _presenter.CurrentExpenseLiquidationRequest.RequestDate.Value.ToShortDateString();
lblRequesterResult.Text = taRequest.AppUser.FullName;
lblPurposeofAdvanceResult.Text = _presenter.CurrentExpenseLiquidationRequest.Comment.ToString();
lblApprovalStatusResult.Text = _presenter.CurrentExpenseLiquidationRequest.ProgressStatus.ToString();
lblArrRetTimeResult.Text = _presenter.CurrentExpenseLiquidationRequest.ArrivalDateTime + " - " + _presenter.CurrentExpenseLiquidationRequest.ReturnDateTime;
grvDetails.DataSource = _presenter.CurrentExpenseLiquidationRequest.ExpenseLiquidationRequestDetails;
grvDetails.DataBind();
grvStatuses.DataSource = _presenter.CurrentExpenseLiquidationRequest.ExpenseLiquidationRequestStatuses;
grvStatuses.DataBind();
}
protected void grvTravelAdvanceRequestList_RowDataBound(object sender, GridViewRowEventArgs e)
{
Button btnStatus = e.Row.FindControl("btnStatus") as Button;
TravelAdvanceRequest CSR = e.Row.DataItem as TravelAdvanceRequest;
if (CSR != null)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
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");
}
}
}
}
private void PrintTransaction()
{
//pnlApproval_ModalPopupExtender.Hide();
TravelAdvanceRequest taRequest = _presenter.GetTravelAdvanceRequest(_presenter.CurrentExpenseLiquidationRequest.Id);
lblRequestNoResult.Text = taRequest.TravelAdvanceNo;
lblRequestedDateResult.Text = _presenter.CurrentExpenseLiquidationRequest.RequestDate.Value.ToShortDateString();
if (_presenter.CurrentExpenseLiquidationRequest.TravelAdvRequestDate != null)
{
lblTravelAdvReqDateResult.Text = _presenter.CurrentExpenseLiquidationRequest.TravelAdvRequestDate.Value.ToShortDateString();
}
lblRequesterResult.Text = taRequest.AppUser.FullName;
//lblExpenseTypeResult.Text = _presenter.CurrentExpenseLiquidationRequest.ExpenseType.ToString();
lblPurposeofAdvanceResult.Text = _presenter.CurrentExpenseLiquidationRequest.Comment.ToString();
lblApprovalStatusResult.Text = _presenter.CurrentExpenseLiquidationRequest.ProgressStatus.ToString();
//lblRetirmentTypeResult.Text = _presenter.CurrentExpenseLiquidationRequest.ExpenseReimbersmentType;
lblRetirmenNoResult.Text = _presenter.CurrentExpenseLiquidationRequest.ReimbersmentNo;
grvDetails.DataSource = _presenter.CurrentExpenseLiquidationRequest.ExpenseLiquidationRequestDetails;
grvDetails.DataBind();
grvStatuses.DataSource = _presenter.CurrentExpenseLiquidationRequest.ExpenseLiquidationRequestStatuses;
grvStatuses.DataBind();
}
public void UpdateTravelAdvanceRequestExportStatus(TravelAdvanceRequest TravelAdvanceRequest)
{
_controller.SaveOrUpdateEntity(TravelAdvanceRequest);
}
public void DeleteTravelAdvanceRequest(TravelAdvanceRequest TravelAdvanceRequest)
{
_controller.DeleteEntity(TravelAdvanceRequest);
}
public void SaveOrUpdateTARequest(TravelAdvanceRequest TravelAdvanceRequest)
{
_controller.SaveOrUpdateEntity(TravelAdvanceRequest);
}
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);
}
}
}
}
}
}
}
}
