Help in C#

[giousouf]

Hi,

I'm working an app in C# and SQL.The project is about managing messages received from a certain device, storing them in the SIM card of a GSM modem and a spesific table of a database.The app works fine.The problem is that I can't delete the incoming messages from the sim card right after they are saved in the database.Can anyone give any advise? The code of the "main" form is the following:


using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using GsmComm.GsmCommunication;
using GsmComm.PduConverter;
using System.Threading;
using System.Text.RegularExpressions;
using System.Data.SqlClient;



namespace SMS
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{

private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.Label lbl_phone_status;
private System.Windows.Forms.TextBox txtOutput;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.MenuItem mnu_send;
private System.Windows.Forms.MenuItem mnu_read;
private delegate void SetTextCallback(string text);
private CommSetting comm_settings=new CommSetting();
private System.Windows.Forms.MenuItem mnudelete;
private System.Windows.Forms.Timer timer1;
private IContainer components;

public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();

//
// TODO: Add any constructor code after InitializeComponent call
//
}

/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.mainMenu1 = new System.Windows.Forms.MainMenu(this.components);
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.mnu_send = new System.Windows.Forms.MenuItem();
this.mnu_read = new System.Windows.Forms.MenuItem();
this.mnudelete = new System.Windows.Forms.MenuItem();
this.lbl_phone_status = new System.Windows.Forms.Label();
this.txtOutput = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.timer1 = new System.Windows.Forms.Timer(this.components);
this.SuspendLayout();
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_send,
this.mnu_read,
this.mnudelete});
this.menuItem1.Text = "Message";
//
// mnu_send
//
this.mnu_send.Index = 0;
this.mnu_send.Text = "Send";
this.mnu_send.Click += new System.EventHandler(this.mnu_send_click);
//
// mnu_read
//
this.mnu_read.Index = 1;
this.mnu_read.Text = "Read";
this.mnu_read.Click += new System.EventHandler(this.mnu_read_click);
//
// mnudelete
//
this.mnudelete.Index = 2;
this.mnudelete.Text = "Delete";
this.mnudelete.Click += new System.EventHandler(this.mnudelete_Click);
//
// lbl_phone_status
//
this.lbl_phone_status.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
this.lbl_phone_status.BackColor = System.Drawing.Color.White;
this.lbl_phone_status.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.lbl_phone_status.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.lbl_phone_status.ForeColor = System.Drawing.Color.Red;
this.lbl_phone_status.Location = new System.Drawing.Point(360, 368);
this.lbl_phone_status.Name = "lbl_phone_status";
this.lbl_phone_status.Size = new System.Drawing.Size(196, 23);
this.lbl_phone_status.TabIndex = 54;
this.lbl_phone_status.Text = "NO PHONE CONNECTED";
this.lbl_phone_status.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
this.lbl_phone_status.UseMnemonic = false;
//
// txtOutput
//
this.txtOutput.Enabled = false;
this.txtOutput.Location = new System.Drawing.Point(88, 72);
this.txtOutput.Multiline = true;
this.txtOutput.Name = "txtOutput";
this.txtOutput.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;
this.txtOutput.Size = new System.Drawing.Size(472, 272);
this.txtOutput.TabIndex = 55;
//
// label1
//
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.Location = new System.Drawing.Point(88, 40);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(104, 24);
this.label1.TabIndex = 56;
this.label1.Text = "Received SMS :";
//
// timer1
//
this.timer1.Interval = 15000;
this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(656, 417);
this.Controls.Add(this.label1);
this.Controls.Add(this.txtOutput);
this.Controls.Add(this.lbl_phone_status);
this.Menu = this.mainMenu1;
this.Name = "Form1";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "SMS Server";
this.Load += new System.EventHandler(this.Form1_Load);
this.Closing += new System.ComponentModel.CancelEventHandler(this.Form1_Closing);
this.ResumeLayout(false);
this.PerformLayout();

}
#endregion

/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}


private void Form1_Load(object sender, System.EventArgs e)
{
// Prompt user for connection settings
int port = GsmCommMain.DefaultPortNumber;
int baudRate = 9600; // We Set 9600 as our Default Baud Rate
int timeout = GsmCommMain.DefaultTimeout;

frmConnection dlg = new frmConnection();
dlg.StartPosition = FormStartPosition.CenterScreen;
dlg.SetData(port, baudRate, timeout);
timer1.Enabled = true;
if (dlg.ShowDialog(this) == DialogResult.OK)
{
dlg.GetData(out port, out baudRate, out timeout);
CommSetting.Comm_Port=port;
CommSetting.Comm_BaudRate=baudRate;
CommSetting.Comm_TimeOut=timeout;
}
else
{
Close();
return;
}

Cursor.Current = Cursors.WaitCursor;
CommSetting.comm = new GsmCommMain(port, baudRate, timeout);
Cursor.Current = Cursors.Default;
CommSetting.comm.PhoneConnected += new EventHandler(comm_PhoneConnected);
CommSetting.comm.MessageReceived+=new MessageReceivedEventHandler(comm_MessageReceived);

bool retry;
do
{
retry = false;
try
{
Cursor.Current = Cursors.WaitCursor;
CommSetting.comm.Open();
Cursor.Current = Cursors.Default;
}
catch(Exception)
{
Cursor.Current = Cursors.Default;
if (MessageBox.Show(this, "Unable to open the port.", "Error",
MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning) == DialogResult.Retry)
retry = true;
else
{
Close();
return;
}
}
}
while(retry);

}


private delegate void ConnectedHandler(bool connected);

private void OnPhoneConnectionChange(bool connected)
{
lbl_phone_status.Text="CONNECTED";
}


private void comm_MessageReceived(object sender, GsmComm.GsmCommunication.MessageReceivedEventArgs e)
{
MessageReceived();
}

private void comm_PhoneConnected(object sender, EventArgs e)
{
this.Invoke(new ConnectedHandler(OnPhoneConnectionChange), new object[] { true });
}


private string GetMessageStorage()
{
string storage = string.Empty;
storage = PhoneStorageType.Sim;

if (storage.Length == 0)
throw new ApplicationException("Unknown message storage.");
else
return storage;
}


private void MessageReceived()
{
Cursor.Current = Cursors.WaitCursor;
string storage = GetMessageStorage();

DecodedShortMessage[] messages = CommSetting.comm.ReadMessages(PhoneMessageStatus.ReceivedUnread, storage);
foreach(DecodedShortMessage message in messages)
{
Output(string.Format("Message status = {0}, Location = {1}/{2}",
StatusToString(message.Status), message.Storage, message.Index));
//ShowMessage(message.Data);
Output("");
}

Output(string.Format("{0,9} messages read.", messages.Length.ToString()));
Output("");

}


private string StatusToString(PhoneMessageStatus status)
{
// Map a message status to a string
string ret;
switch(status)
{
case PhoneMessageStatus.All:
ret = "All";
break;
case PhoneMessageStatus.ReceivedRead:
ret = "Read";
break;
case PhoneMessageStatus.ReceivedUnread:
ret = "Unread";
break;
case PhoneMessageStatus.StoredSent:
ret = "Sent";
break;
case PhoneMessageStatus.StoredUnsent:
ret = "Unsent";
break;
default:
ret = "Unknown (" + status.ToString() + ")";
break;
}
return ret;
}


private void Output(string text)
{
if (this.txtOutput.InvokeRequired)
{
SetTextCallback stc = new SetTextCallback(Output);
this.Invoke(stc, new object[] { text });
}
else
{
txtOutput.AppendText(text);
txtOutput.AppendText("\r\n");
}
}


private void ShowMessage(SmsPdu pdu, object sender)
{
if (pdu is SmsSubmitPdu)
{
// Stored (sent/unsent) message
SmsSubmitPdu data = (SmsSubmitPdu)pdu;
Output("SENT/UNSENT MESSAGE");
Output("Recipient: " + data.DestinationAddress);
Output("Message text: " + data.UserDataText);
Output("-------------------------------------------------------------------");
return;
}
if (pdu is SmsDeliverPdu)
{
// Received message
SmsDeliverPdu data = (SmsDeliverPdu)pdu;
Output("RECEIVED MESSAGE");
Output("Sender: " + data.OriginatingAddress);
Output("Sent: " + data.SCTimestamp.ToString());
Output("Message text: " + data.UserDataText);
Output("-------------------------------------------------------------------");

// send to db2

data = (SmsDeliverPdu)pdu;
string s = data.UserDataText;
string p = data.SCTimestamp.ToString();
string g = data.OriginatingAddress.ToString();
string[] words = s.Split(';', ',');
foreach (string word in words)
{
SqlConnection myConnection = new SqlConnection(@"Network Library=DBMSSOCN;user id=sa;
password=******;server=CSOPER3\SQLEXPRESS;
Trusted_Connection=yes;
database=My_Test1;
connection timeout=30;");
try
{
myConnection.Open();

}
catch (SqlException e)
{
Console.WriteLine(e.Message);
throw e;

}

{
SqlCommand myCommand = new SqlCommand("INSERT INTO db2 (sender,time,ID,IMEI,LOCAL_TIME,LOCAL_DATE,BATTERY,LAT,LON,ANGLE,SATELLITE,ALARM_ON,KEY_ID) " +
"values('" + g + "','" + p + "','" + words[0] + "','" + words[1] + "','" + words[2] + "','" + words[3] + "','" + words[4] + "','" + words[5] + "','" + words[6] + "','" + words[7] + "','" + words[8] + "','" + words[9] + "','" + words[10] + "')", myConnection);


myCommand.Connection = myConnection;

myCommand.ExecuteNonQuery();


try
{
myConnection.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);

throw e;
}

}

}

if (pdu is SmsStatusReportPdu)
{
// Status report
SmsStatusReportPdu data = (SmsStatusReportPdu)pdu;
Output("STATUS REPORT");
Output("Recipient: " + data.RecipientAddress);
Output("Status: " + data.Status.ToString());
Output("Timestamp: " + data.DischargeTime.ToString());
Output("Message ref: " + data.MessageReference.ToString());
Output("-------------------------------------------------------------------");
return;
}
Output("Unknown message type: " + pdu.GetType().ToString());
}

private void mnu_send_click(object sender, System.EventArgs e)
{
Send send_sms=new Send();
send_sms.Show();
}


private void mnu_read_click(object sender, System.EventArgs e)
{
Receive receice_sms=new Receive();
receice_sms.Show();
}


private void Form1_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
// Clean up comm object
if (CommSetting.comm != null)
{
// Unregister events
CommSetting.comm.PhoneConnected -= new EventHandler(comm_PhoneConnected);
CommSetting.comm.MessageReceived -= new MessageReceivedEventHandler(comm_MessageReceived);

// Close connection to phone
if (CommSetting.comm != null && CommSetting.comm.IsOpen())
CommSetting.comm.Close();

CommSetting.comm = null;
}
}

private void mnudelete_Click(object sender, System.EventArgs e)
{
Delete delete=new Delete();
delete.Show();
}

private void timer1_Tick(object sender, EventArgs e)
{
MessageReceived();
}

}
}


Thanks!