public static Com.Martin.SMS.Data.SMSIncoming SaveIncomingMessage(String Sender, String Receiver, String Message) {
SMSIncoming incoming = new SMSIncoming();
incoming.ID = CreateIdNumber(TypeSMS.Input);
incoming.DateReceive = DateTime.Now;
incoming.Sender = Sender;
incoming.MessageText = Message;
try
{
conn.Open();
MySqlCommand command = conn.CreateCommand();
//if (incoming.ID == "")
//{
command.CommandText = "insert into SMS_INPUT (Id_Input, Tanggal_Terima,No_Pengirim,Pesan_Teks,Status) values ";
command.CommandText += "(?Id_Input, ?Tanggal_Terima,?No_Pengirim,?Pesan_Teks,?Status)";
//}
//else
//{
// command.CommandText = "Update SMS_INPUT set ";
// command.CommandText += "Tanggal_Terima = ?Tanggal_Terima, ";
// command.CommandText += "No_Pengirim = ?No_Pengirim , ";
// command.CommandText += "Pesan_Teks = ?Pesan_Teks , ";
// command.CommandText += "Status = ?Status ";
// command.CommandText += "where ID_INPUT = ?ID_INPUT ";
//}
command.Parameters.Clear();
command.Parameters.AddWithValue("ID_INPUT", incoming.ID);
command.Parameters.AddWithValue("Tanggal_Terima", DateTime.Now.ToString("yyyy-MM-dd"));
command.Parameters.AddWithValue("No_Pengirim", incoming.Sender);
command.Parameters.AddWithValue("Pesan_Teks", incoming.MessageText);
command.Parameters.AddWithValue("Status", "OK");
int rows = command.ExecuteNonQuery();
}
finally
{
conn.Close();
}
return incoming;
}
public static Com.Martin.SMS.Data.SMSIncoming GetIncomingMessage(String ID) {
SMSIncoming inc = new SMSIncoming();
try
{
conn.Open();
MySqlCommand command = conn.CreateCommand();
command.CommandText = "SELECT Id_Input, Tanggal_Terima, No_Pengirim, Pesan_Teks, Status FROM sms_input where ID_INPUT=?ID_INPUT";
command.Parameters.Clear();
command.Parameters.AddWithValue("ID_INPUT", ID);
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
if (!reader.IsDBNull(0))
inc.ID = reader.GetString(0);
if (!reader.IsDBNull(1))
inc.DateReceive = reader.GetDateTime(1);
if (!reader.IsDBNull(2))
inc.Sender = reader.GetString(2);
if (!reader.IsDBNull(3))
inc.MessageText = reader.GetString(3);
}
reader.Close();
}
finally
{
conn.Close();
}
return inc;
}
public static Com.Martin.SMS.Data.SMSIncoming ProcessRequest(Com.Martin.SMS.Data.SMSIncoming Request)
{
return(Request);
}