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