public List <User> LoingPostpic(LoingPostpic 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 <User> r = null; using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); var paramater = new Models.LoingPostpic { Email = data.Email }; var sql = "select Pic,win,Id,Email as email from AspNetUsers where Email = @Email"; r = conn.Query <User>(sql, paramater).ToList(); } return(r); }
public IActionResult LoingPostpic(LoingPostpic data) { return(Ok(_service.LoingPostpic(data))); }
public List <User> LoingPostpic(LoingPostpic data) { return(_repo.LoingPostpic(data)); }