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