public void UpdateTransaction(TaskCard taskCard)
 {
     panCardUpdate = new FinancialPlanner.Common.JSONSerialization().DeserializeFromString <PANCardUpdate>(taskCard.TaskTransactionType.ToString());
     DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_CONTACT,
                                                           taskCard.Id,
                                                           panCardUpdate.Arn,
                                                           panCardUpdate.Cid,
                                                           panCardUpdate.MemberName,
                                                           panCardUpdate.Amc,
                                                           panCardUpdate.FolioNumber,
                                                           panCardUpdate.FirstHolderPAN,
                                                           panCardUpdate.SecondHolderPAN,
                                                           panCardUpdate.ModeOfExecution,
                                                           taskCard.Id), true);
 }
        private PANCardUpdate converToBankchangeRequest(DataRow dr)
        {
            PANCardUpdate contactUpdate = new PANCardUpdate();

            contactUpdate.Id              = dr.Field <int>("ID");
            contactUpdate.TaskId          = dr.Field <int>("TaskId");
            contactUpdate.Cid             = dr.Field <int>("CID");
            contactUpdate.Arn             = dr.Field <int>("ARN");
            contactUpdate.MemberName      = dr.Field <string>("MemberName");
            contactUpdate.Amc             = dr.Field <int>("AMC");
            contactUpdate.FolioNumber     = dr.Field <string>("FolioNumber");
            contactUpdate.FirstHolderPAN  = dr.Field <string>("FirstHolderPAN");
            contactUpdate.SecondHolderPAN = dr.Field <string>("SecondHolderPAN");
            contactUpdate.ModeOfExecution = dr.Field <string>("ModeOfExecution");
            return(contactUpdate);
        }
        public object GetTransaction(int id)
        {
            try
            {
                Logger.LogInfo("Get: PanCard change request transaction process start");
                panCardUpdate = new PANCardUpdate();

                DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_BY_ID, id));
                foreach (DataRow dr in dtAppConfig.Rows)
                {
                    panCardUpdate = converToBankchangeRequest(dr);
                }
                Logger.LogInfo("Get: Pancard change request transaction process completed.");
                return(panCardUpdate);
            }
            catch (Exception ex)
            {
                StackTrace st = new StackTrace();
                StackFrame sf = st.GetFrame(0);
                MethodBase currentMethodName = sf.GetMethod();
                LogDebug(currentMethodName.Name, ex);
                return(null);
            }
        }