/// <summary>
/// 讀取積分
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public List <UserWin> GetWin(UserWin data)
{
string connStr = "data source=werewolfkill.database.windows.net;initial catalog=Werewolfkill;persist security info=True;user id=Werewolfkill;password=Wolfpeoplekill_2020;MultipleActiveResultSets=True;";
List <UserWin> r = null;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
var paramater = new Models.UserWin {
Email = data.Email
};
var sql = "select * from AspNetUsers where Email = @Email";
r = conn.Query <UserWin>(sql, paramater).ToList();
}
return(r);
}
private void Enter_Click(object sender, RoutedEventArgs e)
{
var user = context.Users.ToList().
Where(i => i.logim == login.Text && i.password == password.Password).
FirstOrDefault();
if (user != null)
{
usersData = user;
UserWin userWin = new UserWin();
this.Hide();
userWin.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("Ползователь не найден!!!");
}
}
public IActionResult GetWin(UserWin data)
{
return(Ok(_service.GetWin(data)));
}
public IActionResult postwin(UserWin data)
{
return(Ok(_service.PostWin(data)));
}
public List <UserWin> GetWin(UserWin data)
{
return(_repo.GetWin(data));
}
public List <UserWin> PostWin(UserWin data)
{
return(_repo.PostWin(data));
}
