public Message Set_LOAN_WO(AST_LOAN_WO_STATUS_TEMP loan_wo, AppSession session) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } var response = fileProcessRepository.Set_LOAN_WO(loan_wo, session.User.user_id); if (response.pvc_status == "40999") { MessageHelper.Success(Message, "Data process successfully...."); } else { MessageHelper.Error(Message, response.pvc_statusmsg); } } catch (Exception ex) { Logging.WriteToErrLog(session.User.StationIp, session.User.user_id, "FileProcessManager-Set_LOAN_WO", ex.Message + "|" + ex.StackTrace.TrimStart()); MessageHelper.Error(Message, ex.Message); } finally { Connection.Close(); } return(Message); }
public IActionResult Index(string loanNumber = null) { var loanwo = new AST_LOAN_WO_STATUS_TEMP(); if (loanNumber != null) { loanwo = fileProcessManager.Getloanwo(loanNumber, "", "", "", Session).FirstOrDefault(); } ViewBag.LoanWo = loanwo; return(View()); }
public ResponseMessage Set_LOAN_WO(AST_LOAN_WO_STATUS_TEMP loan_wo, string pvc_appuser) { var responseMessage = new ResponseMessage(); var dyParam = new OracleDynamicParameters(); dyParam.Add("pvc_area_code", loan_wo.AREA_CODE, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_branch_code", loan_wo.BRANCH_CODE, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_osamount", loan_wo.OS_AMOUNT, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_woamount", loan_wo.WO_AMOUNT, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_wodate", loan_wo.WO_DATE.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture), OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_seg_id", loan_wo.SEG_ID, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_loan_number", loan_wo.LOAN_AC_NUMBER, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_product_code", loan_wo.PRODUCT_CODE, OracleMappingType.Varchar2, ParameterDirection.Input, 20); dyParam.Add("pvc_appuser", pvc_appuser, OracleMappingType.Varchar2, ParameterDirection.Input, 50); dyParam.Add("pvc_status", 0, OracleMappingType.Varchar2, ParameterDirection.Output, 5); dyParam.Add("pvc_statusmsg", 0, OracleMappingType.Varchar2, ParameterDirection.Output, 255); var res = responseMessage.QueryExecute(Connection, "pkg_asset_manager.dpd_set_loan_wo", dyParam); return(res); }
public IActionResult SubmitLoanWo(AST_LOAN_WO_STATUS_TEMP wo) { var message = fileProcessManager.Set_LOAN_WO(wo, Session); return(Json(message)); }
private Message Process_LOAN_WO(string filepath, AppSession session, string tableName, int businessYear) { try { if (Connection.State != ConnectionState.Open) { Connection.Open(); } fileProcessRepository.DeleteTable(tableName, session.User.user_id); var random = new Random(); var fileProcessID = random.Next(10000); using (var package = new ExcelPackage(new FileInfo(@filepath))) { var totalWorkSheet = package.Workbook.Worksheets.Count; var isProcess = true; for (var index = 1; index <= totalWorkSheet; index++) { var wooksheet = package.Workbook.Worksheets[index]; var xx = wooksheet.Name; int rowCount = wooksheet.Dimension.Rows; int columnCount = wooksheet.Dimension.Columns; for (var i = 1; i <= 1; i++) { for (var j = 1; j <= columnCount; j++) { if (wooksheet.Cells[i, j].Text.Trim() == null && !ExcelColumn.LOAN_WO.Contains(wooksheet.Cells[i, j].Text.Trim())) { isProcess = false; } } } if (isProcess) { var portFolios = new List <AST_LOAN_WO_STATUS_TEMP>(); for (var i = 2; i <= rowCount; i++) { var portFolio = new AST_LOAN_WO_STATUS_TEMP { File_Process_ID = fileProcessID, SEG_ID = wooksheet.Cells[i, 1].Text.Trim(), SEG_NAME = wooksheet.Cells[i, 2].Text.Trim(), AREA_CODE = wooksheet.Cells[i, 3].Text.Trim(), AREA_NAME = wooksheet.Cells[i, 4].Text.Trim(), BRANCH_CODE = wooksheet.Cells[i, 5].Text.Trim(), BRANCH_NAME = wooksheet.Cells[i, 6].Text.Trim(), LOAN_AC_NUMBER = wooksheet.Cells[i, 7].Text.Trim(), PRODUCT_CODE = wooksheet.Cells[i, 8].Text.Trim(), PRODUCT_DESC = wooksheet.Cells[i, 9].Text.Trim(), OS_AMOUNT = valid(wooksheet.Cells[i, 10].Text.Trim(), "LOAN_OUTSTANDING", "Number"), WO_AMOUNT = valid(wooksheet.Cells[i, 11].Text.Trim(), "WO_AMOUNT", "Number"), WO_DATE = Convert.ToDateTime(wooksheet.Cells[i, 12].Text.Trim()), INS_BY = session.User.user_id, INS_DATE = DateTime.Now }; portFolios.Add(portFolio); } if (portFolios.Count > 0) { var row = fileProcessRepository.Process_LOAN_WO(portFolios); if (row > 0) { var response = fileProcessRepository.SetProcess_LOAN_WO(fileProcessID, businessYear, session.User.user_id); if (response.pvc_status == "40999") { MessageHelper.Success(Message, "Data upload and process successfully...."); } else { MessageHelper.Error(Message, response.pvc_statusmsg); } } else { MessageHelper.Error(Message, "No data process..."); } } else { MessageHelper.Error(Message, "No rows found this excel file."); } } else { MessageHelper.Error(Message, "File structure is not valid. Invalid Columns."); } } } } catch (Exception ex) { Logging.WriteToErrLog(session.User.StationIp, session.User.user_id, "FileProcessManager-Process_LOAN_WO", ex.Message + "|" + ex.StackTrace.TrimStart()); MessageHelper.Error(Message, ex.Message); } finally { Connection.Close(); } return(Message); }