Пример #1
0
 public void DeleteReceivedPRocessRecord(int id, RecievedDataTableAdapter tableAdapter)
 {
     if (id > 0)
     {
         int d = tableAdapter.DeleteQueryById(id);
         if (d > 0)
         {
             Console.WriteLine("Record deleted from parent table...");
         }
     }
 }
Пример #2
0
        public void MoveUnProcessedRecord(int id, RecievedDataTableAdapter tableAdapter)
        {
            if (id > 0)
            {
                _taRecievedDataTableAdapter      = new RecievedDataTableAdapter();
                _taMovedRecievedDataTableAdapter = new MovedRecievedDataTableAdapter();
                _dt = new DataTable();
                _dt = _taRecievedDataTableAdapter.GetDataById(id);

                foreach (DataRow row in _dt.Rows)
                {
                    var dId   = row[0].ToString();
                    var dText = row[1].ToString();
                    var dDate = Convert.ToDateTime(row[2].ToString());
                    int i     = _taMovedRecievedDataTableAdapter.Insert(dText, dDate);
                    if (i > 0)
                    {
                        DeleteReceivedPRocessRecord(Convert.ToInt32(dId), _taRecievedDataTableAdapter);
                    }
                }
            }
        }
Пример #3
0
        public DataTable GetUnParsedMessage()
        {
            int    recId    = 0;
            int    msgType  = 0;
            string unparsed = String.Empty;

            _dt   = new DataTable();
            _rdTa = new RecievedDataTableAdapter();
            _dt   = _rdTa.GetData();
            for (int i = 0; i < _dt.Rows.Count; i++)
            {
                recId = Convert.ToInt32(_dt.Rows[i][0]);
                //split and deserialize xml string
                unparsed = _dt.Rows[i][1].ToString();
                string[] unparsed1 = StringSplit(unparsed, "<EOF>");

                foreach (var s in unparsed1)
                {
                    if (s != "")
                    {
                        string[] s1 = s.Split('|');
                        if (s1.Any())
                        {
                            MsgType  = Convert.ToInt32(s1[0]);
                            MsgValue = s1[1].ToString();
                        }
                        switch (MsgType)
                        {
                        case 1:
                            //TODO: Images message
                            ///ProcessImagesMsg(msg);
                            break;

                        case 2:
                            //TODO: Session message
                            ProcessSessionMsg(MsgValue, recId);
                            break;

                        case 3:
                            //TODO: camera message
                            // ProcessCameraMsg(msg);
                            break;

                        case 4:
                            //TODO: Terminal Provision Message
                            // ProcessTerminalProvisionMsg(msg);
                            break;

                        case 5:
                            //TODO: ProcessCallMaintenanceMessage
                            // ProcessMaintenanceMessage(msg);
                            break;

                        default:
                            Console.WriteLine(@"Unknown function recieved!");
                            break;
                        }
                    }
                }
            }



            return(null);
        }
Пример #4
0
        public DataTable GetUnParsedMessage()
        {
            int    recId    = 0;
            int    msgType  = 0;
            string unparsed = String.Empty;

            _dt   = new DataTable();
            _rdTa = new RecievedDataTableAdapter();
            _dt   = _rdTa.GetData();
            for (int i = 0; i < _dt.Rows.Count; i++)
            {
                try
                {
                    recId = Convert.ToInt32(_dt.Rows[i][0]);
                    //split and deserialize xml string
                    unparsed = _dt.Rows[i][1].ToString();
                    byte[] array = Encoding.ASCII.GetBytes(unparsed);
                    if (array != null && array.Length > 0)
                    {
                        if (!string.IsNullOrEmpty(unparsed) || !string.IsNullOrWhiteSpace(unparsed))
                        {
                            string[] unparsed1 = StringSplit(unparsed, "<EOF>");
                            foreach (var s in unparsed1)
                            {
                                if (s != "")
                                {
                                    string[] s1 = s.Split('|');
                                    if (s1.Any())
                                    {
                                        MsgType  = Convert.ToInt32(s1[0]);
                                        MsgValue = s1[1].ToString();
                                    }
                                    switch (MsgType)
                                    {
                                    case 1:
                                        //TODO: Images message
                                        ///ProcessImagesMsg(msg);
                                        break;

                                    case 2:
                                        //TODO: Session message
                                        ProcessSessionMsg(MsgValue, recId);
                                        break;

                                    case 3:
                                        //TODO: camera message
                                        // ProcessCameraMsg(msg);
                                        break;

                                    case 4:
                                        //TODO: Terminal Provision Message
                                        ProcessTerminalProvisionMsg(MsgValue, recId);
                                        break;

                                    case 5:
                                        //TODO: ProcessCallMaintenanceMessage
                                        // ProcessMaintenanceMessage(msg);
                                        break;

                                    default:
                                        Console.WriteLine(@"Unknown function recieved!");
                                        break;
                                    }
                                }
                            }
                        }
                        else
                        {
                            DeleteRecordFromTable(recId);
                        }
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Err reading dt : " + ex.Message);
                }
            }
            return(null);
        }