Ejemplo n.º 1
0
 // DELETE: api/User/5
 public string Delete(string username, string password)
 {
     try
     {
         return(Authouriser.unsubscribeUser(username, password));
     }
     catch (ArgumentException e)
     {
         return(e.Message);
     }
 }
Ejemplo n.º 2
0
 // GET: api/User/5
 public Authouriser Get(string username)
 {
     try
     {
         return(Authouriser.getUserCreditials(username));
     }
     catch (ArgumentException e)
     {
         Debug.WriteLine(e.Message);
         return(null);
     }
 }
Ejemplo n.º 3
0
 // GET: api/User
 public List <Authouriser> Get()
 {
     try
     {
         return(Authouriser.getAllUsersCreditials());
     }
     catch (ArgumentException e)
     {
         Debug.WriteLine(e.Message);
         return(null);
     }
 }
Ejemplo n.º 4
0
        // PUT: api/User/5
        public string Put([FromBody] Authouriser authouriser)
        {
            string username = authouriser.Username;
            string password = authouriser.Password;

            try
            {
                return(Authouriser.resetUserCreditials(username, password));
            }
            catch (ArgumentException e)
            {
                return(e.Message);
            }
        }
Ejemplo n.º 5
0
        // POST: api/User
        public string Post([FromBody] Authouriser authouriser)
        {
            string username = authouriser.Username;
            string password = authouriser.Password;

            string results = null;

            try
            {
                results = Authouriser.craeteCreditials(username, password);
            }
            catch (Exception e)
            {
                results = e.Message;
            }
            return(results);
        }
Ejemplo n.º 6
0
        // Get single user by Id
        public Authouriser getUserFromTheDatabase(string username)
        {
            Authouriser results         = new Authouriser();
            string      connectinString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
            string      query           = string.Format("SELECT [Id],[Username],[Password],[Role] FROM tblAuthouriser WHERE [Username] = '{0}'", username);

            using (SqlConnection conn = new SqlConnection(connectinString))
            {
                using (SqlCommand com = new SqlCommand(query, conn))
                {
                    conn.Open();
                    SqlDataReader reader = com.ExecuteReader();
                    while (reader.Read())
                    {
                        results.Id       = (int)reader["Id"];
                        results.Username = (string)reader["Username"];
                        results.Password = (string)reader["Password"];
                        results.Role     = (string)reader["Role"];
                    }
                    conn.Close();
                }
            }
            return(results);
        }