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..."); } } }
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); } } } }
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); }
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); }