public void SaveTransaction(TaskCard taskCard, int id)
{
sipBankChange = new FinancialPlanner.Common.JSONSerialization().DeserializeFromString <SIPBankChange>(taskCard.TaskTransactionType.ToString());
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_QUERY,
id,
sipBankChange.Arn,
sipBankChange.Cid,
sipBankChange.MemberName,
sipBankChange.Amc,
sipBankChange.FolioNumber,
sipBankChange.Scheme,
sipBankChange.Options,
sipBankChange.Amount,
sipBankChange.NewBankId,
sipBankChange.NewBankAccountNo,
sipBankChange.ModeOfExecution,
sipBankChange.Remark), true);
}
private SIPBankChange converToSIPBankChange(DataRow dr)
{
SIPBankChange sipBankChange = new SIPBankChange();
sipBankChange.Id = dr.Field <int>("ID");
sipBankChange.TaskId = dr.Field <int>("TaskId");
sipBankChange.Arn = dr.Field <int>("ARN");
sipBankChange.Cid = dr.Field <int>("CID");
sipBankChange.MemberName = dr.Field <string>("MemberName");
sipBankChange.Amc = dr.Field <int>("AMC");
sipBankChange.FolioNumber = dr.Field <string>("FolioNumber");
sipBankChange.Scheme = dr.Field <int>("SchemeId");
sipBankChange.Options = dr.Field <string>("Option");
sipBankChange.Amount = dr.Field <long>("Amount");
sipBankChange.NewBankId = dr.Field <int>("NewBankId");
sipBankChange.NewBankAccountNo = dr.Field <string>("NewBankAccountNo");
sipBankChange.ModeOfExecution = dr.Field <string>("ModeOfExecution");
sipBankChange.Remark = dr.Field <string>("Remark");
return(sipBankChange);
}
public object GetTransaction(int id)
{
try
{
Logger.LogInfo("Get: Fresh purchase transaction process start");
SIPBankChange sip = new SIPBankChange();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_BY_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
sip = converToSIPBankChange(dr);
}
Logger.LogInfo("Get: Fresh purchase transaction process completed.");
return(sip);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
