public HttpResponseMessage GetMusicGenre()
{
try
{
ResultResponseModel result = new ResultResponseModel();
List <sp_MusicSelect_Result> content = _db.MusicMasterSelect(0);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage SetUserTravelLike(string pUserId, int pWeigth)
{
try
{
ResultResponseModel result = new ResultResponseModel();
_db.SetUserWeightTravel(pUserId, pWeigth);
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage DeleteEntertainmentInApp(string pUserId, int pGenreId)
{
try
{
ResultResponseModel result = new ResultResponseModel();
_db.DeleteUserEntertainment(pUserId, pGenreId);
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage RegisterUserInApp(string pEmail, string pPassword, string pFirstName, string pLastName, string pPhoneNumber)
{
try
{
ResultResponseModel result = new ResultResponseModel();
sp_UserRegister_Result content = _db.RegisterUser(pEmail, pPassword, pFirstName, pLastName, pPhoneNumber);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage SetUserExpArtLike(string pUserId, int pGenreId)
{
try
{
ResultResponseModel result = new ResultResponseModel();
sp_User_ExpArtsRegister_Result content = _db.SetUserLikesExpArts(pUserId, pGenreId);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage UpdateUserProfile(string pUserId, string pFirstName, string pLastName, string pPhoneNumber, string pNacDate, char pGender, char pGenderPref, string pEmail, int pFaculty, string pImageUrl)
{
try
{
ResultResponseModel result = new ResultResponseModel();
sp_UserUpdateProfile_Result content = _db.UpdateUserProfile(pUserId, pFirstName, pLastName, pPhoneNumber, DateTime.Parse(pNacDate), pGender, pGenderPref, pEmail, pFaculty, pImageUrl);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public static IActionResult CreateFailedResult(params string[] errors)
{
var model = new ResultResponseModel
{
Errors = errors
};
return(new JsonResult(model));
}
public static IActionResult CreateSucceededResult(string message = null)
{
var model = new ResultResponseModel
{
Success = true,
Message = message
};
return(new JsonResult(model));
}
public HttpResponseMessage Login(string pEmail, string pPassword)
{
try
{
ResultResponseModel result = new ResultResponseModel();
sp_UserSelectByEmail_Result content = _db.GetUserByEmail(pEmail);
if (content == null)
{
result.Result = "Email Incorrecto";
result.Error = new { Error = 201, ErrorMessage = "Verificar Email" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
sp_UserSelectPassword_Result password = _db.GetUserPassword(content.UserId);
if (pPassword == password.Password)
{
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
result.Result = "Contraseña Incorrecta";
result.Error = new { Error = 201, ErrorMessage = "Verificar Contraseña" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Usuario No Encontrado" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public JsonResult CreateBird([FromBody] Bird bird)
{
ResultResponseModel response = new ResultResponseModel();
try
{
response.error = new Error(200, "OK");
}
catch (Exception ex)
{
response.error = new Error(500, ex.Message);
}
return(Json(response));
}
public JsonResult GetSpecies()
{
ResultResponseModel response = new ResultResponseModel();
try
{
SelectQueries query = new SelectQueries();
var result = query.SelectGenuses();
response.data = result;
response.error = new Error(200, "OK");
}
catch (Exception ex)
{
response.error = new Error(500, ex.Message);
}
return(Json(response));
}
public JsonResult FilterBirdByLoc([FromBody] Bird bird)
{
ResultResponseModel response = new ResultResponseModel();
try
{
SelectQueries query = new SelectQueries();
var result = query.FilterBirdLoc(bird);
response.data = result;
response.error = new Error(200, "OK");
}
catch (Exception ex)
{
response.error = new Error(500, ex.Message);
}
return(Json(response));
}
public JsonResult GetHabitatRegion()
{
ResultResponseModel response = new ResultResponseModel();
try
{
SelectQueries query = new SelectQueries();
var region = query.SelectRegions();
var habitat = query.SelectHabitats();
response.data = new { region, habitat };
response.error = new Error(200, "OK");
}
catch (Exception ex)
{
response.error = new Error(500, ex.Message);
}
return(Json(response));
}
public HttpResponseMessage GetUserLikes(string pUserId)
{
try
{
ResultResponseModel result = new ResultResponseModel();
UserLikesModel content = new UserLikesModel();
content.Books = _db.GetUserBookLikes(pUserId);
content.Music = _db.GetUserMusicLikes(pUserId);
content.Sports = _db.GetUserSportLikes(pUserId);
content.Entertainment = _db.GetUserEntertainmentLikes(pUserId);
content.ExpArt = _db.GetUserExpArtsLikes(pUserId);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage UploadImage(ImageModel content)
{
try
{
ResultResponseModel result = new ResultResponseModel();
string url = new BlobServices().UploadPhoto(content.pPhotoEncoded, content.pFileName);
_db.UpdateUserPhoto(content.pUserId, url);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
public HttpResponseMessage GetUserMatch(string pUserId)
{
try
{
ResultResponseModel result = new ResultResponseModel();
_db.FindAllMatch(pUserId);
List <sp_GetUserMatchs_Result> content = _db.GetUserMatch(pUserId);
result.Result = content;
result.Error = new { Error = 200, ErrorMessage = "Ok" };
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (ArgumentNullException)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 400, ErrorMessage = HttpStatusCode.BadRequest };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (EntityCommandExecutionException e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 5004, ErrorMessage = "Device o Customer No Encontrados" };
return(Request.CreateResponse(HttpStatusCode.BadRequest, objresult));
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
catch (Exception e)
{
ResultResponseModel objresult = new ResultResponseModel();
objresult.Error = new { Error = 406, ErrorMessage = e.Message };
return(Request.CreateResponse(HttpStatusCode.NotAcceptable, objresult));
throw new HttpResponseException(HttpStatusCode.NotAcceptable);
}
}
