public ActionResult AddBikeLost(int?id)
{
Stream req = Request.InputStream;
req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
//AppendLog("[REQ HKSports/LoginController]" + json);
string actionName = "AddBikeLost";
DateTime dtNow = DateTime.Now;
// 객체 초기화
JsonBikeLost jsonBikeLost = null;
UserInfo returnUserInfo = new UserInfo();
HKRheader rHeader = new HKRheader();
UserInfoBody uiBody = new UserInfoBody();
LOG newLog = new LOG(); // 로그 객체
// DB Context 가져오기
HKRiderDBDataContext db = new HKRiderDBDataContext(/*connectionString here */);
LOGDBDataContext logdb = new LOGDBDataContext(/**/);
try
{
jsonBikeLost = JsonConvert.DeserializeObject <JsonBikeLost>(json);
// Log 처리 루틴 -------------------------------------------------
newLog.action = jsonBikeLost.header.action;
newLog.auth_token = jsonBikeLost.header.auth_token;
newLog.json = json;
newLog.dt_created = dtNow;
newLog.user_id = jsonBikeLost.body.nickname;
// Log 처리 루틴 -------------------------------------------------
if (!jsonBikeLost.header.action.Equals(actionName))
{
returnUserInfo.header = setHKRheader_Err(rHeader, 101, "[ERROR] Action is wrong: " + jsonBikeLost.header.action,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else if (jsonBikeLost.header.auth_token == null || jsonBikeLost.header.auth_token == "")
{
returnUserInfo.header = setHKRheader_Err(rHeader, 103, "[ERROR] Auth Token is wrong: " + jsonBikeLost.header.auth_token,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
// Version Check 추가 예정
// User 가져오기
USER thisUser = (from u in db.USERs
where u.Auth_Token == jsonBikeLost.header.auth_token
select u).SingleOrDefault();
if (thisUser == null) // 유저가 존재하는지 확인
{
//Error 202: 다시 접속하세요. 유저정보를 확인할 수 없습니다.
returnUserInfo.header = setHKRheader_Err(rHeader, 202, "[ERROR] 다시 접속하세요. 유저정보를 확인할 수 없습니다: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else // 분실신고 바이크의 정보가 있는지 확인.
{
ROADBIKE theBike = thisUser.ROADBIKEs.Where(r => r.Nickname == jsonBikeLost.body.nickname).SingleOrDefault();
if (theBike == null) //존재하지 않는 바이크.
{
//Error 205: 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.
returnUserInfo.header = setHKRheader_Err(rHeader, 205, "[ERROR] 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else // 분실 신고 테이블에 등록
{
LOSTBIKE lostBike = (from l in db.LOSTBIKEs
where l.BikeNickname == jsonBikeLost.body.nickname &&
l.DeviceID == jsonBikeLost.body.device_id &&
l.Status.Contains("L")
select l).SingleOrDefault();
if (lostBike != null) //이미 분실신고 되어 있음.
{
//Error 206: 이미 분실신고 되었습니다.
returnUserInfo.header = setHKRheader_Err(rHeader, 205, "[ERROR] 이미 분실신고 되었습니다.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else
{
LOSTBIKE newLostBike = new LOSTBIKE();
newLostBike.BikeNickname = jsonBikeLost.body.nickname;
newLostBike.UserName = jsonBikeLost.body.username;
newLostBike.PhoneNo = jsonBikeLost.body.phone_no;
newLostBike.ExtraInfo = jsonBikeLost.body.extra_info;
newLostBike.DeviceID = jsonBikeLost.body.device_id;
newLostBike.LocationLost = jsonBikeLost.body.location_lost;
newLostBike.DT_lost = jsonBikeLost.body.dt_lost;
newLostBike.USERS_id = theBike.USERS_id;
newLostBike.ROADBIKES_id = theBike.id;
newLostBike.ModelName = theBike.Modelname;
newLostBike.ColorSize = theBike.ColorSize;
newLostBike.FrameNo = theBike.FrameNo;
newLostBike.Characteristics = theBike.Characteristics;
newLostBike.Status = "L"; // L:losted, F:found, C:canceled
newLostBike.DT_registered = dtNow;
newLostBike.Dt_updated = dtNow;
db.LOSTBIKEs.InsertOnSubmit(newLostBike); // 분실신고 추가.
theBike.Lost = "Y"; //N: 분실아님, Y: 분실.
theBike.DT_lastaccess = dtNow;
PUSHRECORD pushRecord = new PUSHRECORD();
pushRecord.dt = dtNow;
sendFCM_lostbike(newLostBike, "L", pushRecord);
db.PUSHRECORDs.InsertOnSubmit(pushRecord);
}
}
}
db.SubmitChanges();
logdb.LOGs.InsertOnSubmit(newLog);
returnUserInfo.header = rHeader;
returnUserInfo.body = uiBody;
returnUserInfo = getUserInformation(returnUserInfo, thisUser); // 다시 계정 정보를 받아서 리턴해 준다.
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
// Error: Exception
returnUserInfo.header = setHKRheader_Err(rHeader, 301, "[ERROR] Exception: " + ex.Message
, jsonBikeLost == null?"jsonRoadBike is null": jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetBikeLost(int?id)
{
Stream req = Request.InputStream;
req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
//AppendLog("[REQ HKSports/LoginController]" + json);
string actionName = "GetBikeLost";
DateTime dtNow = DateTime.Now;
// 객체 초기화
JsonBikeLost jsonBikeLost = null;
JsonBikeLost returnBikeLost = new JsonBikeLost();
HKRheader rHeader = new HKRheader();
BikeLost bikeLostBody = new BikeLost();
LOG newLog = new LOG(); // 로그 객체
// DB Context 가져오기
HKRiderDBDataContext db = new HKRiderDBDataContext(/*connectionString here */);
LOGDBDataContext logdb = new LOGDBDataContext(/**/);
try
{
jsonBikeLost = JsonConvert.DeserializeObject <JsonBikeLost>(json);
// Log 처리 루틴 -------------------------------------------------
newLog.action = jsonBikeLost.header.action;
newLog.auth_token = jsonBikeLost.header.auth_token;
newLog.json = json;
newLog.dt_created = dtNow;
newLog.user_id = jsonBikeLost.body.nickname;
// Log 처리 루틴 -------------------------------------------------
if (!jsonBikeLost.header.action.Equals(actionName))
{
returnBikeLost.header = setHKRheader_Err(rHeader, 101, "[ERROR] Action is wrong: " + jsonBikeLost.header.action,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
else if (jsonBikeLost.header.auth_token == null || jsonBikeLost.header.auth_token == "")
{
returnBikeLost.header = setHKRheader_Err(rHeader, 103, "[ERROR] Auth Token is wrong: " + jsonBikeLost.header.auth_token,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
// Version Check 추가 예정
// User 가져오기
USER thisUser = (from u in db.USERs
where u.Auth_Token == jsonBikeLost.header.auth_token
select u).SingleOrDefault();
if (thisUser == null) // 유저가 존재하는지 확인
{
//Error 202: 다시 접속하세요. 유저정보를 확인할 수 없습니다.
returnBikeLost.header = setHKRheader_Err(rHeader, 202, "[ERROR] 다시 접속하세요. 유저정보를 확인할 수 없습니다: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
else // 분실신고 바이크의 정보가 있는지 확인.
{
ROADBIKE theBike = db.ROADBIKEs.Where(r => r.Nickname == jsonBikeLost.body.nickname).SingleOrDefault();
if (theBike == null) //존재하지 않는 바이크.
{
//Error 205: 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.
returnBikeLost.header = setHKRheader_Err(rHeader, 205, "[ERROR] 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
else // 분실 신고 테이블에서 조회.
{
LOSTBIKE lostBike = (from l in db.LOSTBIKEs
where l.BikeNickname == jsonBikeLost.body.nickname &&
l.Status.Contains("L")
select l).SingleOrDefault();
if (lostBike == null) //존재하지 않는 분실신고.
{
//Error 208: 조회할 분실신고가 없습니다.
returnBikeLost.header = setHKRheader_Err(rHeader, 208, "[ERROR] 조회할 분실신고가 없습니다.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
else
{
bikeLostBody.characteristics = lostBike.Characteristics;
bikeLostBody.color_size = lostBike.ColorSize;
bikeLostBody.device_id = lostBike.DeviceID;
bikeLostBody.extra_info = lostBike.ExtraInfo;
bikeLostBody.frame_no = lostBike.FrameNo;
bikeLostBody.location_lost = lostBike.LocationLost;
bikeLostBody.modelname = lostBike.ModelName;
bikeLostBody.nickname = lostBike.BikeNickname;
bikeLostBody.phone_no = lostBike.PhoneNo;
bikeLostBody.status = lostBike.Status;
bikeLostBody.username = lostBike.UserName;
bikeLostBody.dt_lost = lostBike.DT_lost;
}
}
}
logdb.LOGs.InsertOnSubmit(newLog);
returnBikeLost.header = rHeader;
returnBikeLost.body = bikeLostBody;
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
// Error: Exception
returnBikeLost.header = setHKRheader_Err(rHeader, 301, "[ERROR] Exception: " + ex.Message
, jsonBikeLost == null?"jsonRoadBike is null": jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnBikeLost, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ReportBikeLost(int?id)
{
Stream req = Request.InputStream;
req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
//AppendLog("[REQ HKSports/LoginController]" + json);
string actionName = "ReportBikeLost";
DateTime dtNow = DateTime.Now;
// 객체 초기화
JsonBikeLost jsonBikeLost = null;
UserInfo returnUserInfo = new UserInfo();
HKRheader rHeader = new HKRheader();
UserInfoBody uiBody = new UserInfoBody();
LOG newLog = new LOG(); // 로그 객체
// DB Context 가져오기
HKRiderDBDataContext db = new HKRiderDBDataContext(/*connectionString here */);
LOGDBDataContext logdb = new LOGDBDataContext(/**/);
try
{
jsonBikeLost = JsonConvert.DeserializeObject <JsonBikeLost>(json);
// Log 처리 루틴 -------------------------------------------------
newLog.action = jsonBikeLost.header.action;
newLog.auth_token = jsonBikeLost.header.auth_token;
newLog.json = json;
newLog.dt_created = dtNow;
newLog.user_id = jsonBikeLost.body.nickname;
// Log 처리 루틴 -------------------------------------------------
if (!jsonBikeLost.header.action.Equals(actionName))
{
returnUserInfo.header = setHKRheader_Err(rHeader, 101, "[ERROR] Action is wrong: " + jsonBikeLost.header.action,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else if (jsonBikeLost.header.auth_token == null || jsonBikeLost.header.auth_token == "")
{
returnUserInfo.header = setHKRheader_Err(rHeader, 103, "[ERROR] Auth Token is wrong: " + jsonBikeLost.header.auth_token,
jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
// Version Check 추가 예정
// User 가져오기
USER thisUser = (from u in db.USERs
where u.Auth_Token == jsonBikeLost.header.auth_token
select u).SingleOrDefault();
if (thisUser == null) // 유저가 존재하는지 확인
{
//Error 202: 다시 접속하세요. 유저정보를 확인할 수 없습니다.
returnUserInfo.header = setHKRheader_Err(rHeader, 202, "[ERROR] 다시 접속하세요. 유저정보를 확인할 수 없습니다: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else // 분실신고 바이크의 정보가 있는지 확인.
{
ROADBIKE theBike = db.ROADBIKEs.Where(r => r.Nickname == jsonBikeLost.body.nickname).SingleOrDefault();
if (theBike == null) //존재하지 않는 바이크.
{
//Error 205: 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.
returnUserInfo.header = setHKRheader_Err(rHeader, 205, "[ERROR] 아바타 정보를 확인할 수 없습니다. 계속 문제 발생시 다시 로그인해 주세요.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else // 분실 신고 테이블에 등록
{
USER theUser = db.USERs.Where(u => u.id == theBike.USERS_id).SingleOrDefault();
if (theUser == null) // 유저가 존재하는지 확인
{
//Error 202: 다시 접속하세요. 유저정보를 확인할 수 없습니다.
returnUserInfo.header = setHKRheader_Err(rHeader, 202, "[ERROR] 다시 접속하세요. 유저정보를 확인할 수 없습니다: " +
theUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
LOSTBIKE lostBike = (from l in db.LOSTBIKEs
where l.BikeNickname == jsonBikeLost.body.nickname &&
l.DeviceID == jsonBikeLost.body.device_id &&
l.Status.Contains("L")
select l).SingleOrDefault();
if (lostBike == null) //존재하지 않는 분실신고.
{
//Error 207: 취소할 분실신고가 없습니다.
returnUserInfo.header = setHKRheader_Err(rHeader, 207, "[ERROR] 취소할 분실신고가 없습니다.: " +
thisUser.EMail, thisUser.Auth_Token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
else
{
theBike.LastGPS = jsonBikeLost.body.dt_lost + ":" + jsonBikeLost.body.location_lost;
PUSHRECORD pushRecord = new PUSHRECORD();
pushRecord.dt = dtNow;
sendFCM_lostbike_found(theUser, jsonBikeLost.body, pushRecord);
db.PUSHRECORDs.InsertOnSubmit(pushRecord);
}
}
}
db.SubmitChanges();
logdb.LOGs.InsertOnSubmit(newLog);
returnUserInfo.header = rHeader;
returnUserInfo.body = uiBody;
returnUserInfo = getUserInformation(returnUserInfo, thisUser); // 다시 계정 정보를 받아서 리턴해 준다.
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
// Error: Exception
returnUserInfo.header = setHKRheader_Err(rHeader, 301, "[ERROR] Exception: " + ex.Message
, jsonBikeLost == null?"jsonRoadBike is null": jsonBikeLost.header.auth_token, logdb, newLog);
return(Json(returnUserInfo, JsonRequestBehavior.AllowGet));
}
}