public IHttpActionResult PostCustSendMsg([FromBody] m_CustMessage value)
{
string clientHostname = HttpContext.Current.Request.UserHostName;
string url = HttpContext.Current.Request.Path;
try
{
m_SMS010 sms = new m_SMS010();
sms.CUST_NO = value.cust_no;
sms.CON_NO = string.Empty;
sms.SMS_NOTE = value.message;
sms.SENDER = value.cust_no;
sms.SENDER_TYPE = "CUST";
var lastMsg = user.getLastNotification(value.cust_no);
if (lastMsg.SMS_NOTE != value.message)
{
Notification noti = new Notification();
var lastSms = noti.createSms(sms);
sms.SMS010_PK = lastSms;
sms.READ_STATUS = "UNREAD";
sms.SMS_TIME = DateTime.Now;
var cust = user.getProfileById(value.cust_no);
payment.sendMessageToLine($"[{cust.CUST_NO.ToString()}] คุณ{cust.CUST_NAME} => {value.message}");
monitor.sendMessage(url, clientHostname, value, new { request_status = "SUCCESS", desc = "ลูกค้าส่งข้อความ", data = sms });
}
return(Ok(new { code = 200, message = "ส่งข้อความสำเร็จ", data = sms }));
}
catch (Exception e)
{
monitor.sendMessage(url, clientHostname, value, new { Message = e.Message });
return(Ok(new { code = 500, message = e.Message, data = string.Empty }));
}
}
public IHttpActionResult GetLogout(int cust_no)
{
//m_LogReg mlog = new m_LogReg();
string IPAddress = HttpContext.Current.Request.UserHostAddress;
string url = HttpContext.Current.Request.Path;
try
{
_user.logout(cust_no);
monitor.sendMessage(url, IPAddress, cust_no, new { code = 200, message = "ออกจากระบบสำเร็จ" });
return(Ok(new { code = 200, message = "ออกจากระบบสำเร็จ" }));
}
catch
{
monitor.sendMessage(url, IPAddress, cust_no, new { code = 411, message = "ออกจากระบบไม่สำเร็จ" });
return(Ok(new { code = 411, message = "ออกจากระบบไม่สำเร็จ" }));
}
}
public void sendSmsById(long id)
{
int total = 0, sent = 0, success = 0, fail = 0;
using (OracleConnection conn = new OracleConnection(Database.conString))
{
try
{
conn.Open();
using (var cmd3 = new OracleCommand(SqlCmd.Log.logTest, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd3.Parameters.Add(new OracleParameter("msg", "เริ่มดึงข้อความ"));
cmd3.ExecuteNonQueryAsync();
cmd3.Dispose();
}
using (var cmd = new OracleCommand(SqlCmd.Line.getSmsByIdWithUserId, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd.Parameters.Add("sms010_pk", id);
var reader = cmd.ExecuteReader();
List <m_sendSmsLine> data = new List <m_sendSmsLine>();
while (reader.Read())
{
data.Add(new m_sendSmsLine
{
SMS010_PK = Int32.Parse(reader["SMS010_PK"].ToString()),
CUST_NO = Int32.Parse(reader["CUST_NO"].ToString()),
LINE_USER_ID = reader["LINE_USER_ID"] == DBNull.Value ? string.Empty : reader["LINE_USER_ID"].ToString(),
SMS_NOTE = reader["SMS_NOTE"] == DBNull.Value ? string.Empty : reader["SMS_NOTE"].ToString(),
CON_NO = reader["CON_NO"] == DBNull.Value ? string.Empty : reader["CON_NO"].ToString(),
SMS_TIME = (DateTime)reader["SMS_TIME"],
SENDER = reader["SENDER"] == DBNull.Value ? 0 : Int32.Parse(reader["SENDER"].ToString()),
SENDER_TYPE = reader["SENDER_TYPE"].ToString(),
SMS010_REF = reader["SMS010_REF"] == DBNull.Value ? 0 : Int32.Parse(reader["SMS010_REF"].ToString()),
READ_STATUS = reader["READ_STATUS"].ToString()
});
}
using (var cmd3 = new OracleCommand(SqlCmd.Log.logTest, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd3.Parameters.Add(new OracleParameter("msg", "ดึงข้อความเสร็จ"));
cmd3.ExecuteNonQueryAsync();
cmd3.Dispose();
}
using (var cmd3 = new OracleCommand(SqlCmd.Log.logTest, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd3.Parameters.Add(new OracleParameter("msg", "เริ่มส่งข้อความ"));
cmd3.ExecuteNonQueryAsync();
cmd3.Dispose();
}
if (data.Count != 0)
{
total = data.Count;
bool res = false;
var msg = data.LastOrDefault();
res = sendMessageUserId(msg.LINE_USER_ID, msg.SMS_NOTE);
sent++;
if (res == true)
{
success++;
}
else
{
fail++;
}
using (var cmd2 = new OracleCommand(SqlCmd.Notification.markToSent, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd2.ExecuteNonQueryAsync();
cmd2.Parameters.Clear();
}
}
using (var cmd3 = new OracleCommand(SqlCmd.Log.logTest, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd3.Parameters.Add(new OracleParameter("msg", "ส่งข้อความเสร็จ"));
cmd3.ExecuteNonQueryAsync();
cmd3.Dispose();
monitor.sendMessage("/api/admin/sendmessageall/line", "localhost", "", new { totalSms = total, sentSms = sent, success = success, fail = fail });
}
reader.Dispose();
cmd.Dispose();
}
}
finally
{
conn.Close();
conn.Dispose();
}
}
}