public Models.Response processRegisterRequest(Models.ClientMessage message, Socket sender)
{
Models.Response response = new Models.Response(sender);
/*
* message.Arguments:
*
* 0 - username
* 1 - nickname
* 2 - password
* 3 - email
*/
Tuple <bool, List <string> > dbRegisterResponse = _db.checkForRegisterInformation(message.stringArguments[0], message.stringArguments[1], message.stringArguments[3]);
// if registration was successful
if (dbRegisterResponse.Item1)
{
_db.insertNewUser(message.stringArguments[0], message.stringArguments[1], message.stringArguments[2], message.stringArguments[3]);
response.responseCommandToSender = "REGISTERSUCCESSFULL";
}
else
{
response.responseCommandToSender = "REGISTERFAILED";
response.commandStringArgumentsToSender = dbRegisterResponse.Item2;
}
return(response);
}
public Response Authenticate(LoginModel model)
{
Response objRes = new Models.Response();
using (var client = new HttpClient())
{
var postData = new Dictionary <string, string> {
{ "data", JsonConvert.SerializeObject(model) }
};
HttpContent content = new FormUrlEncodedContent(postData);
client.BaseAddress = new Uri(DevURI);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Add("NetworkKey", NetworkKey);
HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Post, "oauth/token")
{
Content = new StringContent(JsonConvert.SerializeObject(model),
Encoding.UTF8,
"application/json") //CONTENT-TYPE header
};
HttpResponseMessage response = client.SendAsync(request).Result;
if (response.IsSuccessStatusCode)
{
objRes.Data = response.Content.ReadAsStringAsync().Result;
}
else
{
objRes.Data = response.ReasonPhrase;
}
objRes.StatusCode = (int)response.StatusCode;
return(objRes);
}
}
public Models.Response processCreateGameRoom(Socket sender)
{
Models.Response response = new Models.Response(sender);
// if the user that requested to create a game room has any available decks that it may play with
if (db.userHasPlayableDecks(lobbyRoomData.getUsernameBySocket(sender)))
{
User user = lobbyRoomData.getUserBySocket(sender);
if (gameRoomData.checkUserAlreadyInRoom(user.Username))
{
response.responseCommandToSender = "ALREADYINAROOM";
}
else
{
Models.GameRoom room = gameRoomData.createNewGameRoom(user);
response.socketsToNotify = lobbyRoomData.lobbyRoomUsersToSocketList();
response.commandStringArgumentsToSockets = new List <string>()
{
room.ToString()
};
response.responseCommandToSockets = "ADDGAMEROOM";
}
}
else
{
response.responseCommandToSender = "DECKSREQUIREDTOJOIN";
}
return(response);
}
public async Task <IActionResult> enquiry([FromBody] AccountEnquiryRequest request)
{
Models.Response b = new Models.Response();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(AgencyBanking.Helpers.Utility.GetResponse(ModelState)));
}
var tuple = await _orclRepo.GetAccountEnquiryByAccountNumber(request);
if (!tuple.Item2.status)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, tuple.Item2));
}
b = tuple.Item1;
}
catch (Exception ex)
{
_logger.LogError($"{request.accountNumber}:- {Environment.NewLine} {ex.ToString()}");
return(StatusCode((int)HttpStatusCode.InternalServerError, AgencyBanking.Helpers.Utility.GetResponse(ex)));
}
return(CreatedAtAction("enquiry", b));
}
public Models.Response processReadyToStart(Models.ClientMessage message, Socket sender)
{
Models.Response response = new Models.Response(sender);
Models.Game game;
game = onGoingGamesData.getGameByID(Int32.Parse(message.stringArguments[0]));
if (game.isPlayer1(sender))
{
game.isP1Ready = true;
}
else
{
game.isP2Ready = true;
}
if (game.isP1Ready && game.isP2Ready)
{
response.responseCommandToSockets = "READYTOGO";
response.socketsToNotify.Add(game.Player1Socket);
response.socketsToNotify.Add(game.Player2Socket);
}
return(response);
}
public Models.Response processLeaveLobby(Models.ClientMessage message, Socket sender)
{
Models.Response response = new Models.Response(sender);
// we change player's location to wherever he is now that he left the lobby
lobbyRoomData.changeLocation(sender, message.stringArguments[0]);
// we remove any game rooms created by the player and remove the player from any rooms he joined
response.socketsToNotify = lobbyRoomData.lobbyRoomUsersToSocketList();
response.socketsToNotify.Remove(sender);
response.responseCommandToSockets = "REMOVELOBBYROOMUSER";
response.commandStringArgumentsToSockets.Add(lobbyRoomData.getNickNameBySocket(sender));
if (message.stringArguments[0] != "PreGameRoom")
{
gameRoomData.removeClient(sender);
}
else
{
response.commandStringArgumentsToSockets.Add(string.Empty);
}
return(response);
}
public async Task OnActionExecutionAsync(ActionExecutingContext context, ActionExecutionDelegate next)
{
if (!context.ModelState.IsValid)
{
_logger.LogWarningExtension("Model Validation Failed. Version: " + context.RouteData.Values["Version"] +
", Controller - " + context.RouteData.Values["Controller"] + ", Action: " +
context.RouteData.Values["Action"]);
var errorsInModelState = context.ModelState.Where(x => x.Value.Errors.Count > 0)
.ToDictionary(kvp => kvp.Key, kvp => kvp.Value.Errors.Select(x => x.ErrorMessage)).ToArray();
var errorResponse = new Models.Response <ApiError>(null, false, "Model Validation Failed")
{
Errors = new List <ApiError>()
};
foreach (var error in errorsInModelState)
{
foreach (var subError in error.Value)
{
errorResponse.Errors.Add(new ApiError
{
ErrorId = error.Key,
StatusCode = (short)HttpStatusCode.BadRequest,
Message = subError
});
}
}
context.Result = new BadRequestObjectResult(errorResponse);
return;
}
await next();
}
protected override async Task <OutputModel> AfterAsync(InputModel input, Models.Response response)
{
var output = await base.AfterAsync(input, response);
_mapper.Map(input, output);
output.AddToUserState(Models.Request.IsOldUserKey, true);
output.AddToUserState(Models.Response.NextTextIndexStorageKey, response.NextTextIndex);
output.AddToApplicationState(Models.Response.NextTextIndexStorageKey, response.NextTextIndex);
output.AddToSessionState(Models.Response.ScopeStorageKey, response.ScopeKey);
_stopwatch.Stop();
if (_stopwatch.ElapsedMilliseconds > 1000)
{
output.AddAnalyticsEvent("ElapsedTime", new Dictionary <string, object> {
{ "ElapsedMilliseconds", _stopwatch.ElapsedMilliseconds }
});
}
output.AddAnalyticsEvent(Models.Response.ScopeStorageKey, new Dictionary <string, object> {
{ Models.Response.ScopeStorageKey, response.ScopeKey }
});
return(output);
}
public Response CurrentStatusOfUser(UserModel model)
{
int StatusCode = 0;
Response objRes = new Models.Response();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(DevURI);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Add("NetworkKey", NetworkKey);
HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Get, "users/" + model.Email);
HttpResponseMessage response = client.SendAsync(request).Result;
StatusCode = (int)response.StatusCode;
if (response.IsSuccessStatusCode)
{
Token objToken = JsonConvert.DeserializeObject <Token>(response.Content.ReadAsStringAsync().Result);
if (objToken != null && !string.IsNullOrEmpty(objToken.RedemptionCode))
{
objRes.Data = "User registered in HPCA and an Email sent but the user is yet to set the password";
}
else if (objToken != null && string.IsNullOrEmpty(objToken.RedemptionCode))
{
objRes.Data = "User has set the password and user is ready to login";
}
}
else
{
objRes.Data = response.ReasonPhrase;
}
objRes.StatusCode = (int)response.StatusCode;
return(objRes);
}
}
public IActionResult GetCustomerByID(int id)
{
Models.Response response = new Models.Response();
try
{
Customer customer = _customerService.GetCustomerByID(id);
if (customer == null)
{
response.ResponseCode = "-02";
response.ResponseMessage = "Customer Record Not Found";
return(NotFound(new JsonResult(response)));
}
response.ResponseCode = "00";
response.ResponseMessage = "Customer Record Retrieved Successfully";
response.ResponseObject = customer;
}
catch (Exception error)
{
response.ResponseCode = "-01";
response.ResponseMessage = error.Message;
}
return(Ok(new JsonResult(response)));
}
public IActionResult GetDiscountByType(string type)
{
Models.Response response = new Models.Response();
try
{
Discount discount = _discountService.GetDiscountByType(type);
if (discount == null)
{
response.ResponseCode = "-02";
response.ResponseMessage = "Discount Record Not Found";
return(NotFound(new JsonResult(response)));
}
response.ResponseCode = "00";
response.ResponseMessage = "Discount Record Retrieved Successfully";
response.ResponseObject = discount;
}
catch (Exception error)
{
response.ResponseCode = "-01";
response.ResponseMessage = error.Message;
}
return(Ok(new JsonResult(response)));
}
public async Task <IActionResult> enquiry([FromBody] BalanceEnquiryRequest request)
{
Models.Response br = new Models.Response();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(Utility.GetResponse(ModelState)));
}
var tuple = await _orclRepo.GetBalanceByAccountNumber(request);
if (!tuple.Item2.status)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, tuple.Item2));
}
br = tuple.Item1;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(CreatedAtAction("enquiry", br));
}
public ActionResult GetRepresentatives()
{
var context = new CommissionEntities();
var settings = new JsonSerializerSettings {
ContractResolver = new CamelCasePropertyNamesContractResolver()
};
var representatives = context.CARS_CPR_OUTSIDE_REP_TAB.ToList();
var response = new Models.Response();
/* var representativesDataResponseObject = new Models.CommissionData()
* {
* COMMISSION_ID = commissionData.COMMISSION_ID,
* CUSTOMER_NO = commissionData.CUSTOMER_NO,
* OUTSIDE_REP_NAME = commissionData.CARS_CPR_OUTSIDE_REP_TAB.OUTSIDE_REP,
* REP_ID = commissionData.REP_ID,
* COMMISSION = commissionData.COMMISSION
* };*/
response = new Models.Response()
{
Success = true,
JSON_RESPONSE_DATA = JsonConvert.SerializeObject(representatives)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings)
};
return(this.Json(response, JsonRequestBehavior.AllowGet));
//return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON
}
public async Task <IActionResult> create([FromBody] Models.Request request)
{
Models.Response a = new Models.Response();
List <string> messages = new List <string>();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(Utility.GetResponse(ModelState)));
}
var areq = _orclRepo.GetAccountOpeningRequest(request);
if (areq == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest,
Utility.GetResponse(Constant.UNPROCESSABLE_REQUEST, HttpStatusCode.BadRequest)));
}
a = await _orclRepo.OpenAccount(areq);
}
catch (Exception ex)
{
_logger.LogError($"{request.firstName} {request.lastName}:- {Environment.NewLine} {ex.ToString()}");
return(StatusCode((int)HttpStatusCode.InternalServerError, Utility.GetResponse(ex)));
}
return(CreatedAtAction("create", a));
}
public IActionResult GetStudentByID(int id)
{
Models.Response response = new Models.Response();
if (id <= 0)
{
response.ResponseCode = "400";
response.ResponseMessage = "Invalid Student Id Entry";
return(NotFound(new JsonResult(response)));
}
Student student = _studentService.GetStudentByID(id, out string message);
if (student == null)
{
response.ResponseCode = "400";
response.ResponseMessage = message;
return(NotFound(new JsonResult(response)));
}
response.ResponseCode = "201";
response.ResponseMessage = "Student Record Retrieved Successfully";
response.ResponseObject = student;
return(Ok(new JsonResult(response)));
}
public HttpResponseMessage ServerRequest(Request request)
{
// compose the order by for sorting
string order = "StudentID";
// order the results
if (request.sort != null && request.sort.Count > 0)
{
List <string> sorts = new List <string>();
request.sort.ForEach(x => {
sorts.Add(string.Format("{0} {1}", x.field, x.dir));
});
order = string.Join(",", sorts.ToArray());
}
// get all of the records from the employees table in the
// northwind database. return them in a collection of user
// defined model objects for easy serialization. skip and then
// take the appropriate number of records for paging.
var studs = (from e in db.TStudents
.OrderBy(order.ToString())
.Skip(request.skip)
.Take(request.take)
select e).ToArray();
// returns the generic response object which will contain the
// employees array and the total count
var resp = new Models.Response(studs, db.TStudents.Count());
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
public IActionResult Index()
{
Models.Response response = new Models.Response();
response.ResponseCode = "00";
response.ResponseMessage = "Api Is Up";
return(Ok(new JsonResult(response)));
}
public IActionResult Index()
{
Models.Response response = new Models.Response();
response.ResponseCode = "201";
response.ResponseMessage = "Student Data Api";
return(Ok(new JsonResult(response)));
}
public Models.Response processGetDeckList(Socket sender)
{
Models.Response response = new Models.Response(sender);
response.commandStringArgumentsToSender = _db.fetchUserDeckList(_lobbyRoomData.getUsernameBySocket(sender));
response.responseCommandToSender = "DECKLISTDELIVERED";
return(response);
}
public Models.Response processGetCardCollection(Socket sender)
{
Models.Response response = new Models.Response(sender);
response.responseCommandToSender = "YOUGOTCARDS";
response.CardCollection = lobbyRoomData.CardCollection;
return(response);
}
public void CancelAppointment()
{
mockService.Setup(x => x.CancelAppointment(1));
AppointmentController controller = new AppointmentController(mockService.Object);
Models.Response response = controller.Cancel(1);
Assert.IsTrue(response.Success);
}
public Models.Response processNewChatMessage(Models.ClientMessage message, Socket sender)
{
Models.Response response = new Models.Response(sender);
response.socketsToNotify = lobbyRoomData.lobbyRoomUsersToSocketList();
response.responseCommandToSockets = message.Command;
response.commandStringArgumentsToSockets = message.stringArguments;
return(response);
}
public ActionResult GetAllCommissionData()
{
var context = new CommissionEntities();
var settings = new JsonSerializerSettings {
ContractResolver = new CamelCasePropertyNamesContractResolver()
};
var commissionData = context.CARS_CPR_COMMISSION_TAB.ToList();
var response = new Models.Response();
if (commissionData == null)
{
//Used to make property name as camel case
/*Microsoft.Data.OData.ODataError error = new Microsoft.Data.OData.ODataError()
* {
* ErrorCode = "404",
* Message = "Customer Not Fount"
* }
* return JsonConvert.SerializeObject(error, Formatting.None, settings);*///Returns students list as JSON
response = new Models.Response()
{
Success = false,
JSON_RESPONSE_DATA = null,
Message = "Customer Number provided yeilds no result."
};
return(this.Json(response, JsonRequestBehavior.AllowGet));
}
var commissionDatalist = new List <Models.CommissionData>();
foreach (var entry in commissionData)
{
var row = new Models.CommissionData()
{
COMMISSION_ID = entry.COMMISSION_ID,
CUSTOMER_NO = entry.CUSTOMER_NO,
OUTSIDE_REP_NAME = entry.CARS_CPR_OUTSIDE_REP_TAB.OUTSIDE_REP,
REP_ID = entry.REP_ID,
COMMISSION = entry.COMMISSION
};
commissionDatalist.Add(row);
}
response = new Models.Response()
{
Success = true,
JSON_RESPONSE_DATA = JsonConvert.SerializeObject(commissionDatalist)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings)
};
return(this.Json(response, JsonRequestBehavior.AllowGet));
//return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON
}
public Response processGetGameRooms(Socket sender)
{
Models.Response response = new Models.Response(sender);
response.responseCommandToSender = "YOUGOTROOMS";
foreach (Models.GameRoom room in gameRoomData.GameRooms)
{
response.commandStringArgumentsToSender.Add(room.ToString());
}
return(response);
}
public Models.Response CreateTelemetry(JObject digitalTwinData, long digitalTwin, long organization, long digitalTwinModel)
{
Models.Response response = new Models.Response();
//string jsonString;
//jsonString = JsonSerializer.Serialize(data);
try
{
//SQL Statement
string sqlString = "INSERT INTO telemetry (id, digital_twin, digital_twin_data, timestamp, organization, digital_twin_model) " +
"VALUES (@id, @digital_twin, @digital_twin_data, @timestamp, @organization, @digital_twin_model)";
//Create UNIX Timestamp
var utcDateTimeWrite = DateTime.UtcNow;
var dto = new DateTimeOffset(utcDateTimeWrite);
var unixDateTime = dto.ToUnixTimeMilliseconds();
using (var connection = new NpgsqlConnection(connectionString))
{
connection.Open();
connection.TypeMapper.UseJsonNet();
using (var command = new NpgsqlCommand(sqlString, connection))
{
command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Bigint, unixDateTime);
command.Parameters.AddWithValue("@digital_twin", NpgsqlTypes.NpgsqlDbType.Bigint, digitalTwin);
command.Parameters.AddWithValue("@digital_twin_data", NpgsqlTypes.NpgsqlDbType.Json, digitalTwinData);
command.Parameters.AddWithValue("@timestamp", NpgsqlTypes.NpgsqlDbType.Timestamp, DateTime.UtcNow);
command.Parameters.AddWithValue("@organization", NpgsqlTypes.NpgsqlDbType.Bigint, organization);
command.Parameters.AddWithValue("@digital_twin_model", NpgsqlTypes.NpgsqlDbType.Bigint, digitalTwinModel);
command.Prepare();
command.ExecuteNonQuery();
//Log Success
response.Status = "success";
response.Message = "telemetry saved";
response.Id = unixDateTime;
return(response);
}
}
}
catch (Exception ex)
{
//Log Exception
//_logger.LogError(ex, "telemetry save failed");
response.Status = "error";
response.Message = "telemetry save failed";
response.Id = 0;
return(response);
}
}
public Models.Response processJoinLobby(Socket sender)
{
Models.Response response = new Models.Response(sender);
response.responseCommandToSockets = "ADDLOBBYROOMUSER";
response.commandStringArgumentsToSockets.Add(lobbyRoomData.getNickNameBySocket(sender));
response.socketsToNotify = lobbyRoomData.lobbyRoomUsersToSocketList();
response.socketsToNotify.Remove(sender);
lobbyRoomData.changeLocation(sender, "Lobby");
return(response);
}
protected override Models.Response ProcessCommand(Models.Request request)
{
Models.Response response = null;
if (PingCommand.Equals(request.Text, StringComparison.InvariantCultureIgnoreCase))
{
response = new Models.Response {
Text = PongResponse
};
}
return(response);
}
public void PutAppointment()
{
Appointment appointment = new Appointment()
{
Id = 1
};
mockService.Setup(x => x.UpdateAppointment(1, appointment));
AppointmentController controller = new AppointmentController(mockService.Object);
Models.Response response = controller.Put(1, appointment);
Assert.IsTrue(response.Success);
}
protected async override Task <HttpResponseMessage> SendAsync(
HttpRequestMessage request, CancellationToken cancellationToken)
{
var _response = new Models.Response(System.Net.HttpStatusCode.BadRequest, "error!");
responseController.Send(_response);
//Debug.WriteLine("Process request");
// Call the inner handler.
//var response = await base.SendAsync(request, cancellationToken);
var response = await responseController.Send(_response).ExecuteAsync(cancellationToken);
//Debug.WriteLine("Process response");
return(response);
}
public Models.Response CreateDigitalTwinModelDynamicProperty(Models.DigitalTwinModelDynamicPropertyRequest value, long organization)
{
Models.Response response = new Models.Response();
try
{
//SQL Statement
var sqlString = "INSERT INTO digital_twin_model_dynamic_properties (id, name, measurement_type, data_type, unit_of_measure, digital_twin_model, organization) " +
"VALUES (@id, @name, @measurement_type, @data_type, @unit_of_measure, @digital_twin_model, @organization)";
//Create UNIX Timestamp
var utcDateTime = DateTime.UtcNow;
var dto = new DateTimeOffset(utcDateTime);
var unixDateTime = dto.ToUnixTimeMilliseconds();
using (var connection = new NpgsqlConnection(connectionString))
{
connection.Open();
using (var command = new NpgsqlCommand(sqlString, connection))
{
command.Parameters.AddWithValue("@id", NpgsqlTypes.NpgsqlDbType.Bigint, unixDateTime);
command.Parameters.AddWithValue("@name", NpgsqlTypes.NpgsqlDbType.Varchar, value.Name);
command.Parameters.AddWithValue("@measurement_type", NpgsqlTypes.NpgsqlDbType.Bigint, value.MeasurementType);
command.Parameters.AddWithValue("@data_type", NpgsqlTypes.NpgsqlDbType.Bigint, value.DataType);
command.Parameters.AddWithValue("@unit_of_measure", NpgsqlTypes.NpgsqlDbType.Bigint, value.UnitOfMeasure);
command.Parameters.AddWithValue("@digital_twin_model", NpgsqlTypes.NpgsqlDbType.Bigint, value.DigitalTwinModel);
command.Parameters.AddWithValue("@organization", NpgsqlTypes.NpgsqlDbType.Bigint, organization);
command.Prepare();
command.ExecuteNonQuery();
//Log Success
response.Status = "success";
response.Message = "Digital Twin Model Dynamic Property created";
response.Id = unixDateTime;
return(response);
}
}
}
catch (Exception ex)
{
//Log Exception
//_logger.LogError(ex, "Digital Twin Model Dynamic Property creation failed");
response.Status = "error";
response.Message = "Digital Twin Model Dynamic Property creation failed";
response.Id = 0;
return(response);
}
}
