public async Task <HttpResponseMessage> GetCount(BaseRequest request) { if (!ModelState.IsValid || request == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } try { var result = await Task.Factory.StartNew(() => NeeoVoipApi.GetMcrCount(request.Uid)); return(Request.CreateResponse(HttpStatusCode.OK, new Dictionary <string, string>() { { "GetMcrCountResult", result } })); } catch (ApplicationException applicationException) { return(SetCustomResponseMessage("", (HttpStatusCode)(Convert.ToInt32(applicationException.Message)))); } catch (Exception exception) { LogManager.CurrentInstance.ErrorLogger.LogError(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, exception.Message, exception); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public string GetMcrCount(string userID) { userID = (userID != null) ? userID.Trim() : userID; // #region Verify User //var request = OperationContext.Current.IncomingMessageProperties[HttpRequestMessageProperty.Name] as HttpRequestMessageProperty; //string keyFromClient = request.Headers["key"]; // if (NeeoUtility.AuthenticateUserRequest( userID, keyFromClient)) //{ //#endregion ulong temp; if (!NeeoUtility.IsNullOrEmpty(userID) && ulong.TryParse(userID, out temp)) { try { return(NeeoVoipApi.GetMcrCount(userID)); } catch (ApplicationException applicationException) { NeeoUtility.SetServiceResponseHeaders((CustomHttpStatusCode)(Convert.ToInt32(applicationException.Message))); } catch (Exception exception) { LogManager.CurrentInstance.ErrorLogger.LogError(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, exception.Message, exception); NeeoUtility.SetServiceResponseHeaders(CustomHttpStatusCode.UnknownError); } return(""); } else { NeeoUtility.SetServiceResponseHeaders(CustomHttpStatusCode.InvalidArguments); return(""); } //} // else // { // NeeoUtility.SetServiceResponseHeaders((CustomHttpStatusCode)HttpStatusCode.Unauthorized); // return ""; // } }
protected void Button1_Click(object sender, EventArgs e) { var _conStr = ConfigurationManager.ConnectionStrings["neeoConnectionString"].ConnectionString; var _con = new SqlConnection(_conStr); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select username from neUserExtension where devicePlatform = 1"; cmd.CommandType = CommandType.Text; cmd.Connection = _con; System.Data.DataTable dtContactsInfo = new System.Data.DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dtContactsInfo); if (dtContactsInfo.Rows.Count > 0) { Response.Write("Count == > " + dtContactsInfo.Rows.Count.ToString() + "<br/>"); for (int i = 0; i < dtContactsInfo.Rows.Count; i++) { try { var mcr = NeeoVoipApi.GetMcrCount(dtContactsInfo.Rows[i]["username"].ToString()); Response.Write(i + " ==> " + dtContactsInfo.Rows[i]["username"].ToString() + " ==> " + mcr + "<br/>"); var _conStrr = ConfigurationManager.ConnectionStrings["neeoConnectionString"].ConnectionString; var _conn = new SqlConnection(_conStrr); SqlCommand cmdd = new SqlCommand(); cmdd.CommandText = "UPDATE [dbo].[neOfflineUserMessageCount] SET [mcrCount] = " + mcr + " WHERE username = '******'"; cmdd.CommandType = CommandType.Text; cmdd.Connection = _conn; using (_conn) { _conn.Open(); cmdd.ExecuteNonQuery(); _conn.Close(); Response.Write(i + " ==> " + dtContactsInfo.Rows[i]["username"].ToString() + " ==> updated" + "<br/>"); } } catch (SqlException sqlEx) { Response.Write(sqlEx.Message + "<br/>"); } catch (ApplicationException applicationException) { Response.Write(applicationException.Message + "<br/>"); } catch (Exception exception) { Response.Write(exception.Message + "<br/>"); } } } } catch (SqlException sqlEx) { Response.Write(sqlEx.Message + "<br/>"); } catch (Exception Ex) { Response.Write(Ex.Message + "<br/>"); } finally { if (_con.State != ConnectionState.Closed) { _con.Close(); } } }