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();
}
}
