public static int delete(string username) { try { Database db = new Database(); string queryString = "DELETE FROM [dbo].[Users] WHERE [username] = @username"; List<SqlParameter> atrs = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@username",SqlDbType= SqlDbType.NVarChar,Value = username } }; int result = db.execute(queryString, atrs); db.Disconnect(); return result; } catch (Exception ex) { Console.WriteLine(ex.Message); return 0; } }
public static List<User> getAll() { Database db = new Database(); List<User> users = new List<User>(); string queryString = "select * from Users"; SqlDataReader reader = db.query(queryString); if (reader.HasRows) { while (reader.Read()) { User user = new User(); user.Username = reader["username"].ToString(); user.Password = reader["password"].ToString(); user.CreateAt = reader["create_at"].ToString(); users.Add(user); } } db.Disconnect(); return users; }
public static User find(string username) { Database db = new Database(); string queryString = "select * from Users where username = @username"; List<SqlParameter> atrs = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@username",SqlDbType= SqlDbType.NVarChar,Value = username } }; SqlDataReader reader = db.query(queryString, atrs); if (reader.HasRows) { while (reader.Read()) { User user = new User(); user.Username = reader["username"].ToString(); user.Password = reader["password"].ToString(); user.CreateAt = reader["create_at"].ToString(); return user; } } db.Disconnect(); return null; }
public static int save(User user) { try { Database db = new Database(); string queryString = "INSERT INTO [dbo].[Users]([username],[password],[create_at]) VALUES(@username,@password,GETDATE())"; List<SqlParameter> atrs = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@username",SqlDbType= SqlDbType.NVarChar,Value = user.Username }, new SqlParameter() {ParameterName = "@password",SqlDbType= SqlDbType.NVarChar,Value = user.Password } }; int result = db.execute(queryString, atrs); db.Disconnect(); return result; } catch (Exception ex) { Console.WriteLine(ex.Message); return 0; } }
public static int update(User user) { try { Database db = new Database(); string queryString = "UPDATE [dbo].[Users] SET [password] = @password WHERE [username] = @username"; List<SqlParameter> atrs = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@username",SqlDbType= SqlDbType.NVarChar,Value = user.Username }, new SqlParameter() {ParameterName = "@password",SqlDbType= SqlDbType.NVarChar,Value = user.Password } }; int result = db.execute(queryString, atrs); db.Disconnect(); return result; }catch(Exception ex) { Console.WriteLine(ex.Message); return 0; } }