예제 #1
0
        public bool AddUser2(RequestData rData)
        {
            bool returnBool = false;

            var data = rData.details.Split('|');
            var response = new PersonData
            {
                Name = data[0],
                User = data[1],
                Email = data[2],
                Password = data[3]
            };

            SqlConnection dbConn = new SqlConnection(connStr);
            string sqlStr = "INSERT INTO users(username,name,email,password) values('" + data[0] + "', '" + data[1] + "', '" + data[2] + "', '" + data[3] + "');";
            SqlCommand dbCommand = new SqlCommand(sqlStr, dbConn);
            try
            {
                dbConn.Open();
                if (dbCommand.ExecuteNonQuery() != 0)
                {
                    returnBool = true;
                }
                returnBool = true;
            }
            catch
            {
                returnBool = false;
            }
            dbConn.Close();
            return returnBool;
        }
예제 #2
0
 public bool UpdateUserPut(string user, RequestData rData)
 {
     bool returnBool = false;
     var data = rData.details.Split('|');
     var pd = new PersonData
     {
         Name = data[0],
         User = data[1],
         Email = data[2],
         Password = data[3]
     };
     string username, name, email, password;
     username = pd.User;
     name = pd.Name;
     email = pd.Email;
     password = pd.Password;
     SqlConnection dbConn = new SqlConnection(connStr);
     string sqlStr = "UPDATE users SET username = '******',name = '" + name + "',password = '******',email= '" + email + "' WHERE username = '******' ;";
     SqlCommand dbCommand = new SqlCommand(sqlStr, dbConn);
     try
     {
         dbConn.Open();
         if (dbCommand.ExecuteNonQuery() != 0)
         {
             returnBool = true;
         }
         dbConn.Close();
     }
     catch
     {
         returnBool = false;
     }
     return returnBool;
 }
예제 #3
0
 public PersonData AddJsonUser(RequestData rData)
 {
     return AddUser(rData);
 }