示例#1
0
        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);
            }
        }
示例#2
0
        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;
            }
        }