public void UpdateTransaction(TaskCard taskCard)
{
minorToMajor = new FinancialPlanner.Common.JSONSerialization().DeserializeFromString <MinorToMajor>(taskCard.TaskTransactionType.ToString());
DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_QUERY,
taskCard.Id,
minorToMajor.Arn,
minorToMajor.Cid,
minorToMajor.MinorName,
minorToMajor.Guardian,
minorToMajor.Amc,
minorToMajor.FolioNumber,
minorToMajor.ModeOfExecution,
taskCard.Id), true);
}
private MinorToMajor converToMinorToMajor(DataRow dr)
{
MinorToMajor minorToMajor = new MinorToMajor();
minorToMajor.Id = dr.Field <int>("ID");
minorToMajor.TaskId = dr.Field <int>("TaskId");
minorToMajor.Cid = dr.Field <int>("CID");
minorToMajor.Arn = dr.Field <int>("ARN");
minorToMajor.MinorName = dr.Field <string>("MinorName");
minorToMajor.Guardian = dr.Field <string>("Guardian");
minorToMajor.Amc = dr.Field <int>("AMC");
minorToMajor.FolioNumber = dr.Field <string>("FolioNumber");
minorToMajor.ModeOfExecution = dr.Field <string>("ModeOfExecution");
return(minorToMajor);
}
public object GetTransaction(int id)
{
try
{
Logger.LogInfo("Get: Minor to Major change request transaction process start");
minorToMajor = new MinorToMajor();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_BY_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
minorToMajor = converToMinorToMajor(dr);
}
Logger.LogInfo("Get: Minor to Major change request transaction process completed.");
return(minorToMajor);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
