public static List<User> GetAllUsers() { SqlConnection connection = new SqlConnection(databaseConString); string query = "SELECT * FROM tbl_user"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<User> userList = new List<User>(); while (reader.Read()) { User user = new User(); //user.Id = int.Parse(reader["id"].ToString()); user.UserName = reader["user_name"].ToString(); user.Password = reader["password"].ToString(); user.Email = reader["email"].ToString(); userList.Add(user); } reader.Close(); connection.Close(); return userList; }
public int AddUser(User aUser) { SqlConnection connection = new SqlConnection(databaseConString); string query = "INSERT INTO tbl_user VALUES('" + aUser.FullName + "','" + aUser.Email + "','" + aUser.MobileNo + "','" + aUser.UserName + "','" + aUser.Password + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }
public string AddUser(User aUser) { bool checkUser = IsUserExists(aUser.UserName); if (checkUser) { return "User Allready Exists!"; } if (aUserGateway.AddUser(aUser) > 0) { return "Added Successfully!"; } else { return "Could Not Added!"; } }
public User GetUserName(string userName) { SqlConnection connection = new SqlConnection(databaseConString); string query = "SELECT * FROM tbl_user WHERE user_name = '" + userName + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); User user = null; while (reader.Read()) { if (user == null) { user = new User(); } user.UserName = reader["user_name"].ToString(); } reader.Close(); connection.Close(); return user; }