public class verify_emailController : ApiController
    {
        public readonly NameEntities _db = new NameEntities ();
        
        public verify_email GetVerifyEmail(HttpRequestMessage request, string email = "")
        {
      
        
                var jsonString = request.Content.ReadAsStringAsync().Result;
               LogManager.GetCurrentClassLogger().Info($"Treść żądania: {jsonString}");
                LogManager.GetCurrentClassLogger().Info($"Przed zapytaniem @ {SqlQueries.UsersLoginByEmail(email)}");
                LogManager.GetCurrentClassLogger().Info($"Przed zapytaniem {email}");
              

            

                var kontrahent = _db.Database.SqlQuery<Kontrahent>(SqlQueries.Userss).FirstOrDefault(x => x.SklepLogin == email);
                // var kontrahent = _db.Database.SqlQuery<KontrahentEmail>(SqlQueries.UsersLoginByEmail(email2)).FirstOrDefault(x => x.SklepLogin.ToLower() == email2.ToLower());

                LogManager.GetCurrentClassLogger().Info($"Treść żądania: {SqlQueries.UsersLoginByEmail(email)} kontrahen {kontrahent.Email} id {kontrahent.Id}");


                //  kontrahent = _db.Database.SqlQuery<KontrahentLogin>(SqlQueries.UsersLoginByEmail(email)).FirstOrDefault(x => x.SklepLogin.ToLower() == email.ToLower());
          

            return kontrahent != null

                ? new verify_email() { status = 1, user_id = kontrahent.Id }
                : new verify_email { status = 0 };

        }

    }

}