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 = "******" });
}
}
