public async Task <JsonResult> FillMaintData(string batchId, string statementDate) { var maintData = new PukalAcctMaintInfo(); var pkPaymentSelect = await objPukalAcctOps.GetPukapaymentSelect(Convert.ToInt32(batchId)); if (pkPaymentSelect.Owner != null) { maintData.ChequeAmt = pkPaymentSelect.ChequeAmt; maintData.ChequeNo = pkPaymentSelect.ChequeNo; maintData.SelectedTxnCd = pkPaymentSelect.TxnCd; maintData.SelectedSettlement = pkPaymentSelect.GLSettlement; maintData.SelectedOwner = pkPaymentSelect.Owner; maintData.CreationDate = pkPaymentSelect.TxnDate; maintData.StatementDate = pkPaymentSelect.StmtDate; maintData.AcctOfficeCd = pkPaymentSelect.AcctOfficeCd; maintData.RefCd = pkPaymentSelect.RefCd; maintData.CycStmtId = pkPaymentSelect.CycStmtId; maintData.Sts = pkPaymentSelect.Sts; maintData.SlipNo = pkPaymentSelect.SlipNo; maintData.SelectedIssBank = pkPaymentSelect.IssBank; } else { maintData.SelectedTxnCd = string.Empty; maintData.SelectedSettlement = string.Empty; maintData.SelectedOwner = BaseClass.GetClaimsInfo("userid"); maintData.CreationDate = DateTime.Now.ToString("dd/MM/yyyy"); maintData.StatementDate = statementDate; maintData.CycStmtId = 0; maintData.ChequeNo = 0; maintData.Sts = "A"; maintData.SlipNo = string.Empty; maintData.SelectedIssBank = string.Empty; } maintData.BatchId = int.Parse(batchId); var maintSelects = new PukalAcctMaintInfo { TxnCd = await BaseService.WebGetTxnCode("I", "PaymtTxnCategoryMapInd", "Y"), Owner = await BaseClass.WebUserAccessListSelect(), GLSettlement = await BaseClass.WebGetRefLib("GLSettlement"), IssBank = await BaseClass.WebGetRefLib("Bank") }; // remove upper case if (maintSelects.Owner.Count() > 0) { for (int i = 1; i < maintSelects.Owner.Count(); i++) { maintSelects.Owner.ToList()[i].Text = maintSelects.Owner.ToList()[i].Text.ToLower(); maintSelects.Owner.ToList()[i].Value = maintSelects.Owner.ToList()[i].Value.ToLower(); } } return(Json(new { Model = maintData, Selects = maintSelects }, JsonRequestBehavior.AllowGet)); }
public async Task <JsonResult> FillData(string Prefix) { switch (Prefix.ToLower()) { case "gen": var genData = new PukalAcctMaintInfo(); var genSelects = new PukalAcctInfo { AreaCode = await BaseService.GetRefLib("AcctOfficeCd", null, null, null, false), RefCd = await BaseService.GetRefLib("PaymtInfoType", null, null, null, false), StmDate = (await BaseService.GetCycleStmt(null)).RefLibLst, IssBank = await BaseService.GetRefLib("Bank") }; return(Json(new { Model = genData, Selects = genSelects }, JsonRequestBehavior.AllowGet)); default: HttpContext.Response.StatusCode = 404; return(Json(null, JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> FTWebTxnPukalPaymentMaint(PukalAcctMaintInfo obj) { var _TraceInfo = await objPukalAcctOps.SavePukalAcctEdits(obj); return(Json(new { result = _TraceInfo }, JsonRequestBehavior.AllowGet)); }
public async Task <MsgRetriever> SavePukalAcctEdits(PukalAcctMaintInfo listInfo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); var userid = ClaimsPrincipal.Current.Identities.First(); SqlParameter[] Parameters = new SqlParameter[16]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = new SqlParameter("@Func", listInfo.Func); if (listInfo.BatchId == 0) { Parameters[2] = new SqlParameter("@BatchId", SqlDbType.BigInt); Parameters[2].Direction = ParameterDirection.Output; } else { Parameters[2] = new SqlParameter("@BatchId", listInfo.BatchId); Parameters[2].Direction = ParameterDirection.Input; } Parameters[3] = new SqlParameter("@RefCd", listInfo.RefCd); Parameters[4] = new SqlParameter("@AcctOfficeCd", listInfo.AcctOfficeCd); Parameters[5] = !string.IsNullOrEmpty(listInfo.SelectedTxnCd)? new SqlParameter("@TxnCd", listInfo.SelectedTxnCd): new SqlParameter("@TxnCd", DBNull.Value); Parameters[6] = !string.IsNullOrEmpty(listInfo.SelectedSettlement) ? new SqlParameter("@GLSettlement", listInfo.SelectedSettlement) : new SqlParameter("@GLSettlement", DBNull.Value); Parameters[7] = new SqlParameter("@CycStmtId", listInfo.CycStmtId); Parameters[8] = new SqlParameter("@ChequeNo", listInfo.ChequeNo); Parameters[9] = new SqlParameter("@ChequeAmt", Convert.ToDecimal(listInfo.ChequeAmt)); Parameters[10] = listInfo.Func == "Save" ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", listInfo.SelectedOwner); Parameters[11] = !string.IsNullOrEmpty(userid.Name) ? new SqlParameter("@UserId", userid.Name) : new SqlParameter("@UserId", DBNull.Value); DataTable dt = new DataTable(); dt.Columns.Add("AcctNo"); dt.Columns.Add("TxnDate"); dt.Columns.Add("DueDate"); dt.Columns.Add("Amt"); dt.Columns.Add("Descp"); if (listInfo.MultipleTxnRecord != null) { foreach (var item in listInfo.MultipleTxnRecord) { DataRow dr = dt.NewRow(); dr["AcctNo"] = item.AcctNo; dr["TxnDate"] = ConvertDatetimeDB(listInfo.CreationDate); dr["DueDate"] = ConvertDatetimeDB(listInfo.CreationDate); dr["Amt"] = Convert.ToDecimal(item.PaymentAmt); dr["Descp"] = DBNull.Value; dt.Rows.Add(dr); } } Parameters[12] = new SqlParameter("@PukalPayment", dt); Parameters[13] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[13].Direction = ParameterDirection.ReturnValue; Parameters[14] = !string.IsNullOrEmpty(listInfo.SlipNo) ? new SqlParameter("@SlipNo", listInfo.SlipNo) : new SqlParameter("@SlipNo", DBNull.Value); Parameters[15] = !string.IsNullOrEmpty(listInfo.SelectedIssBank) ? new SqlParameter("@IssBank", listInfo.SelectedIssBank) : new SqlParameter("@IssBank", DBNull.Value); var execResult = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnPukalPaymentMaint", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(execResult.Parameters["@RETURN_VALUE"].Value); var Descp = await GetMessageCode(Result); if (listInfo.BatchId == 0) { Descp.Id = Convert.ToInt32(execResult.Parameters["@BatchId"].Value).ToString(); } return(Descp); }catch (Exception ex) { objDataEngine.CloseConnection(); throw ex; } finally { objDataEngine.CloseConnection(); } }