public HttpResponseMessage create_sosAlert(SosAlertsModel objSosAlertsModel) { var re = Request; var headers = re.Headers; if (headers.Contains("token")) { token = headers.GetValues("token").First(); } var result = Authtoken.checkToken(token); if (result == true) { userId = objSosAlertsModel.userId; dt = objLoginDL.selectbyUserId(userId); objSosAlertsModel.userIdfk = Convert.ToInt16(dt.Rows[0]["id"].ToString()); objSosAlertsDL.insert_SosAlert(objSosAlertsModel); resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "Your sos details saved succesfully", output = dt2, statuscode = Convert.ToInt16(HttpStatusCode.OK), error = false }); return(resp); } else { resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = true }); return(resp); } }
public int insert_SosAlert(SosAlertsModel objSosModel) { try { return(Execution.ExecuteNonQuery_with_result("sp_sosalerts", new SqlParameter[] { new SqlParameter("@Command", "INSERT"), new SqlParameter("@latitude", objSosModel.latitude), new SqlParameter("@longitude", objSosModel.latitude), new SqlParameter("@address", objSosModel.address), new SqlParameter("@userIdFK", objSosModel.userIdfk), new SqlParameter("@status", 1), })); } catch (Exception ex) { throw ex; } }