public m_Customer getProfileByUserId(string user_id)
{
using (OracleConnection conn = new OracleConnection(Database.conString))
{
try
{
conn.Open();
using (var cmd = new OracleCommand(SqlCmd.Line.getProfileByUserId, conn)
{
CommandType = System.Data.CommandType.Text
})
{
cmd.Parameters.Add("line_user_id", user_id);
var reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
var data = new m_Customer
{
CUST_NO = Int32.Parse(reader["CUST_NO"].ToString()),
CUST_NAME = (string)reader["CUST_NAME"],
CITIZEN_NO = reader["CITIZEN_NO"] == DBNull.Value ? string.Empty : (string)reader["CITIZEN_NO"],
TEL = reader["TEL"] == DBNull.Value ? string.Empty : (string)reader["TEL"],
PERMIT = (string)reader["PERMIT"],
LINE_USER_ID = reader["LINE_USER_ID"] == DBNull.Value ? string.Empty : reader["LINE_USER_ID"].ToString()
};
reader.Dispose();
cmd.Dispose();
return(data);
}
reader.Dispose();
cmd.Dispose();
return(null);
}
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
public IHttpActionResult GetCheckPhone2(string serial_sim, string deviceId, string brand, string model, double app_version, string api_version)
{
//var setting = (AppSettingsSection)WebConfigurationManager.OpenWebConfiguration("~").GetSection("appSettings");
//var appService = setting.Settings["AppService"].Value;
//if (appService == "False")
// return Unauthorized();
m_LogReq mlog = new m_LogReq();
string IPAddress = HttpContext.Current.Request.UserHostAddress;
string url = HttpContext.Current.Request.Path;
try
{
m_Customer result = new m_Customer();
if (serial_sim == "1111111111" || serial_sim == "2222222222")
{
result = _user.getProfileByDeviceId(deviceId);
}
//else
//result = _user.getProfileBySerialSim(serial_sim);
if (result != null && result.CUST_NO != 0)
{
if (result.PERMIT == "SMS" || result.PERMIT == "BOTH")
{
var device = _user.checkCurrentDevice(deviceId);
if (device != null)
{
if (app_version != device.app_version)
{
_user.updateAppVersion(app_version, deviceId);
}
_user.updateIdentify(deviceId);
var chat = _user.getChatOn();
if (device.device_status == "ACT")
{
var version = _user.getAppVersion(serial_sim);
var broadcast = _user.getBroadcast();
mlog.cust_no = result.CUST_NO;
mlog.device_id = deviceId;
mlog.tel = result.TEL;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "SUCCESS";
mlog.note = "ระบุตัวตนสำเร็จ";
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version*/ }, new { code = 200, message = "ระบุตัวตนสำเร็จ", data = result });
return(Ok(new { code = 200, message = "ข้อมูลถูกต้อง", data = new m_identify {
CUST_NO = result.CUST_NO, CUST_NAME = result.CUST_NAME, CITIZEN_NO = result.CITIZEN_NO, TEL = result.TEL, PERMIT = result.PERMIT, CHAT = chat, APP_VERSION = version, BROADCAST = broadcast
} }));
}
else if (device.device_status == "CHANGE_TEL")
{
mlog.cust_no = result.CUST_NO;
mlog.device_id = deviceId;
mlog.tel = result.TEL;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = "ลูกค้าเปลี่ยนหมายเลขโทรศัพท์";
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version*/ }, new { code = 402, message = "ข้อมูลลูกค้าอยู่ในขั้นตอนการเปลี่ยนหมายเลขโทรศัพท์", data = result });
return(Ok(new { code = 402, message = "กรุณาใช้หมายเลขโทรศัพท์ใหม่", data = result }));
}
else
{
mlog.cust_no = result.CUST_NO;
mlog.device_id = deviceId;
mlog.tel = result.TEL;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = "เครื่องลูกค้าถูกระงับการใช้งาน";
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
//log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version= app_version */ }, new { code = 403, message = "เครื่องลูกค้าถูกระงับการใช้งาน!", data = result });
return(Ok(new { code = 403, message = "เครื่องลูกค้าถูกระงับการใช้งาน!", data = result }));
}
}
else
{
mlog.cust_no = result.CUST_NO;
mlog.device_id = deviceId;
mlog.tel = result.TEL;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = "ไม่พบเครื่องลูกค้าในระบบ";
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version*/ }, new { code = 404, message = "ไม่พบเครื่องลูกค้าในระบบ!", data = result });
return(Ok(new { code = 404, message = "ไม่พบเครื่องลูกค้าในระบบ!", data = result }));
}
}
else
{
mlog.cust_no = result.CUST_NO;
mlog.device_id = deviceId;
mlog.tel = result.TEL;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = "ลูกค้าถูกระงับบริการ SMS";
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version*/ }, new { code = 401, message = "ลูกค้าถูกระงับบริการ SMS!", data = result });
return(Ok(new { code = 401, message = "ลูกค้าถูกระงับบริการ SMS!", data = result }));
}
}
else
{
mlog.cust_no = 0;
mlog.device_id = deviceId;
mlog.tel = string.Empty;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = "ไม่พบเครื่องของลูกค้าในระบบ";
//log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version*/ }, new { code = 407, message = "ไม่พบเลขซิมการ์ดของลูกค้าในระบบ!", data = result });
return(Ok(new { code = 409, message = "ไม่พบเครื่องของลูกค้าในระบบ!", data = result }));
}
}
catch (Exception e)
{
mlog.cust_no = 0;
mlog.device_id = deviceId;
mlog.tel = string.Empty;
mlog.serial_sim = serial_sim;
mlog.ip_addr = IPAddress;
mlog.action = "IDENTIFY";
mlog.status = "FAIL";
mlog.note = e.Message;
mlog.brand = brand;
mlog.model = model;
mlog.app_version = app_version;
mlog.api_version = api_version;
log.logSignin(mlog);
monitor.sendMessage(url, IPAddress, new { serial_sim = serial_sim, deviceId = deviceId /*, app_version = app_version */ }, new { Message = e.Message });
return(Ok(new { code = 500, message = e.Message, data = string.Empty }));
}
}
