Exemplo n.º 1
0
        public string Login_Shop(string userName, string password)
        {
            User2         u      = null;
            string        conStr = ConfigurationManager.ConnectionStrings["LIVEDNS"].ConnectionString;
            SqlConnection con    = new SqlConnection(conStr);
            SqlCommand    com    = new SqlCommand(" SELECT * " +
                                                  " FROM Shop_Users " +
                                                  $" WHERE UserName = '******' AND Password = '******' ", con);

            con.Open();
            SqlDataReader reader = com.ExecuteReader();

            if (reader.Read())
            {
                u = new User2()
                {
                    UserID   = int.Parse(reader["UserID"].ToString()),
                    UserName = reader["UserName"].ToString(),
                    Password = reader["Password"].ToString(),
                    FullName = reader["FullName"].ToString(),
                    Email    = reader["Email"].ToString(),
                    Phone    = reader["Phone"].ToString(),
                };
                con.Close();
                return(new JavaScriptSerializer().Serialize(u));
            }
            else
            {
                return(new JavaScriptSerializer().Serialize(null));
            }
        }
Exemplo n.º 2
0
        public string Register_Shop(string userName, string password, string fullName, string email, string phone)
        {
            SqlCommand com        = null;
            string     userOutput = null;

            try
            {
                User2         u      = null;
                string        conStr = ConfigurationManager.ConnectionStrings["LIVEDNS"].ConnectionString;
                SqlConnection con    = new SqlConnection(conStr);
                com = new SqlCommand($"SELECT * FROM Shop_Users WHERE Email = '{email}'", con);
                com.Connection.Open();
                SqlDataReader reader = com.ExecuteReader();
                if (reader.Read())
                {
                    userOutput = new JavaScriptSerializer().Serialize(null);
                    return(userOutput);
                }
                else
                {
                    if (com.Connection.State != ConnectionState.Closed)
                    {
                        com.Connection.Close();
                    }
                    com = new SqlCommand($"INSERT INTO Shop_Users(UserName,Password,FullName,Email,Phone) VALUES" +
                                         $" ('{userName}','{password}','{fullName}','{email}','{phone}')", con);
                    com.Connection.Open();
                    int res = com.ExecuteNonQuery();
                    if (res == 1)
                    {
                        SqlCommand    com2    = new SqlCommand("SELECT max(UserID) as maxID FROM Shop_Users", con);
                        SqlDataReader reader2 = com2.ExecuteReader();
                        if (reader2.Read())
                        {
                            u = new User2()
                            {
                                UserID   = (int)reader2["maxID"],
                                UserName = userName,
                                Password = password,
                                FullName = fullName,
                                Email    = email,
                                Phone    = phone,
                            };
                        }
                        userOutput = new JavaScriptSerializer().Serialize(u);
                        return(userOutput);
                    }
                }
            }
            catch (Exception e)
            {
                File.AppendAllText(Server.MapPath(@"\") + "logSQL.txt", "\r\n" + e.Message +
                                   "\r\n" + DateTime.Now.ToString() +
                                   "\r\nID =" + "\r\n____________________");
            }
            finally
            {
                if (com.Connection.State != System.Data.ConnectionState.Closed)
                {
                    com.Connection.Close();
                }
            }
            return(userOutput);
        }