public void logRequest2(m_LogActivity log)
{
using (OracleConnection conn = new OracleConnection(Database.conString))
{
try
{
conn.Open();
using (var cmd = new OracleCommand(SqlCmd.Log.logReq, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd.Parameters.Add(new OracleParameter("note", log.note));
cmd.Parameters.Add(new OracleParameter("cust_no", log.cust_no));
cmd.Parameters.Add(new OracleParameter("device_id", log.device_id));
cmd.Parameters.Add(new OracleParameter("ip_addr", log.ip_addr));
cmd.Parameters.Add(new OracleParameter("url", log.url));
cmd.ExecuteNonQueryAsync();
cmd.Dispose();
}
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public void logActivity(m_LogActivity log)
{
using (OracleConnection conn = new OracleConnection(Database.conString))
{
try
{
conn.Open();
using (var cmd = new OracleCommand(SqlCmd.Log.logActivity, conn)
{
CommandType = CommandType.Text
})
{
cmd.Parameters.Add("cust_no", log.cust_no);
cmd.Parameters.Add("device_id", log.device_id);
cmd.Parameters.Add("tel", log.tel);
cmd.Parameters.Add("serial_sim", log.serial_sim);
cmd.Parameters.Add("ip_addr", log.ip_addr);
cmd.Parameters.Add("action", log.action);
cmd.Parameters.Add("status", log.status);
cmd.Parameters.Add("note", log.note);
cmd.Parameters.Add("brand", log.brand);
cmd.Parameters.Add("model", log.model);
cmd.Parameters.Add("app_version", log.app_version);
cmd.Parameters.Add("api_version", log.api_version);
cmd.ExecuteNonQueryAsync();
cmd.Dispose();
}
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public IHttpActionResult PostSmsOffset2(m_SmsOffset value)
{
m_LogActivity mlog;
string IPAddress = HttpContext.Current.Request.UserHostAddress;
string url = HttpContext.Current.Request.Path;
try
{
var result = _user.getProfileById(value.cust_no);
var app_version = _user.getAppVersionByCust_no(value.cust_no);
//app_version = 3.2;
if (result != null && result.CUST_NO != 0)
{
mlog = new m_LogActivity();
mlog.cust_no = value.cust_no;
mlog.device_id = value.device_id;
mlog.tel = result.TEL;
// mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "RETRIEVE SMS";
mlog.status = "SUCCESS";
mlog.note = "ดึงข้อมูล SMS สำเร็จ";
mlog.brand = value.brand;
mlog.model = value.model;
mlog.app_version = value.app_version;
mlog.api_version = value.api_version;
var sms = _user.getNotification(value.cust_no);
_user.updateReadSms(value.cust_no);
if (sms.Count > 0)
{
if (app_version < 3.2)
{
sms.RemoveAll(s => s.MSG_TYPE == "IMAGE");
}
if (value.skip != 0)
{
value.skip = value.skip - 5;
}
sms = sms.OrderByDescending(p => p.SMS010_PK).Skip(value.skip).Take(5).ToList();
if (value.skip == 0)
{
sms = sms.OrderBy(p => p.SMS010_PK).ToList();
}
}
log.logActivity(mlog);
monitor.sendMessage(url, IPAddress, new { id = value.cust_no, skip = value.skip, take = value.take }, new { data = sms });
return(Ok(new { code = 200, message = "ดึงข้อมูล Sms สำเร็จ", data = sms }));
}
else
{
//mlog = new m_LogReq();
//mlog.cust_no = id;
//mlog.tel = result.TEL;
//mlog.ip_addr = IPAddress;
//mlog.action = "RETRIEVE SMS";
//mlog.status = "FAIL";
//mlog.note = "ไม่พบข้อมูลลูกค้าในระบบ";
monitor.sendMessage(url, IPAddress, new { id = value.cust_no, skip = value.skip, take = value.take }, new { Message = "Not found customer!" });
return(Ok(new { code = 400, message = "ไม่พบข้อมูลลูกค้าในระบบ", data = result }));
}
}
catch (Exception e)
{
mlog = new m_LogActivity();
mlog.ip_addr = IPAddress;
mlog.note = e.Message;
mlog.url = "api/customer/sms";
log.logRequest2(mlog);
monitor.sendMessage(url, IPAddress, new { id = value.cust_no }, new { Type = "Error", Message = e.Message });
return(Ok(new { code = 500, message = e.Message, data = string.Empty }));
}
}
