public vAdvanceRequestApplication GetAdvanceRequestViewDbRecord(int AdvRequestID) { vAdvanceRequestApplication model = null; try { model = _dbContext.vAdvanceRequestApplications.Where(x => x.PK_AdvancRequestID == AdvRequestID).FirstOrDefault(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceAdvanceRequest::GetAdvanceRequestViewDbRecord", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
private void frmApproveRejectAdvanceRequest_Load(object sender, EventArgs e) { try { ServiceAdvanceRequest service = new ServiceAdvanceRequest(); vAdvanceRequestApplication model = service.GetAdvanceRequestViewDbRecord(this.AdvanceRequestID); if (model != null) { txtAdvanceRequestNo.Text = string.Format("{0} dt. {1}", model.AdvanceRequestNo, model.RequestDate.ToString("dd MMM yy")); dtApprovalDate.Value = model.RequestDate; txtAdvanceRequestDescription.Text = model.EmployeeName; txtAdvanceRequestDescription.Text += string.Format("\nAmount: {0:0.00}\nRemarks: {1}", model.RequestedAmount, model.Remarks); if (model.ApprovalStatus == service.REQUEST_STATUS_APPROVED_ID) { rbtnApproveAdvanceRequest.Checked = true; } if (model.ApprovalStatus == service.REQUEST_STATUS_REJECTED_ID) { rbtnRejectAdvanceRequest.Checked = true; } txtApprovedAmount.Text = model.ApprovedAmount.ToString(); txtApprovalRemarks.Text = model.RemarksApproved; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "frmApproveRejectAdvanceRequest::frmApproveRejectAdvanceRequest_Load", MessageBoxButtons.OK, MessageBoxIcon.Error); } }