public static int AddUser(string name, string username, string password, string type) { ConnectToDatabase c = new ConnectToDatabase(); c.ConnectToDB(); string query = "INSERT INTO users (Name,Username,Password,type) values ( '" + name + "' , '" + username + "' , '" + password + "', '" + type + "')"; int result = c.UpdateQuery(query); c.CloseConnection(); return(result); }
public static DataSet Authenticate(string userName, string password) { try { ConnectToDatabase c = new ConnectToDatabase(); c.ConnectToDB(); string query = "select * from Users where Username='******' AND Password='******' "; DataSet tempData = c.ExceuteQuerySet(query, "Users"); c.CloseConnection(); if (tempData.Tables[0].Rows.Count == 1) //Credentials matched with one record { return(tempData); //return type of user } else { return(null); } } catch { return(null); } }