public void SaveTransaction(TaskCard taskCard, int id)
{
bankChangeRequest = new FinancialPlanner.Common.JSONSerialization().DeserializeFromString <BankChangeRequest>(taskCard.TaskTransactionType.ToString());
bankChangeRequest.TaskId = id;
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_BANKCHANGEREQUEST,
bankChangeRequest.TaskId,
bankChangeRequest.Arn,
bankChangeRequest.Cid,
bankChangeRequest.MemberName,
bankChangeRequest.Amc,
bankChangeRequest.FolioNumber,
bankChangeRequest.OldBankId,
bankChangeRequest.OldBankAcNo,
bankChangeRequest.NewBankId,
bankChangeRequest.NewBankAcNo,
bankChangeRequest.ModeOfExecution), true);
}
private BankChangeRequest converToBankchangeRequest(DataRow dr)
{
BankChangeRequest bankChangeRequest = new BankChangeRequest();
bankChangeRequest.Id = dr.Field <int>("ID");
bankChangeRequest.TaskId = dr.Field <int>("TaskId");
bankChangeRequest.Cid = dr.Field <int>("CID");
bankChangeRequest.Arn = dr.Field <int>("ARN");
bankChangeRequest.MemberName = dr.Field <string>("MemberName");
bankChangeRequest.Amc = dr.Field <int>("AMC");
bankChangeRequest.FolioNumber = dr.Field <string>("FolioNumber");
bankChangeRequest.OldBankId = dr.Field <int>("OldBankId");
bankChangeRequest.OldBankAcNo = dr.Field <string>("OldBankAccountNo");
bankChangeRequest.NewBankId = dr.Field <int>("NewBankId");
bankChangeRequest.NewBankAcNo = dr.Field <string>("NewBankAccountNo");
bankChangeRequest.ModeOfExecution = dr.Field <string>("ModeOfExecution");
return(bankChangeRequest);
}
public object GetTransaction(int id)
{
try
{
Logger.LogInfo("Get: Bank change request transaction process start");
bankChangeRequest = new BankChangeRequest();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_BY_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
bankChangeRequest = converToBankchangeRequest(dr);
}
Logger.LogInfo("Get: Bank change request transaction process completed.");
return(bankChangeRequest);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
