public ActionResult Post([FromBody] userRequest req) { using (SqlConnection con = new SqlConnection(_connectionString)) { List <string> errors = new List <string>(); var userValidator = new UserValidation(); var result = userValidator.Validate(req); if (result.IsValid) { con.Open(); SqlCommand command = new SqlCommand("insert into Users values(@Name,@LastName,@EMail,@Adress)", con); command.Parameters.Add("@Name", SqlDbType.VarChar).Value = req.name; command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = req.lastname; command.Parameters.Add("@EMail", SqlDbType.VarChar).Value = req.email; command.Parameters.Add("@Adress", SqlDbType.VarChar).Value = req.adress; try { SqlDataReader reader = command.ExecuteReader(); } catch (System.Exception ex) { System.Console.WriteLine(ex.Message); } } foreach (var i in result.Errors) { errors.Add($"ERROR!! {i.PropertyName} : {i.ErrorMessage}"); } return(new JsonResult(errors)); } }
public IActionResult Login([FromBody] userRequest userData) { userResponse usersRespo = new userResponse(); try { string userName = userData.username; string password = userData.password; // var item = _context.users.FirstOrDefault(data => (data.username == userName && data.password == password)); var data = _context.users.Where(user => user.username == userName && user.password == password).Select(user => user.username); if (_context.users.Where(user => user.username == userName && user.password == password).Select(user => user.username).Any()) { System.Console.WriteLine("data" + data); usersRespo.username = userName; usersRespo.message = "successfully logged In"; return(StatusCode((int)HttpStatusCode.OK, usersRespo)); } usersRespo.username = null; usersRespo.message = "Incorrect username and password"; return(StatusCode((int)HttpStatusCode.Unauthorized, usersRespo)); } catch (Exception ex) { return(StatusCode((int)HttpStatusCode.InternalServerError, ex.Message)); } }
public object addVoiceModel(userRequest req) { /*if (!checkCookie(Request, req.email)) * { * throw new HttpResponseException( * new HttpResponseMessage(HttpStatusCode.Unauthorized) { ReasonPhrase = "User not authorized!" } * ); * }*/ req.authToken = "no yandex"; req.voiceSample.password = "******"; var usr = dbLogic.getUser(req.email); if (usr == null) { var modelsToRecord = BiometricsLogic.createPerson( req.email, req.voiceSample.password, req.voiceSample.data ); return(new { count = modelsToRecord, password = "******" }); } else { var res = BiometricsLogic.addVoiceModel( req.email, req.voiceSample.password, req.voiceSample.data, usr.VoiceModels ); usr.VoiceModels++; dbLogic.updateUser(usr.Id, usr); return(new { count = res, password = "******" }); } }