public DeviceModel GetModemConfig(int id, string initial) { try { var data = DBConnService.Select("SELECT id, initial, mode, protocol, comm_port, bit_rate, send_timeout, send_interval, retry_times, " + "sms_validity, folder, auto_reject_incoming_call, send_reject_incoming_call, message_reject_incoming_call, " + "request_send_report, auto_delete_new_sms, auto_delete_all_report, is_proses_schedule, is_proses_new_sms, " + "is_no_prefix, pesan_no_prefix, sms_type, wap_push_url, nomor_cek_pulsa, keterangan, status, waktu_cek_schedule, waktu_cek_pesan_pending, waktu_cek_koneksi, cek_pesan_masuk From sms_modem " + "WHERE id = " + id + " AND initial = '" + initial + "'"); foreach (var row in data) { if (row != null) { deviceModel.id = (int)row["id"]; deviceModel.initial = row["initial"].ToString(); deviceModel.mode = row["mode"].ToString(); deviceModel.protocol = row["protocol"].ToString(); deviceModel.comm_port = (int)row["comm_port"]; deviceModel.bit_rate = (int)row["bit_rate"]; deviceModel.send_timeout = (int)row["send_timeout"]; deviceModel.send_interval = (int)row["send_interval"]; deviceModel.retry_times = (int)row["retry_times"]; deviceModel.sms_validity = row["sms_validity"].ToString(); deviceModel.folder = row["folder"].ToString(); deviceModel.auto_reject_incoming_call = bool.Parse(row["auto_reject_incoming_call"].ToString()) ? 1 : 0; deviceModel.send_reject_incoming_call = bool.Parse(row["send_reject_incoming_call"].ToString()) ? 1 : 0; deviceModel.message_reject_incomming_call = row["message_reject_incoming_call"].ToString(); deviceModel.request_send_report = bool.Parse(row["request_send_report"].ToString()) ? 1 : 0; deviceModel.auto_delete_new_sms = bool.Parse(row["auto_delete_new_sms"].ToString()) ? 1 : 0; deviceModel.auto_delete_all_report = bool.Parse(row["auto_delete_all_report"].ToString()) ? 1 : 0; deviceModel.is_proses_schedule = bool.Parse(row["is_proses_schedule"].ToString()) ? 1 : 0; deviceModel.is_proses_new_sms = bool.Parse(row["is_proses_new_sms"].ToString()) ? 1 : 0; deviceModel.is_no_prefix = bool.Parse(row["is_no_prefix"].ToString()) ? 1 : 0; deviceModel.pesan_no_prefix = row["pesan_no_prefix"].ToString(); deviceModel.sms_type = row["sms_type"].ToString(); deviceModel.wap_push_url = row["wap_push_url"].ToString(); deviceModel.nomor_cek_pulsa = row["nomor_cek_pulsa"].ToString(); deviceModel.keterangan = row["keterangan"].ToString(); deviceModel.status = bool.Parse(row["status"].ToString()) ? 1 : 0; deviceModel.waktu_cek_schedule = (int)row["waktu_cek_schedule"]; deviceModel.waktu_cek_pesan_pending = (int)row["waktu_cek_pesan_pending"]; deviceModel.waktu_cek_koneksi = (int)row["waktu_cek_koneksi"]; deviceModel.cek_pesan_masuk = bool.Parse(row["cek_pesan_masuk"].ToString()) ? 1 : 0; } } DBConnService.CloseConnection(); } catch (Exception ex) { Console.WriteLine(ex); } return(deviceModel); }
public List <MessageModel> CheckMessage() { List <MessageModel> models = new List <MessageModel>(); try { var data = DBConnService.Select("SELECT id, initial, jenis, prefix, nomor_hp, nama, isi_pesan, waktu FROM sms_pesan " + "WHERE status='0' ORDER BY id DESC LIMIT 1"); foreach (var row in data) { if (row != null) { MessageModel model = new MessageModel(); model.id = (int)row["id"]; model.initial = row["initial"].ToString(); model.jenis = row["jenis"].ToString(); model.prefix = row["prefix"].ToString(); model.nama = row["nama"].ToString(); model.pesan = row["isi_pesan"].ToString(); model.noTelp = row["nomor_hp"].ToString(); DateTime.TryParse(row["waktu"].ToString(), out model.waktu); models.Add(model); } } DBConnService.CloseConnection(); } catch (Exception ex) { Console.WriteLine(ex); } return(models); }